Course Description

Description

This course focuses on producing detail reports with the REPORT procedure and summary reports with the REPORT, TABULATE, MEANS, and FREQ procedures. Coverage of the FORMAT procedure includes using temporary and permanent user-defined formats and using PICTURE formats to enhance reports. The course also covers ODS-specific topics, with a discussion of routing SAS output using the Output Delivery System (ODS) and an introduction to the STYLE= statement-level method of altering PRINT, TABULATE, and REPORT procedure output. Also covered is the creation and use of cascading style sheets with ODS HTML to provide presentation and style characteristics suitable for viewing with a Web browser. Topics related to the DATA step are covered, including using ODS and the DATA step to produce tabular reports for HTML, RTF, and PDF destinations and a self-study section on creating reports designed exclusively for the Listing destination. Hands-on demonstrations illustrate how to produce summary charts and graphs with the SAS/GRAPH facility and how to route SAS/GRAPH output to ODS destinations.

Prerequisite Skills

Before attending this course, you should have completed the SAS Essentials: An Introduction to SAS Programming course or have at least six months of SAS programming experience. You should be able to;

• use and understand the syntax of basic SAS procedures such as PROC PRINT and PROC SORT
• use the DATA step to read external files and create, subset, and merge SAS data sets
• control DATA step logic using IF-THEN/ELSE statements and logical operators.

SAS Modules Used

Base SAS

SAS/GRAPH

Course Topics

Understanding Basic Report Procedures

Starting with the PRINT procedure

Using the REPORT procedure for detail reports

Doing more with the FORMAT procedure

Creating Summary Reports with the REPORT Procedure

Defining and using group variables

Doing more with PROC REPORT

Creating Summary Reports with the TABULATE Procedure

Using basic TABULATE procedure statements

Changing PROC TABULATE defaults

Doing more with PROC TABULATE

Understanding ODS Basics

Learning ODS basics

Using the ODS Report destinations (HTML, RTF, and PDF)

Creating Summary Graphs with SAS/GRAPH Software

Reporting with SAS/GRAPH software

GCHART and GPLOT procedure syntax (self-study)

Doing More with ODS

Enhancing ODS output

Using STYLE= overrides to enhance output

Using cascading style sheets with ODS HTML

Other Methods for Producing Summary Reports

Producing other types of summary reports

Creating summary data sets directly from SAS procedures

Creating summary data sets with ODS

Using the DATA step to summarize and report

Writing DATA Step Reports

Producing tabular detail reports with the DATA step and OD

Producing tabular summary reports with the DATA step and ODS

Producing reports with the DATA step for the Listing destination (self-study)