O'Reilly logo

PROC REPORT by Example by Lisa Fine

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required