Aggregated (Advanced) Operators :: SAS® Visual Analytics 7.4: User's Guide

CoefVar

calculates the coefficient of variation of a measure. The coefficient of variation is the ratio of the standard deviation to the mean.

CSS

calculates the corrected sum of squares of a measure. The corrected sum of squares is the sum of the squared deviations from the mean.

First

calculates the first value of a measure based on chronological order. The first parameter specifies the measure. The second parameter specifies the sequence data item that is used to determine the chronological order. The sequence data item can be either a date or time data item or a numeric data item. The third parameter specifies whether missing values are included. Select _IncludeMissing_ to include missing values or select _ExcludeMissing_ to exclude missing values.

Note: If there are multiple measure values for the first value of the sequence data item, then the minimum measure value is selected.

Note: The First aggregation always calculates measure values by using the sequence data item that you specify. If your visualization or report object uses a different date or time data item, then the results might be misleading to viewers who do not know the expression for the aggregated data item.

Kurtosis

calculates the kurtosis of a measure. The kurtosis value indicates how peaked the distribution is. A larger value indicates a more sharply peaked distribution. A smaller value indicates a flatter distribution.

Last

calculates the last value of a measure based on chronological order. The first parameter specifies the measure. The second parameter specifies the sequence data item that is used to determine the chronological order. The sequence data item can be either a date or time data item or a numeric data item. The third parameter specifies whether missing values are included. Select _IncludeMissing_ to include missing values or select _ExcludeMissing_ to exclude missing values.

Note: If there are multiple measure values for the last value of the sequence data item, then the minimum measure value is selected.

Note: The Last aggregation always calculates measure values by using the sequence data item that you specify. If your visualization or report object uses a different date or time data item, then the results might be misleading to viewers who do not know the expression for the aggregated data item.

Percentile

calculates the specified percentile of a measure. Specify a number between 0 and 100. For example, 85 specifies the 85th percentile, the value for which 85% of the values are lower.

PvalT

calculates the probability of observing the t statistic value or a more extreme value. A small value indicates that the mean is likely not equal to zero.

Skewness

calculates the skewness of a measure. Skewness indicates the distribution of values. A positive value indicates that the distribution is heavier for values greater than the mean. A negative value indicates that the distribution is heavier for values less than the mean.

TStat

calculates the Student’s t statistic for a measure, assuming a mean value of zero.

USS

calculates the uncorrected sum of squares of a measure. The uncorrected sum of squares is the sum of the squared values.