Amadeus cookies policy - you'll see this message only once.

Amadeus use cookies on this website. They help us to know a little bit about you and how you use our website, which improves the browsing experience and marketing - both for you and for others. They are stored locally on your computer or mobile device. To accept cookies, continue browsing as normal. Or, go to the privacy policy for more information.

Fundamental Report Writing with SAS

After this two day course attendees will be able to use Proc REPORT, Proc TABULATE and the Output Delivery System to create professionally presented reports. Delegates will understand how to create reports for Internet Browsers, Microsoft Excel, Microsoft Word and Portable Document Format files in addition to the traditional SAS listing files.

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

FRW1 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

FRW2 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

FRW3 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

FRW4 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

FRW5 Further Proc REPORT

  • How Proc REPORT Works
  • Controlling Classification Levels
  • Working with Analysis Variables
  • Breaking Reports on Groupings
  • Working with ACROSS Variables
  • Using Compute Blocks
  • Workshop Session

FRW6 Further Proc TABULATE

  • The Consequences of Missing Values
  • Working with Page Dimensions
  • Calculating Percentages
  • Workshop Session

FRW7 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
  • Workshop Session