About this course

Course code TPRP1
Duration 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).

Prerequisites

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.

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

Delegates will 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.

Outline

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 ODS ESCAPECHAR
  • controlling bookmarks and the table of contents
  • using ODS layout

Introduction to SG Procedures

  • introduction to ODS graphics
  • using the SG procedures

Learning More

  • introduction

3 Days

Duration

This is a QA approved partner course

Delivery Method

Delivery method

Classroom

Face-to-face learning in the comfort of our quality nationwide centres, with free refreshments and Wi-Fi.

Trusted, awarded and accredited

Fully accredited to ensure we provide the highest possible standards in learning

All third party trademark rights acknowledged.