top of page

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

bottom of page