7.00.02 - Sample Arguments - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)
SampleFraction
Specifies one or more fractions to use in sampling the data. (Syntax options that do not use SampleFraction require ApproxSampleSize.)

If you specify only one fraction, then the function uses fraction for all strata defined by the sample conditions.

If you specify more than one fraction, then the function uses each fraction for sampling a particular stratum defined by the condition arguments.

For conditional sampling with variable sample sizes, specify one fraction for each condition that you specify with the Strata argument.
Seed
[Optional] Specifies an integer to add to each task ID to create a real random seed for the task. Default: 0.
ApproxSampleSize
[Optional] Specifies one or more approximate sample sizes to use in sampling the data. (Syntax options that do not use ApproxSampleSize require SampleFraction.) Each sample size is approximate because the function maps the size to the sample fractions and then generates the sample data.

If you specify only one size, it represents the total sample size for the entire population. If you also specify the Strata argument, the function proportionally generates sample units for each stratum.

If you specify more than one size, then each size corresponds to a stratum, and the function uses each size to generate sample units for the corresponding stratum.

For conditional sampling with variable approximate sample sizes, specify one size for each condition that you specify with the Strata argument.
StratumColumn
[Optional] Specifies the name of the column that contains the sample conditions. If the function has only one input table (the data table), then column is in the data table. If the function has two input tables, data and summary, then column is in the summary table.
Strata
[Required if you specify StratumColumn.] Specifies the sample conditions that appear in the column specified by StratumColumn. If Strata specifies a condition that does not appear in column, then the function issues an error message.