PROC REPORT by Example

Chapter 2: Formatting Highly Detailed Reports

Introduction

Example: Format National Sales Report

Goals for Formatting the National Sales Report

Key Steps

Source Data

ODS Style Template Used

Programs Used

PROC TEMPLATE Program to Create New Style Template

The “Before Formatting” Program (Program 2.1)

Implementation

Transforming Figure 2.1 Into Figure 2.2

Displaying Region as a Line Above Each Report Page

Overview of Region Display

Code to Make the Region Display in Figure 2.3

Displaying Store and Branch Column Data in Bold Blue Font

Code for Store and Branch Display

How to Insert Arrows for Quick Reference to Sales Increases/Decreases

Overview on Arrow Insertion

Code for Arrow Insertion

How to Add Spanning Headers, Bottom Cell Borders, and Underlines ...