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