PROC REPORT by Example

Chapter 6: Using the ACROSS Option to Create a Weekly Sales Report

Introduction

Example: Weekly Sales Report

Goals for Creating a Weekly Sales Report

Key Steps

Source Data

ODS Style Template Used

Programs Used

Implementation: Creating the ODS Style Template

Proc Template Code

Obtain Calendar Grid and Merge With Sales

Produce the Report

Code for Producing the Report

Place Holders for Data Not Yet Available

Chapter 6 Summary

 

Introduction

Some reports are better displayed once the data is transposed. While we could use PROC TRANSPOSE, PROC REPORT provides the advantage of allowing us to simultaneously transpose the data and summarize rows. This ability is provided with PROC REPORT’s ACROSS and GROUP usage options. The variable we want transposed ...