Advanced Reporting Techniques

Duration: 2.0 days CEUs: 1.2
(This course is not currently scheduled.)

This course concentrates on producing reports by using advanced features and techniques of the REPORT, TABULATE, and FORMAT procedures. You also learn how to customize SAS output and produce advanced reports using the Output Delivery System (ODS).

Learn how to

create and enhance advanced detail and cross tabular reports using the REPORT procedure
create and enhance advanced tabular reports using the TABULATE procedure
create and deploy styles and templates that determine the overall appearance of reports
use the DATA step to create custom reports.

Who should attend

SAS programmers, report writers, and business analysts who are already familiar with basic report writing techniques

Expand/Collapse All Expand All Collapse All Print version

Prerequisites

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 PROC FORMAT. You should be able to

use and understand the syntax of PROC REPORT, PROC TABULATE, and PROC FORMAT
use and understand DATA step logic, such as IF statements, assignment statements, and SUM statements
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.

Course Contents

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)

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

Software

This course addresses Base SAS.

Course Materials

Students receive a hardcopy of the course notes and, in some courses, can choose to take home a copy of the course data.

Share Your Thoughts

Are there additional topics you'd like for this course to address? Would you like for this course to be offered at another training facility? Let us know by adding to our Interest List.

Available for on-site training or can be scheduled at any SAS training facility

This page was created using SAS software.

Learning Center

Stay in Touch

Not sure what course to take?

Submit Your Course Requests

On-site Pricing