Second Period: PROC TABULATE

1
Second Period PROC TABULATE

• Jill Casey

2
Example 1

• Simple 2D Table

3
Simple 2D Table

• PROC TABULATE DATAFINAL FORMATPCT.
• CLASS HYPER REGION
• WEIGHT PWGTQ
• TABLES HYPER,
• REGION"Region of Residence"PCTNltHYPERgt
  
• RUN

4
Simple 2D Table

5
Example 2

• A Little More Complicated

6
Table with Nested Class Variables

• PROC TABULATE DATAFINAL FORMATPCT.
• CLASS BMICAT SEX AGEGRP
• WEIGHT PWGTQ
• TABLES SEX""AGEGRP""PCTNltBMICATgt"",
  BMICAT"BMI Distribution
• RUN

7
Table with Nested Class Variables

•  

8
Example 3

• Multiple Statistics

9
Table with Multiple Statistics

• PROC TABULATE DATAFINAL FORMAT8.1
• CLASS REGION
• VAR CHOL LDL HDL TRIG
• WEIGHT PWGTC
• TABLES REGION(MIN MAX MEAN MEDIAN),
• CHOL LDL HDL TRIG
• RUN

10
Table with Multiple Statistics
Example 3 Blood Lipids Statistics by Region
11
Example 4

• Adding Subtotals

12
Table with Subtotals

• PROC TABULATE DATAFINAL FORMATPCT.
• CLASS REGION AGEGRP CVDRISK
• WEIGHT PWGTC
• TABLES (REGION ALL"Nova Scotia")
• (AGEGRP"" ALL"Region Total")
  PCTNltCVDRISKgt"
• ,
• CVDRISK"Cardiovascular Disease Risk"
• RUN

13
Example 4 Adding Subtotals
14

• Advantages

• Include data from many variables
• Compute a variety of statistics in one table (all
  the basic stats available in Proc Means)
• Compute summary statistics for categorical
  variables (N, NMISS, PCTN)

15

• For More Information

• Proc Tabulate by Example, by Lauren E. Haworth
• SUGI and SAS Global Forum Proceedings
  (http//support.sas.com/events/sasglobalforum/prev
  ious/online.html)