Hi:
PROC TABULATE is a SAS procedure that can create summary tables based on your data. You can request many statistics other than the N (count) and the SUM. But those are the default statistics that TABULATE generates for you based on whether your variables are character or numeric.
TABULATE expects all your variables for the TABLE to be declared as either CLASS for making groups or VAR for performing analysis. You can then use a TABLE statement to instruct PROC TABULATE what kind of table structure you want and what statistics and crossings you want. Your summary table can be a one dimension table of only columns or it can be a two dimension table of columns and rows or it can be a three dimension table of columns, rows and pages.
TABULATE uses table operators to arrange the structure of the table. The TABLE operators are comma (new dimension), space (stack or concatenate tables) and < or > symbols (specify a denominator for a custom percent). In addition, there is a special CLASS variable called ALL that allows you to generate subtotals and grand totals in any dimension.
The statistics that you generate can be as simple as N or SUM, but there are many other statistics like MIN, MEAN, MAX, CSS, STD, MEDIAN, etc. Look in the TABULATE documentation for the full list.
The code below shows only 1 and 2 dimension tables because that's all you probably need for what you want to do.
SASHELP.CLASS has 19 rows and 5 variables: NAME, AGE, SEX, HEIGHT and WEIGHT. The following program has examples of different tables all produced with PROC TABULATE to provide you with an overview.
You said you are new to TABULATE, but other than creating the data with your program, what other code have you tried? PROC FREQ? PROC UNIVARIATE? Data Step? If you have a program that creates data, did you try any other code. Did your program even work to make data? Because the way I interpret your posted example, your INPUT statement is incorrect because you don't have a $ for SEX or EMPLOYMENT variables and you don't specify a length for EMPLOYMENT. So I used SASHELP.CLASS instead of your data -- it gave me more variables and more rows for example purposes.
proc print data=sashelp.class;
title 'What data is in sashelp.class';
run;
proc tabulate data=sashelp.class;
title '1) One Dimension table';
class age;
table n*(age all);
keylabel n='Count';
run;
proc tabulate data=sashelp.class;
title '2) Simple Frequency Example';
class age ;
table age all='Total',
n='Count';
run;
proc tabulate data=sashelp.class;
title '3) Two Dimension table';
class sex age ;
table age all='Total',
n='Count'*sex all='Total';
run;
proc tabulate data=sashelp.class;
title '4) Getting Statistics';
class sex age ;
var height weight;
table age all='Overall',
(n='Count') mean*height*sex=' ' (mean css std)*weight*sex=' ';
run;
proc tabulate data=sashelp.class;
title '5) Tabulate Percent Example';
class sex age;
table sex*(age all) all,
n pctn='% of Total' pctn<age all>='% of Group';
run;
I hope this helps provide you with an understanding of PROC TABULATE.
cynthia
Click image to register for webinar
