Section 8.2: Descriptive Statistics

Summary Statistics Available in PROC TABULATE

The following keywords request statistics in the TABLE statement or specify statistic 
keywords in the KEYWORD or KEYLABEL statement. If a variable name (class or analysis) 
and a statistic name are the same, then enclose the statistic name in single quotation 
marks -- for example, 'MAX'.

Descriptive statistic keywords

DATA indat;
DROP y1 y2 y3;
INPUT group subject y1 y2 y3;
time=1; y=y1; OUTPUT;
time=2; y=y2; OUTPUT;
time=3; y=y3; OUTPUT;
CARDS;
1 1 12.50 11.98 10.70
1 2 14.11 13.50 11.48
1 3 12.20 11.56 10.74
;

* incorrectly assuming independence can calculate summary stats;


PROC TABULATE DATA=indat Noseps alpha=0.05;
CLASS group;
VAR y;
TABLE group, y*(lclm*f=7.2 mean*f=6.2 uclm*f=7.2 var*f=8.4 STDdev*f=8.4
             n='Nobs'*f=6.0 STDERR*f=8.4) / rts=9;
RUN;

The ALPHA= option in the PROC TABULATE statement to specify a confidence level (.05 is 
the default, but is entered here for illustration).

Enter both LCLM and UCLM to compute a two-sided confidence limit for the mean. Enter 
only LCLM or UCLM to compute a one-sided confidence limit.



MEAN UCLM LCLM STDDEV|STD MIN MAX N NMISS RANGE STDERR SUM VAR

KURTOSIS | KURT
CSS
CV
SKEWNESS | SKEW
SUMWGT
USS   


Quantile statistic keywords

P1 P5 P10 Q1|P25 MEDIAN|P50 Q3|P75 P90 P95 P99

QRANGE


Hypothesis testing keywords

PROBT
T


To compute standard error of the mean (STDERR) or Student's t-test, you must enter the 
default value of the VARDEF= option, which is DF, specified in the PROC TABULATE 
statement.