SAS Training 800-333-7660 support.sas.com/training

SAS Report Writing 1: Using Procedures and ODS

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

Prerequisites

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

Software Addressed

This course addresses the following software product(s): Base SAS.

Formats available	Duration
Classroom:	3.0 days
Live Web Classroom:	6 half-day sessions

Course Contents

Introduction to the Output Delivery System

• course logistics
• sending a report to an ODS destination

Creating Summary Reports with the TABULATE Procedure

• using basic TABULATE procedure statements
• enhancing the table
• adding percentages
• more about picture formats (self-study)

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 (self-study)

Creating Summary Reports with the REPORT Procedure

• defining and using group variables
• customizng break lines
• defining and using across variables

Advanced REPORT Procedure Topics

• using absolute column names with ACROSS usage
• working with missing values and PROC REPORT
• working with STYLE= overrides with PROC REPORT
• enhancements using the CALL DEFINE statement (self-study)
• advanced compute block examples (self-study)

Enhancing Reports with ODS

• adding options to ODS destination statements
• using additional ODS features (self-study)
• using cascading style sheets with ODS (self-study)

Style Attributes and their Values

• attributes for use with the STYLE= options in PROC REPORT and PROC TABULATE

ODS and SAS Enterprise Guide

Classroom Schedule

12SEP2011 Washington, DC 02NOV2011 Minneapolis, MN 25JAN2012 Charlotte, NC 29FEB2012 Hartford, CT 24APR2012 Chicago, IL

19SEP2011 New York, NY 07NOV2011 Dallas, TX 30JAN2012 Cary, NC 07MAR2012 Atlanta, GA 25APR2012 Philadelphia, PA

19OCT2011 Philadelphia, PA 28NOV2011 Rockville, MD 07FEB2012 Boston, MA 12MAR2012 Washington, DC 07MAY2012 Dallas, TX

25OCT2011 Chicago, IL 18JAN2012 San Francisco, CA 22FEB2012 Rockville, MD 19MAR2012 New York, NY 30MAY2012 Rockville, MD

Live Web Schedule

10NOV2011 Live Web

23FEB2012 Live Web

07JUN2012 Live Web

Check for additional and updated schedule information online at support.sas.com/crs/284.

Registration

To register for this course in the US, call 800-333-7660 or visit support.sas.com/training.

This course is also available for on-site training, or you can create a custom course by combining material from several courses. For more details, contact SAS Education in Cary, NC at 919-531-7321 or send e-mail to training@sas.com.

RPT1	04/21/2010