Download
sas proc report proc tabulate n.
Skip this Video
Loading SlideShow in 5 Seconds..
SAS PROC REPORT PROC TABULATE PowerPoint Presentation
Download Presentation
SAS PROC REPORT PROC TABULATE

SAS PROC REPORT PROC TABULATE

824 Views Download Presentation
Download Presentation

SAS PROC REPORT PROC TABULATE

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

  1. SASPROC REPORTPROC TABULATE Computing for Research I January 27, 2014

  2. PROC REPORT

  3. Proc Report Intro • Similar to Proc Print, with more control over output appearance and format • Produces detail reports (data listings) and summary reports

  4. Proc Report Syntax Basics PROC REPORT data=dataset <options>; COLUMN var1 var2 var3; DEFINE var1 / <options>; DEFINE var2 / <options>; RUN;

  5. Proc Report Statement • DATA= input data set • NOWD/NOWINDOWS Option - non-interactive mode • Additional Options - control layout of the report • COLWIDTH= • MISSING • SPLIT=‘character’ • SPANROWS (for ODS only) • STYLE<(location(s))>=<style-element-name><[style-attribute-specification(s)]> (for ODS only)

  6. Other Statements Column Statement - describes the arrangement of columns and column headers that span >1 column Define Statement • Variable Appearance (format, label, justify) • Variable Usage DISPLAY – default for character variables ANALYSIS – default for numeric variables ORDER – determines row order ORDER=FORMATTED | INTERNAL | DATA | FREQ GROUP – consolidates unique values of GROUP variables into one row Rbreak Statement - produces a default summary at the beginning or end of a report or at the beginning or end of each BY group.

  7. Vital Signs Dataset • SubjectID (47 subjects) • VisitID (1-16), Visit Nm (Baseline, Day 1 – Day 15) • SBP, DBP, Heart Rate, Central Venous Pressure • 1 record per subject per visit

  8. Proc Report Code: Example 1 title'Baseline and Day 1 Blood Pressure' ; procreportdata=vitals nowdsplit='*'; where visitid in (1,2) and 1020 le subjectid le 1029; columns subjectid visitnm ('Blood*Pressure' SBP DBP); define subjectid / 'Subject'order; define visitnm / 'Visit' ; define SBP / 'Systolic'format=8.center; define DBP / 'Diastolic'format=8.center; run;

  9. Proc Report Output: Example 1

  10. Proc Print Comparison: Example 1 procsortdata=vitals; by subjectid; run; procprintdata=vitals labelnoobs; where visitid in (1,2) and 1020 le subjectid le 1029; var subjectid visitnm SBP DBP; run;

  11. Proc Report Code: Example 2 odsrtf; title'Average Blood Pressure by Visit'; procreportdata=vitals nowdsplit='*' style(header)=[fontsize=14pt textalign=center foreground=white background=black]; columns visitnm ('Average*Blood Pressure' SBP DBP); define visitnm / 'Visit'grouporder=data; define SBP / 'Systolic'format=8.centermean; define DBP / 'Diastolic'format=8.centermean; rbreakafter /summarize; run; odsrtfclose;

  12. Proc Report Output: Example 2

  13. Proc Means Comparison: Example 2 odsrtf; title'Average Blood Pressure by Visit'; procmeansdata=vitals mean; class visitnm; var SBP DBP; run; odsrtfclose;

  14. Proc Report Resources • SAS Documentation • Learning Proc Report • http://www2.sas.com/proceedings/forum2008/170-2008.pdf • Proc Report Advanced Tutorial • http://www2.sas.com/proceedings/sugi28/015-28.pdf

  15. PROC TABULATE

  16. Proc Tabulate Intro • Similar to Proc Means and Proc Freq, in tabular format • Creates summary reports with descriptive statistics

  17. Proc Tabulate Syntax Basics PROC TABULATE data=dataset; CLASSclassification variables; VARanalysis variables; TABLEpage dimension, row dimension, column dimension / <options>; RUN;

  18. Class and Var Statements Class Statement • identifies the class variables (character or numeric) • determines the categories that Proc Tabulate uses to calculate statistics • Missing Option - if not included, observations with any missing class variable values are excluded from the table Var Statement • Identifies numeric variables to use as analysis variables.

  19. Table Statement • Required for procedure • Describes the table to create • Format: page variables, row variables, column variables • Can include variable names, keyword statistics, and operators • Options • PRINTMISS • MISSTEXT= • BOX=

  20. Table Statement Operators • Comma – starts a new dimension • Blank – concatenates elements • Asterisk – creates categories from the combination of values of the class variables and calculates appropriate statistics if class and analysis variables are crossed • Parentheses – groups elements, associates operator with each element in the group

  21. Table Statement Statistic Keywords N NMISS PCTN COLPCTN ROWPCTN MEAN STD MIN MAX MEDIAN Q1 Q3 many more…

  22. Other Statements • KEYLABEL – labels a statistic keyword • KEYWORD – specifies a style element for keyword headings • CLASSLEV – specifies a style element for class variable level value headings

  23. Proc Tabulate Code: Example 1 proctabulatedata=vitals; where visitid in (1,2) and 1020 le subjectid le 1029; class subjectid visitnm; table all subjectid, (visitnm='Visits')*(n pctn='%') / box=[label='Subjects x Visits'] misstext='MISSING'printmiss; run;

  24. Proc Tabulate Output: Example 1

  25. Example 1: Proc Freq Comparison procfreqdata=vitals; where visitid in (1,2) and 1020 le subjectid le 1029; table subjectid*visitnm /norownocol; run;

  26. Proc Tabulate Code: Example 2 title'Average Blood Pressure Across Baseline and Day 1'; proctabulatedata=vitals; where visitid in (1,2) and 1020 le subjectid le 1029; class subjectid ; var SBP DBP; table all subjectid, (SBP DBP)*(n mean*f=8.1 std*f=8.1); keylabelstd='SD'; run;

  27. Proc Tabulate Output: Example 2

  28. Example 2: Proc Means Comparison procmeansdata=vitals meanstd; where visitid in (1,2) and 1020 le subjectid le 1029; class subjectid; var SBP DBP; run;

  29. Proc Tabulate Resources • SAS Documentation • Proc Tabulate Introduction http://www.sascommunity.org/mwiki/images/4/49/Proc_Tabulate_how_to_-_version_2.0.pdf • Using Style Elements in the REPORT and TABULATE Procedures http://support.sas.com/resources/papers/stylesinprocs.pdf

  30. Reporting Data • Plan the layout • Summary statistics, analysis output or data listings? • Content of columns/rows? • Order of columns/rows? • Font • Use a report writing tool

  31. QUESTIONS?