Producing Advanced Reports Using Proc TABULATE

Role

Report Writer and Business Analyst

Duration

3 hours

Description

The TABULATE procedure displays descriptive statistics in tabular format, using some or all of the variables in a data set. During this Live Web class you will create a variety of tables 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 TABULATE is advantageous.

SAS Modules Used

This course addresses Base SAS.

Course Topics

Introduction

• Introduction to course topics and concepts

Creating Proc TABULATE Output

• Using Table Operators to Control Table Layout
• Specifying Statistics
• Applying Formats to Data Values and Labels to Column Headings

Advanced TABULATE Procedure Topics

• Handling Missing Values
• Working with Pages and By Groups
• Controlling Row Structure and Data Subsets
• Using Multilabel Formats
• Working with the Listing Destination (self-study)

Objectives

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

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

This outline is provisional and subject to change.