GTL Summary Statistic Functions

The following functions return a numeric constant, based on a summary operation on a numeric column. The results are the same as if the corresponding statistics were requested with PROC SUMMARY. These functions take a single argument that resolves to the name of a numeric column. These functions take precedence over similar multi-argument DATA step functions.
number = EVAL(function-name(numeric-column))
Function Name
Description
CSS
Corrected sum of squares
CV
Coefficient of variation
KURTOSIS
Kurtosis
LCLM
One-sided confidence limit below the mean
MAX
Largest (maximum) value
MEAN
Mean
MEDIAN
Median (50th percentile)
MIN
Smallest (minimum) value
N
Number of nonmissing values
NMISS
Number of missing values
P1
1st percentile
P5
5th percentile
P25
25th percentile
P50
50th percentile
P75
75th percentile
P90
90th percentile
P95
95th percentile
P99
99th percentile
PROBT
p-value for Student’s t statistic
Q1
First quartile
Q3
Third quartile
QRANGE
Interquartile range
RANGE
Range
SKEWNESS
Skewness
STDDEV
Standard deviation
STDERR
Standard error of the mean
SUM
Sum
SUMWGT
Sum of weights
T
Student’s t statistic
UCLM
One-sided confidence limit above the mean
USS
Uncorrected sum of squares
VAR
Variance