1
22S:166
Computing in Statistics
Proc tabulate
Lecture 19
Nov. 12, 2070
Kate Cowles
374 SH, 335-0727
2
Proc tabulate
•displays descriptive statistics in tabular for-
mat
•can create variety of tables ranging from sim-
ple to complex and highly customized
•computes many of same statistics reported
from proc means and proc freq
•flexibility in classifying values of variables and
establishing a hierarchical relationship between
variables
•mechanism for labeling and formatting vari-
ables and procedure- generated statistics
3
Example 1
from
http://ftp.sas.com/techsup/download/sample/base/tabulate/tabformat_classva
PROC TABULATE Sample
--------------------
USAGE: User would like to format the CLASS varia bles and ANALYSIS
variables.
METHOD: Use a FORMA T statement to format the CLASS variables. Use
the format modifier on the TABLE statement to f ormat the
analysis variables.
DATE CREATED: 2-19-97
4
SAMPLE CODE:
data sales;
input name $ region $ product $ sales;
cards;
SMITH A CANDY 22000.
SMITH A CHIPS 10000.
JONES A CANDY 25000.
JONES A CHIPS 5000.
JOHNSON B CANDY 12000.
JOHNSON B CHIPS 15000.
ADAMS B CANDY 10000.
ADAMS B CHIPS 8000.
;
proc format; /* Create user-defined format */
value $fmtx ’A’=’CARY’
’B’=’RALEIGH’;
proc tabulate data=sales;
/*-----------------------------------------------------*/
/* Use FORMAT stmt. to assign format to CLASS variable */
/* Use *F= to assign a format to an ANALYSIS variable */
/*-----------------------------------------------------*/
format region $fmtx.;
class name region;
var sales;
table region*name, sales*(sum n)*f=comma8.;
run
;
