Fundamental Report Writing with SAS

​

Audience

This course is appropriate for SAS programmers who wish to create summary tables and data listings with SAS and learn through structured, example led training.

​

Prerequisites

Attendees of this course should be familiar with the concepts of using procedures in Base SAS.  Ideally attendees will be trained to the SAS Fundamentals level at least.

​

Topics

​

Introduction to Report Writing

• Proc Report versus Proc Tabulate versus the Data Step

• What is the Output Delivery System?

• Best Practices for Report Presentation

• Getting Started with Proc REPORT

• Getting Started with Proc TABULATE

• Getting Started with ODS

• Workshop Session

​

Further Proc Report

• Controlling Classification Levels

• Working with Analysis Variables

• Breaking Reports on Groupings

• Working with Across Variables

• Using Compute Blocks

• Workshop Session

​

Raw Data Listings with Proc Report

• Procedure Syntax, Options and Statistics

• Creating a Basic Listing

• Ordering Data

• Controlling the Appearance of Columns

• Creating Labels for Groups of Columns

• Workshop Session

​

Further Proc Tabulate

• The Consequences of Missing Values

• Working with Page Dimensions

• Calculating Percentages

• Workshop Session

​

Creating Summary Tables with Proc Tabulate

• Procedure Syntax, Options and Statistics

• Creating Basic Summary Tables

• Using the All keyword

• Adding Statistics to Summary Tables

• Formatting Results

• Workshop Session

​

Further Output Delivery System

• Working with Further ODS Statements

• Multi-page and 3D Reports

• Creating Multiple Output Files

• Basic Style Control with Proc REPORT

• Basic Style Control with Proc TABULATE

• Traffic Lighting Techniques

​

Using the Output Delivery System

• ODS Syntax

• Creating Output for Internet Browsers

• Creating Output for Microsoft Excel

• Creating Output for Microsoft Word

• Creating Output for Portable Document Format Files

• Changing the Appearance of Output

• Workshop Session