Aggregated (Simple) Operators

Avg
calculates the average (mean) value of a measure.
Count
calculates the total number of nonmissing values of a measure.
Distinct
calculates the number of distinct values in a category. If the category contains missing values, then the distinct count is increased by one.
Max
calculates the largest value of a measure.
Median
calculates the median value of a measure.
Min
calculates the smallest value of a measure.
NumMiss
calculates the number of missing values in a data item.
Q1
calculates the first quartile of a measure.
Q3
calculates the third quartile of a measure.
StdDev
calculates the standard deviation of a measure.
StdErr
calculates the standard error of the mean of a measure.
Sum
calculates the sum (total) of the values of a measure.
Var
calculates the variance of a measure.