Book description
PROC REPORT by Example: Techniques for Building Professional Reports Using SAS provides real-world examples using PROC REPORT to create a wide variety of professional reports. Written from the point of view of the programmer who produces the reports, this book explains and illustrates creative techniques used to achieve the desired results.
Each chapter focuses on a different concrete example, shows an image of the final report, and then takes you through the process of creating that report. You will be able to break each report down to find out how it was produced, including any data manipulation you have to do.
The book clarifies solutions to common, everyday programming challenges and typical daily tasks that programmers encounter. For example:
obtaining desired report formats using style templates supplied by SAS and PROC TEMPLATE, PROC REPORT STYLE options, and COMPUTE block features
employing different usage options (DISPLAY, ORDER, GROUP, ANALYSIS, COMPUTED) to create a variety of detail and summary reports
using BREAK statements and COMPUTE blocks to summarize and report key findings
producing reports in various Output Delivery System (ODS) destinations including RTF, PDF, XML, TAGSETS.RTF
embedding images in a report and combining graphical and tabular data with SAS 9.2 and beyond
Applicable to SAS users from all disciplines, the real-life scenarios will help elevate your reporting skills learned from other books to the next level.
With PROC REPORT by Example: Techniques for Building Professional Reports Using SAS, what seemed complex will become a matter of practice.
This book is part of the SAS Press program.
Table of contents
- About This Book
- Acknowledgements
-
Chapter 1: Creating Complementary Reports
- Introduction
- Example: Department Store Summary and Detail Reports
- Goals for Creating Complementary Reports
- Source Data
- ODS Style Template Used
- Programs Used
- Implementation
- Writing the Detail Report Program
- Detail Report: Titles, Footnotes, and ODS RTF Preparation
- Producing the Report with PROC REPORT
- Writing the Summary Report Program
- Producing the Report with PROC REPORT
- Chapter 1 Summary
-
Chapter 2: Formatting Highly Detailed Reports
- Introduction
- Example: Format National Sales Report
- Goals for Formatting the National Sales Report
- 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
- Displaying Store and Branch Column Data in Bold Blue Font
- How to Insert Arrows for Quick Reference to Sales Increases/Decreases
- How to Add Spanning Headers, Bottom Cell Borders, and Underlines
- Adding Blank Columns to Make the Report More Legible
- Style: Add a Blank Line After Each Summary 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
- Source Data
- ODS Style Template Used
- Programs Used
- Implementation
- Obtain Population Counts for Column Headers and Denominators
- Categorical Variables: Obtain Counts and Percentages
- Continuous Variables: Descriptive Data
- Create Final Table: Combine TABULATE and MEANS Results
- Produce the Report via PROC REPORT
- 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
- Source Data
- ODS Style Template Used
- Programs Used
- Implementation
- ORDER by and Print Subject ID on Every Row with Greying Font
- Identify 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
- Source Data
- ODS Style Template Used
- Programs Used
- Implementation
- Create Formats and Informats
- Obtain Counts and Percentages
- Producing the Workbook With PROC REPORT and ODS Tagset
- Producing the Specific Worksheets
- 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
- Source Data
- ODS Style Template Used
- Programs Used
- Implementation: Creating the ODS Style Template
- Obtain Calendar Grid and Merge With Sales
- Produce 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
- Example 1: Obtain Images as Column of Data
- Example 2: Repeated Images Above and Below Table
- Example 3: Display Images as Column Headers
- Example 4: Display Image in Page Title
- Example 5: Display 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
- Source Data
- ODS Style Template Used
- Programs Used
- Implementation
- Create a Summary Data Set using PROC REPORT
- Obtain 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
- Using PROC SGPLOT to Create a Horizontal Bar Chart
- 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
- References
- DATA SETS
- Index
Product information
- Title: PROC REPORT by Example
- Author(s):
- Release date: December 2013
- Publisher(s): SAS Institute
- ISBN: 9781612909134
You might also like
book
What's New in SAS 9.4
Gives you a quick, convenient overview of new functionality, enhanced features, and new products that you …
book
Carpenter's Complete Guide to the SAS REPORT Procedure
Art Carpenter demystifies the powerful REPORT procedure and shows you how to incorporate this highly flexible …
book
PROC DOCUMENT by Example Using SAS
PROC DOCUMENT by Example Using SAS demonstrates the practical uses of the DOCUMENT procedure, a part …
book
PROC TABULATE by Example, Second Edition
An abundance of real-world examples highlights Lauren Haworth Lake’s and Julie McKnight's PROC TABULATE by Example, …