This course teaches you how to create detail and summary tabular reports using Base SAS procedures. You also learn how to enhance your reports using the Output Delivery System (ODS).

The self-study version of this course contains structured course notes that provide a detailed overview and exercises that help you develop essential skills. There is also a Virtual Lab that enables you to practice what you learn in the course.

The e-learning includes the following:

• digital course notes for self-study
• Virtual Lab: 30 hours of hands-on software practice

This course can help prepare you for the following certification exam(s): SAS Certified Clinical Trials Programmer Using SAS 9.

Learn how to

• Enhance PROC PRINT detail tabular reports.
• Create PROC TABULATE summary tabular reports.
• Create PROC REPORT detail and summary tabular reports.
• Send report output to third-party and SAS ODS destinations.
• Enhance reports using ODS options and statements.

Who should attend

SAS programmers, data managers, report writers, and analysts who want to generate reports using Base SAS procedures and who are familiar with basic SAS procedure syntax and logic

Formats available	Standard Duration
Classroom:	3.0 days
Live Web Classroom:	6 half-day session(s)	System Requirements
e-Learning:	21 hours/180 day license	System Requirements

Before attending this course, you should have completed the SAS® Programming 1: Essentials course or have equivalent programming experience.

This course addresses Base SAS software.

This course is appropriate for students who are using SAS 9 software.

Introduction to Reporting and ODS

• Course logistics.
• Introduction to reporting.
• Introduction to ODS.
• ODS with the SAS interfaces.
• Creating reports with the PRINT procedure.

Getting Started with the TABULATE Procedure

• Introduction to the TABULATE procedure.
• Creating the structure of the table.
• Adding overall summarizations.
• Adding additional statistics.

Doing More with the TABULATE Procedure

• Enhancing with labels and formats.
• Enhancing with options.
• Adding trafficlighting.
• Adding additional style attributes.

Getting Started with the REPORT Procedure

• Introduction to the REPORT procedure.
• Creating a detail report.
• Creating a summary report with the GROUP usage.
• Creating a summary report with the ACROSS usage.
• Computing an additional column.

Doing More with the REPORT Procedure

• Adding summary lines.
• Customizing break lines.
• Adding trafficlighting and style attributes.
• Using the CALL DEFINE statement.

Using ODS Destinations

• Introduction to ODS destinations.
• PRINTER and RTF destinations.
• CSV and HTML destinations.
• Excel and other destinations.
• SAS destinations.

Doing More with ODS

• Using ODS options and statements.
• Using ODSESCAPECHAR.
• Controlling bookmarks and the table of contents.
• Using ODS layout.

Introduction to SG Procedures

• Introduction to ODS Graphics.
• Using the SG procedures.

Learning More