SAS Report Writing 1: Using Procedures and ODS
Classroom duration: 3.0 days Live Web duration: 6 half-day sessions CEU: 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 logicPrerequisites
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
- using basic PROC TABULATE statements
- enhancing a table
- adding percentages
- 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
- using basic REPORT procedure statements
- adding summary lines
- computing an additional column
- working with PROC REPORT in the listing destination
- defining and using GROUP variables
- customizng break lines
- defining and using ACROSS variables
- 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
- adding options to ODS destination statements
- using additional ODS features
- using cascading style sheets with ODS
Software Addressed
This course addresses the following software product(s): Base SAS.Classroom 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.Live Web Course Materials
Students attend Live Web classes using a Web browser and a telephone and interact with their instructor and fellow classmates in real time. Each student receives an e-mail with instructions on how to join the class three business days before the class begins. The instructions e-mail includes a link to download the course materials, including the exercise files. Students need to download and print the course materials prior to class.System Requirements
For Live Web, you must- review and follow the general system requirements.
- complete the course exercises through our virtual lab. The virtual lab allows you to access the software used in class over the Internet, so that you do not need this software on your local machine.
- run this test to connect to a virtual lab session. If
firewall problems prevent you from connecting to the virtual lab, then you will need the following software installed and
configured in your environment to participate in the course exercises:
- Base SAS 9.2 or 9.1.3 on a Windows operating system or
SAS Learning Edition.
Important: Students using SAS Learning Edition will need to create a shortcut to the SAS windowing environment (SAS Explorer, Enhanced Editor, Log, and Output windows) for use during the class. Follow these instructions for creating a shortcut to SAS prior to class.
- Base SAS 9.2 or 9.1.3 on a Windows operating system or
SAS Learning Edition.
U.S. Schedule
| 15OCT2008 Minneapolis, MN 28OCT2008 Sacramento, CA 12NOV2008 Orlando, FL 18NOV2008 Denver, CO 16DEC2008 Irvine, CA 21JAN2009 Charlotte, NC 23FEB2009 Rockville, MD 18MAR2009 Overland Park, KS 31MAR2009 Hartford, CT 22APR2009 Philadelphia, PA 13MAY2009 Dallas, TX 02JUN2009 Detroit, MI 29JUN2009 Rockville, MD | 22OCT2008 Philadelphia, PA 29OCT2008 Chicago, IL 14NOV2008 Live Web, 03DEC2008 New York, NY 13JAN2009 San Francisco, CA 26JAN2009 Cary, NC 04MAR2009 Atlanta, GA 18MAR2009 Seattle, WA 15APR2009 Minneapolis, MN 29APR2009 Chicago, IL 13MAY2009 Orlando, FL 15JUN2009 New York, NY | 22OCT2008 Seattle, WA 04NOV2008 Richmond, VA 17NOV2008 Dallas, TX 10DEC2008 Rockville, MD 14JAN2009 Bedminster, NJ 02FEB2009 Boston, MA 11MAR2009 Washington, DC 25MAR2009 New York, NY 15APR2009 Phoenix, AZ 05MAY2009 Sacramento, CA 27MAY2009 Denver, CO 23JUN2009 Irvine, CA |
Check for additional and updated schedule information online at support.sas.com/courses/rpt1.html.