Producing Advanced Reports Using Proc REPORT

Role

Report Writer and Business Analyst

Duration

3 hours

Description

The REPORT procedure combines features of the PRINT, MEANS, and TABULATE procedures with features of the DATA step in a single report-writing tool that can produce a variety of reports. During this Live Web class you will create a variety of reports ranging from simple to highly customised.

To ensure the effectiveness of the training you will be invited to join a dedicated group on SAS Professionals where you can provide details of the reports you want to produce. These examples and any queries can then be discussed during the class.

Prerequisites

Before attending this course, you should have attended the SAS Programming 1: Essentials course or have the equivalent knowledge and experience. Some knowledge and experience of Proc REPORT is advantageous.

SAS Modules Used

Course Topics

Introduction

• Introduction to course topics and concepts

Creating Detail Reports

• Using Basic REPORT Procedure Statements
• Adding Summary Lines
• Computing an Additional Column
• Working with the Listing Destination

Creating Summary Reports

• Defining and Using GROUP Variables
• Customising Break Lines
• Defining and Using ACROSS Variables

Advanced REPORT Procedure Topics

• Using Absolute Column Names with ACROSS Usage
• Working with Missing Values
• Working with STYLE= Overrides
• Using the CALL DEFINE Statement
• Advanced Compute Block Examples

Objectives

After attending this live web session you will be able to:

• State the statements and options that will enable you to customize Proc REPORT output
• Produce detail and summary reports according to your design specifications using Proc REPORT

This outline is provisional and subject to change.