PROCESSING STAGE

Aggregator Stage

Calculation and Recalculation Dependent Properties

The following properties are dependents of both Column for Calculation and Summary Column for Recalculation. These specify the various aggregate functions and the output columns to carry the results.

Corrected Sum of Squares. Produces a corrected sum of squares for data in the aggregate column and outputs it to the specified output column.

Maximum Value. Gives the maximum value in the aggregate column and outputs it to the specified output column.

Mean Value. Gives the mean value in the aggregate column and outputs it to the specified output column.

Minimum Value. Gives the minimum value in the aggregate column and outputs it to the specified output column.

Missing Value. This specifies what constitutes a ‘missing’ values, for example -1 or NULL. Enter the value as a floating point number. Not available for Summary Column to Recalculate.

Missing Values Count. Counts the number of aggregate columns with missing values in them and outputs the count to the specified output column. Not available for Recalculate.

Non-missing Values Count. Counts the number of aggregate columns with values in them and outputs the count to the specified output column.

Percent Coefficient of Variation. Calculates the percent coefficient of variation for the aggregate column and outputs it to the specified output column.

Range. Calculates the range of values in the aggregate column and outputs it to the specified output column.

Standard Deviation. Calculates the standard deviation of values in the aggregate column and outputs it to the specified output column.

Standard Error. Calculates the standard error of values in the aggregate column and outputs it to the specified output column.

Sum of Weights. Calculates the sum of values in the weight column specified by the Weight column property and outputs it to the specified output column.

Sum. Sums the values in the aggregate column and outputs the sum to the specified output column.

Summary. Specifies a subrecord to write the results of the calculate or recalculate operation to.

Uncorrected Sum of Squares. Produces an uncorrected sum of squares for data in the aggregate column and outputs it to the specified output column.

Variance. Calculates the variance for the aggregate column and outputs the sum to the specified output column. This has a dependent property:

Variance divisor. Specifies the variance divisor. By default, uses a value of the number of records in the group minus the number of records with missing values minus 1 to calculate the variance. This corresponds to a vardiv setting of Default If you specify NRecs, the operator uses the number of records in the group minus the number of records with missing values instead.