SAS(R) Report Writing 1: Essentials

Course Details
Code: RP1
Tuition (USD): $1,950.00 • Classroom (3 days)
$1,950.00 • Virtual (3 days)
Course Details
GSA (USD): $1,768.26 • Classroom (3 days)
$1,768.26 • Virtual (3 days)

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 self-study e-learning includes:

  • Annotatable course notes in PDF format.
  • Virtual Lab time to practice

Skills Gained

  • 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 Can Benefit

  • 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

Prerequisites

  • Before attending this course, you should have completed the SAS(R) Programming I: Essentials course or have equivalent programming experience.

Course Details

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