Advanced Reporting Techniques

Role

SAS Programmer

Duration

2 days

Description

This course concentrates on producing reports with the REPORT, TABULATE, and FORMAT procedures, customising SAS output and enhancing reports with ODS. This course also introduces material on TABLE and STYLE templates. The course contains programs on DATA step programming, which illustrates writing a DATA step program to produce LISTING output, versus writing a DATA step program to produce ODS output for HTML, RTF, or PDF destinations.

Prerequisites

Before attending this course, you should: Complete the Creating Detail and Summary Reports course or have equivalent knowledge and experience with PROC REPORT, PROC TABULATE, and PROC FORMAT. Understand the syntax of PROC REPORT, PROC TABULATE, PROC FORMAT and DATA step logic. Use the DATA step to create detail and summary reports using FILE and PUT statements. Use and understand basic ODS syntax.

SAS Modules Used

Base SAS

Course Topics

Review REPORT procedure syntax for detail and summary reporting

• customise BREAK text
• use a COMPUTE block
• create a cross-tabular report with ACROSS variables
• reference a PROC REPORT column by column number
• use the LINE statement
• use the _BREAK_ automatic report variable
• calculate row percentages and cumulative percentages within COMPUTE blocks
• use the CALL DEFINE statement
• customize REPORT procedure output with STYLE= statement level options
• perform traffic lighting in REPORT procedure output with CALL DEFINE statements

Review TABULATE procedure syntax for summary reporting

• calculate percentages using default statistic names
• calculate percentages using denominator specifications and angle bracket operators
• use PICTURE formats
• use multilabel formats
• controlling the row structure within a table
• creating pages with PROC TABULATE
• controlling the treatment of missing values and missing CLASS values
• specifying form characters for drawing the table in LISTING output
• customising TABULATE procedure output with STYLE= statement level options
• performing traffic lighting in TABULATE
• procedure output with user-defined formats

Modifying TABLE templates

• investigate the basic syntax for TABLE templates
• use a modified TABLE template
• trace output object creation with ODS TRACE statement
• select output objects for report creation
• creating and using STYLE templates
• investigate the basic syntax for STYLE templates
• use a modified STYLE template
• control template retrieval and storage with ODS PATH statement

The DATA _NULL_ Step (Self -Study)

• using DATA step syntax to write reports for LISTING output
• creating multiline reports for LISTING output
• using the LINK statement and the LINESLEFT option for LISTING output
• creating multiple reports or multiple files with one DATA step program
• creating a multipanel report for LISTING output
• creating a demographic report for LISTING output
• investigating using ODS and DATA step for HTML, RTF and PDF output
• using a custom TABLE template with a DATA step program
• using a custom STYLE template with a DATA step program
• creating a demographic report for ODS destination output (RTF)

Objectives

After attending this course you will be able to: Produce reports using advanced features and techniques of the REPORT, TABULATE, and FORMAT procedures; customise SAS output and produce advanced reports using the Output Delivery System (ODS). During this course you will also be introduced to material on TABLE templates and STYLE templates for reporting purposes.