PROC REPORT by Example

Chapter 5: Multi-Sheet Workbook With Histograms–ExcelXP Tagsets Report

Introduction

Example: Multi-Sheet Workbook Containing Heart Study Results

Goals for Creating the Multi-Sheet Workbook

Key Steps

Source Data

ODS Style Template Used

Programs Used

Implementation

Create Formats and Informats

Code for Creating Formats and Informats

Obtain Counts and Percentages

Code for Obtaining Counts and Percentages

Producing the Workbook With PROC REPORT and ODS Tagset

Code for Opening, Closing, and Setting Initial Options for the ExcelXP Workbook

Producing the Specific Worksheets

Code for Producing ByStatusCOL and ByStatusROW Worksheets

Code for Producing ByStatusALL Worksheet

Chapter 5 Summary

Introduction

The SAS ExcelXP tagset, available with SAS 9.1 and ...