Creating Reports in SAS By Ryan Davidson Aims

Creating Reports in SAS By Ryan Davidson

Aims and Objectives To understand the different reports that can be created in SAS To use SAS to create a report To understand the features of the reports

Types of Reports Detailed Reports Lists information at the observation level of a data set. Procedures: PRINT, REPORT, SQL (Structured Query Language), MEANS, SUMMARY, UNIVARIATE.

Types of Reports Summary Reports Summarize observations and produce output such as frequency counts and descriptive statistics. Procedures: PRINT, REPORT, SQL TABULATE.

Types of Reports Customized Reports List information in a style that is different than the standard output from a SAS procedure. Often theses are produced with DATA step programming. DATA step.

Types of Reports Multipanel Reports Present multiple rows of information side-by-side. Procedure: All procedures when sending output to a non-listing destination.

Example Raw Data

Example code PROC MEANS VAR statement = lap times CLASS statement = driver

Results A basic summary report By default displays the minimum, maximum and mean of the values.

Singling out statistics By adding “min” and “maxdec=2” this singles out the lowest time to two decimal places.

Results This produces a more defined report with the exact data output that we needed. All values are a maximum of 2 decimal places The quickest lap times are shown

Adding Average Lap Times Chart Example code to create a chart:

Using PROC REPORT This creates a simple report using the PROC REPORT function in SAS.

Formatting BREAK and other statements can be used to format the report.

Summary/conclusion The report was successfully created using SAS and using different methods to create the basis for a report which included a graph and charts to show the main statistics.

Bibliography: SAS (2015) [online] Writing Reports with SAS http: //support. sas. com/publishing/pubcat/chaps/59602. pdf SAS Software (2015) [online] Create a Basic Summary Report Using SAS https: //www. youtube. com/watch? v=76 Gm. U 5 q-Ilo SAS Software (2015) [online] Create a Simple Bar Chart Using SAS https: //www. youtube. com/watch? v=M-t. Cp. WIF 564 SAS (2015) [online] Creating Complex Reports http: //www 2. sas. com/proceedings/forum 2008/1732008. pdf C. Moriak, (2015) [online] SO YOU WANT TO LEARN PROC REPORT http: //www. albany. edu/~msz 03/epi 697/ho/reportc. pdf