second period proc tabulate l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Second Period: PROC TABULATE PowerPoint Presentation
Download Presentation
Second Period: PROC TABULATE

Loading in 2 Seconds...

play fullscreen
1 / 15

Second Period: PROC TABULATE - PowerPoint PPT Presentation


  • 158 Views
  • Uploaded on

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="Region of Residence"*PCTN<HYPER>=“ “ ; RUN ;. Simple 2D Table :. Example 2:.

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

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


An Image/Link below is provided (as is) to download presentation

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
example 1

Example 1:

Simple 2D Table

simple 2d table

Simple 2D Table :

PROC TABULATEDATA=FINAL FORMAT=PCT.;

CLASSHYPER REGION;

WEIGHTPWGTQ;

TABLESHYPER,

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

;

RUN;

example 2

Example 2:

A Little More Complicated …

table with nested class variables

Table with Nested Class Variables :

PROC TABULATEDATA=FINAL FORMAT=PCT.;

CLASSBMICAT SEX AGEGRP;

WEIGHTPWGTQ;

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

;

RUN;

example 3

Example 3:

Multiple Statistics

table with 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 statistics10

Table with Multiple Statistics:

Example 3:

Blood Lipids Statistics by Region

example 4

Example 4:

Adding Subtotals

table with subtotals

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;

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)

Advantages

for more information

Proc Tabulate by Example, by Lauren E. Haworth

  • SUGI and SAS Global Forum Proceedings (http://support.sas.com/events/sasglobalforum/previous/online.html)

For More Information: