Second Period: PROC TABULATE

1 / 15

# Second Period: PROC TABULATE - PowerPoint PPT Presentation

Second Period: PROC TABULATE. Jill Casey. Example 1:. Simple 2D Table. Simple 2D Table :. PROC TABULATE DATA=FINAL FORMAT=PCT.; CLASS HYPER REGION; WEIGHT PWGTQ; TABLES HYPER, REGION=&quot;Region of Residence&quot;*PCTN&lt;HYPER&gt;=“ “ ; RUN ;. Simple 2D Table :. Example 2:.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

## PowerPoint Slideshow about 'Second Period: PROC TABULATE' - noah

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

Jill Casey

Simple 2D Table

### Simple 2D Table :

PROC TABULATEDATA=FINAL FORMAT=PCT.;

CLASSHYPER REGION;

WEIGHTPWGTQ;

TABLESHYPER,

REGION="Region of Residence"*PCTN<HYPER>=“ “

;

RUN;

### Example 2:

A Little More Complicated …

### Table with Nested Class Variables :

PROC TABULATEDATA=FINAL FORMAT=PCT.;

CLASSBMICAT SEX AGEGRP;

WEIGHTPWGTQ;

TABLESSEX=""*AGEGRP=""*PCTN<BMICAT>="", BMICAT="BMI Distribution“

;

RUN;

### Example 3:

Multiple Statistics

### Table with Multiple Statistics:

PROC TABULATEDATA=FINAL FORMAT=8.1;

CLASSREGION;

VARCHOL LDL HDL TRIG;

WEIGHTPWGTC;

TABLESREGION*(MIN MAX MEAN MEDIAN),

CHOL LDL HDL TRIG

;

RUN;

### Table with Multiple Statistics:

Example 3:

Blood Lipids Statistics by Region

### Table with Subtotals :

PROC TABULATEDATA=FINAL FORMAT=PCT.;

CLASSREGION AGEGRP CVDRISK;

WEIGHTPWGTC;

TABLES(REGION ALL="Nova Scotia")*

(AGEGRP="" ALL="Region Total")* PCTN<CVDRISK>="“

,

CVDRISK="Cardiovascular Disease Risk"

;

RUN;