Advanced Reporting Techniques

Duration: 2 days

If you experience any problems with our on-line booking service, you can call us on +44 (0)131 225 6952.

Description

This two day course concentrates on producing reports by using advanced features and techniques of the REPORT, TABULATE, and FORMAT procedures. Learn how to customise SAS output and produce advanced reports using the Output Delivery System (ODS). This course also introduces material on TABLE templates and STYLE templates for reporting purposes. This course contains a self–study section and demonstration programs on DATA step programming, which illustrates the difference between 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.

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.

Prerequisite Skills

Before attending this course, you should have completed the Creating Detail and Summary Reports course or have equivalent knowledge and experience with PROC REPORT, PROC TABULATE, and DATA step report programming. You should be able to:

• use and understand the syntax of PROC REPORT, PROC TABULATE, and PROC FORMAT
• use the DATA step to create detail reports and to summarize data and create summary reports using FILE and PUT statements
• use and understand basic ODS syntax for routing output to the HTML, PDF, and RTF destinations
• use and understand basic ODS and DATA step syntax for creating reports using FILE PRINT ODS and PUT _ODS_ statements
• create output data sets using ODS SELECT and ODS OUTPUT

SAS^® System Modules used

This course covers Version 9 of Base SAS^®.

Course Topics

The REPORT Procedure

• Review REPORT procedure syntax for detail and summary reporting
• Customize 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

The TABULATE Procedure

• 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
• Control the row structure within a table
• Create pages with PROC TABULATE
• Control the treatment of missing values and missing CLASS values
• Specify form characters for drawing the table in LISTING output
• Customize TABULATE procedure output with STYLE= statement level options
• Perform traffic lighting in TABULATE procedure output with user-defined formats

The Output Delivery System

• 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)

Reserve your place on this Newtyne SAS Training Course