SAS Report Writing 1: Using Procedures and ODS

Duration: 3.0 days
Course fee: $1,980
EPTO units: 3
CEUs: 1.8

This course teaches you how to create detailed tabular, summary, and listing reports. You also learn how to send report output to the major Output Delivery System (ODS) destinations.

Learn how to

use PROC REPORT to generate tabular detail reports, detail reports with subtotals and grand totals, and detail reports with computed columns
generate summary reports based on GROUP, ACROSS, or CLASS variables using PROC REPORT and PROC TABULATE
insert appropriate summary lines into reports
send report output to the RTF, PDF, and HTML destinations
change reports using ODS options and style overrides.

Who should attend

SAS programmers, data managers, report writers, and analysts who must generate reports with the REPORT procedure and the TABULATE procedure and who are familiar with basic SAS procedure syntax and logic

Expand/Collapse All Expand All Collapse All Print version

Prerequisites

Before attending this course, you should have completed the SAS Programming 1: Essentials course or have equivalent programming experience.

Course Contents

Introduction to the Output Delivery System

sending a report to an ODS destination

Creating Summary Reports with the TABULATE Procedure

using basic PROC TABULATE statements
enhancing a table
adding percentages

Advanced TABULATE Procedure Topics

handling missing values with PROC TABULATE
using ODS STYLE= options with PROC TABULATE
working with pages and BY groups
controlling row structure and data subsets
using multilabel formats with PROC TABULATE
working with PROC TABULATE and the listing destination

Creating Detail Reports with the REPORT Procedure

using basic REPORT procedure statements
adding summary lines
computing an additional column
working with PROC REPORT in the listing destination

Creating Summary Reports with the REPORT Procedure

defining and using GROUP variables
customizng break lines
defining and using ACROSS variables

Advanced PROC REPORT Topics

using absolute column names with ACROSS usage
working with missing values and PROC REPORT
working with STYLE= overrides with PROC REPORT
using the CALL DEFINE statement

Enhancing Reports with ODS

adding options to ODS destination statements
using additional ODS features
using cascading style sheets with ODS

Software

This course addresses Base SAS.

Course Materials

Students receive a hardcopy of the course notes and, in some courses, can choose to take home a copy of the course data.

Share Your Thoughts

Are there additional topics you'd like for this course to address? Would you like for this course to be offered at another training facility? Let us know by adding to our Interest List.

Course fee and EPTO units will differ for on-site training.

This page was created using SAS software.

-	Public
-	On-site training
-	One-to-one Mentoring
-	Courses by Industry Experts
-	Targeted Learning
-	ABM Training
-	TPS Service
-	Find a Course
-	Register now
-	Course list
-	Curriculum paths
-	Locations
-	Special Offers