SAS Report Writing 1: Essentials

This course teaches you how to create detail and summary tabular reports using Base SAS procedures. You also learn how to enhance your reports using the Output Delivery System (ODS).

Duration 3 Days
Certificate SAS Global
Language English


Power up your staff’s skills and boost your business

or Call us on +91 79 403 270 00


Course Description

  • enhance PROC PRINT detail tabular reports
  • create PROC TABULATE summary tabular reports
  • create PROC REPORT detail and summary tabular reports
  • send report output to third-party and SAS ODS destinations
  • enhance reports using ODS options and statements.

About Program

Who should attend

SAS programmers, data managers, report writers, and analysts who want to generate reports using Base SAS procedures and who are familiar with basic SAS procedure syntax and logic

Format of Training

Taught by certified instructors at high-tech facilities across the country

  • A SAS expert at your side.
  • Focused learning away from the office
  • Networking opportunities
  • State-of-the-art facilities
  • Electronic course notes downloadable to your device and permission to print
  • Business Knowledge Series: in-depth courses on the latest business topics
  • We offer Connected Classes! Watch for courses in Cary, New York, Arlington, Dallas and San Francisco that connect remote students via our Live Web classroom.

Prerequisite

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

This course addresses Base SAS software.

This course is appropriate for students who are using SAS 9 software.

Course Curriculum

Introduction to Reporting and ODS

  • course logistics
  • introduction to reporting
  • introduction to ODS
  • ODS with the SAS interfaces
  • creating reports with the PRINT procedure

Getting Started with the TABULATE Procedure

  • introduction to the TABULATE procedure
  • creating the structure of the table
  • adding overall summarizations
  • adding additional statistics

Doing More with the TABULATE Procedure

  • enhancing with labels and formats
  • enhancing with options
  • adding trafficlighting
  • adding additional style attributes

Getting Started with the REPORT Procedure

  • introduction to the REPORT procedure
  • creating a detail report
  • creating a summary report with the GROUP usage
  • creating a summary report with the ACROSS usage
  • computing an additional column

Doing More with the REPORT Procedure

  • adding summary lines
  • customizing break lines
  • adding trafficlighting and style attributes
  • using the CALL DEFINE statement

Using ODS Destinations

  • introduction to ODS destinations
  • PRINTER and RTF destinations
  • CSV and HTML destinations
  • Excel and other destinations
  • SAS destinations

Doing More with ODS

  • using ODS options and statements
  • using ODS ESCAPECHAR
  • controlling bookmarks and the table of contents
  • using ODS layout

Introduction to SG Procedures

  • introduction to ODS graphics
  • using the SG procedures

Learning More

  • introduction

Project

  • introduction to the REPORT procedure
  • creating a detail report
  • creating a summary report with the GROUP usage
  • creating a summary report with the ACROSS usage
  • computing an additional column