PROC REPORT by Example: Techniques for Building Professional Reports Using SAS

Additional Resources
Contents
About This Book
	Purpose
	Is This Book for You?
	Prerequisites
	About the Examples
		Software Used to Develop the Book\'s Content
		Example Code and Data
		For SAS 9.1.3 Users
		Output and Graphics
	Additional Resources
	Keep in Touch
		To Contact the Author Through SAS Press
		SAS Books
		SAS Book Report
Acknowledgements
Chapter 1: Creating Complementary Reports
	Introduction
	Example: Department Store Summary and Detail Reports
	Goals for Creating Complementary Reports
		Key Steps
	Source Data
	ODS Style Template Used
	Programs Used
	Implementation
		Create a Setup Program that Contains Common SAS Code
		Ch1Setup.SAS
	Writing the Detail Report Program
		Detail Report Pre-Processing Code
	Detail Report: Titles, Footnotes, and ODS RTF Preparation
		Code for Titles, Footnotes, and ODS RTF Preparation
	Producing the Report with PROC REPORT
		Detail Report - PROC REPORT Code
	Writing the Summary Report Program
		Map Separate Variables/Values to One Column for PROC REPORT
		Summary Report - Pre-Processing Code
		Assign Report Order to Variables
		Code for Creating Ordered Variables
		Summary Report: Titles, Footnotes, and ODS RTF Preparation
		Code for Titles, Footnotes, and ODS RTF Preparation
	Producing the Report with PROC REPORT
		Summary Report - PROC REPORT Code
	Chapter 1 Summary
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
		Highlights on Adding Spanning Headers, Borders, and Underlines
		Code for Adding Spanning Headers, Borders, and Underlines
	Adding Blank Columns to Make the Report More Legible
		Overview of Adding Blank Columns
		Code for Adding Blank Columns
	Style: Add a Blank Line After Each Summary Line
		Highlights on Styling Summary Line and Adding a Blank Line
		Code for Styling Summary Line and Adding a Blank Line
	Chapter 2 Summary
Chapter 3: Reporting Different Metrics Within a Column
	Introduction
	Example: Demographic and Baseline Characteristics Report
	Goals for the Demographics and Baseline Characteristics Report
		Key Steps
	Source Data
	ODS Style Template Used
	Programs Used
	Implementation
	Obtain Population Counts for Column Headers and Denominators
		Code for Obtaining Population Counts
	Categorical Variables: Obtain Counts and Percentages
		Code for Obtaining Categorical Counts and Percentages
	Continuous Variables: Descriptive Data
		Macro Code for Obtaining Descriptive Statistics
	Create Final Table: Combine TABULATE and MEANS Results
		Code for Combing the Results
	Produce the Report via PROC REPORT
		PROC REPORT Code
	Chapter 3 Summary
Chapter 4: Lesion Data Quality Report - COMPUTE Blocks
	Introduction
	Example: Lesion Data Quality Report
	Goals for Creating the Lesion Data Quality Report
		Key Steps
	Source Data
	ODS Style Template Used
	Programs Used
	Implementation
		COMPUTE Block Variables: DATA Step (Temporary) Versus REPORT (COLUMN Statement) Variables
	ORDER by and Print Subject ID on Every Row with Greying Font
		Program for Subject ID Display
	Identify Potential Data Issues
		Code for Displaying Potential Data Issues
	Final Formatting: Create Spanning Headers
	Chapter 4 Summary
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
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
Chapter 7: Embedding Images in a Report
	Introduction
	Example: Tables Displaying Iris Flower Measurements
	Goals for Embedding Images in Reports
	Source Data
	ODS Style Templates Used
	Programs Used
	Implementation
		Setup Options, File Paths, and Image File Names
		Program Setup Code
	Example 1: Obtain Images as Column of Data
		Code for Obtaining Images as Column of Data
	Example 2: Repeated Images Above and Below Table
		Code for Repeating Images Above and Below Table
		Produce the Report
	Example 3: Display Images as Column Headers
		Code for Displaying Images as Column Headers
	Example 4: Display Image in Page Title
		Code for Displaying Images in Page Titles
	Example 5: Display Image Above Body of Table
		Code for Displaying Image Above Body of Table
	Example 6: Display Watermark on Report
	Chapter 7 Summary
Chapter 8: Combining Graphs and Tabular Data
	Introduction
	Example: Dashboard Report of Shoe Sales
	Goals for Creating the Shoe Sales Dashboard
		Key Steps
	Source Data
	ODS Style Template Used
	Programs Used
	Implementation
	Create a Summary Data Set using PROC REPORT
		Code for Creating a Summary Data Set
	Obtain Regional Ranking Information
		Code for Obtaining Regional Ranking Information
	Create a New ODS Style Template
	Create the ODS LAYOUT for the Report
	Create Formats Needed for Outputs
	Use PROC SGPLOT to Create Vertical Bar Charts
		Code for SGPLOT Vertical Bar Charts
	Using PROC SGPLOT to Create a Horizontal Bar Chart
		Horizontal Bar Chart Code
	Using PROC REPORT to Obtain Tabular Output
	Using PROC SGPANEL to Create Bar Charts for the Top 3 Regions
	Chapter 8 Summary
Chapter 9: Using PROC REPORT to Obtain Summary Statistics for Comparison
	Introduction
	Example: Vehicle MSRP Comparison Report
	Goals for MSRP Comparison Report
		Key Steps
	Source Data
	ODS Style Template Used
	Programs Used
	Implementation
	Initial PROC REPORT for Obtaining Statistics
		Code for Obtaining Statistics
	Produce the Report
		Code for Print Report
	Chapter 9 Summary
References
	DATA SETS
Index