book

The SAS Programmer's PROC REPORT Handbook: Basic to Advanced Reporting Techniques

Name: The SAS Programmer's PROC REPORT Handbook: Basic to Advanced Reporting Techniques
Author: Jane Eslinger
ISBN: 9781629602103

by Jane Eslinger

March 2016

Intermediate to advanced

314 pages

7h 38m

English

SAS Institute

Read now

Unlock full access

About this Book
About the Author
Acknowledgments
Preface
Chapter 1: Syntax – How to Use Statements and Their Options
1.1 Introduction1.2 PROC REPORT Statement1.2.1 General Options1.2.2 Report Contents Options1.2.3 Report Appearance Options1.3 COLUMN Statement1.4 DEFINE Statement1.4.1 Usage Options1.4.2 Interaction Options1.4.3 Appearance Options1.4.4 Utility Options1.5 BREAK Statement1.6 RBREAK Statement1.7 COMPUTE Statement1.8 ENDCOMP Statement1.9 CALL DEFINE Statement1.9.1 Argument 1: Column-ID1.9.2 Argument 2: Attribute Name1.9.3 Argument 3: Attribute Value1.10 LINE Statement1.11 Global Statements
Chapter 2: Concepts – How PROC REPORT Works Behind the Scenes
2.1 Introduction2.2 General Execution2.3 Compute Blocks2.3.1 COMPUTE Statement2.3.2 Execution of Compute Blocks2.4 Referencing Report-items2.5 Left to Right Availability2.6 Repeating GROUP or ORDER Variable Values2.6.1 Character Variables2.6.2 Numeric Variables2.6.3 Undesired Repeating Values2.7 Column Widths2.8 Date Variables2.9 Temporary Variables2.10 Sorting and the ORDER= Option2.11 Paging
Chapter 3: Examples – How to Get the Desired Report
3.1 Introduction3.2 Standard Reports3.2.1 Create a Basic Report3.2.2 Define a Variable as ORDER3.2.3 Define a Variable as GROUP3.2.4 Create a New Report-Item3.2.5 Produce Summary Rows3.3 Nonstandard Reports3.3.1 Calculate Percentages within Groups3.3.2 Customized Sort Order3.3.3 Multiple Summary Rows at One Location3.3.4 Rows Created with a LINE Statement Versus a BREAK Statement3.3.5 Conditionally Display a LINE Statement3.4 Special Data Consideration Reports3.4.1 Wide Tables3.4.2 Using ORDER=DATA3.4.3 Using the COMPLETEROWS Option3.4.4 Output a Table with No Data3.4.5 Dynamically Assign Spanning Header Text
Chapter 4: Examples – How to Use ACROSS Variables
4.1 Introduction4.2 Standard Reports4.2.1 Stack a Statistic4.2.2 Multiple Variables under an ACROSS Variable4.2.3 A DISPLAY Variable under an ACROSS Variable4.2.4 A GROUP Variable under an ACROSS Variable4.2.5 Create New Report-Items4.2.6 Percentages4.3 Header Section Rows4.3.1 Default Header Section Created with ACROSS4.3.2 Place a Spanning Header beside ACROSS Values4.3.3 Place Spanning Headers beside ACROSS Label4.3.4 Place Multiple Spanning Headers beside ACROSS Header Rows4.3.5 Remove ACROSS Label Row4.3.6 Counts As Part of ACROSS Values4.4 Nonstandard Reports4.4.1 Customized Sort Order4.4.2 Creating Subtotal Columns4.4.3 Nesting ACROSS Variables4.4.4 Hide a Column under an ACROSS4.4.5 Vertical Page Breaks4.4.6 Use Macro to Create Column References
Chapter 5: Examples – How to Determine When to Pre-Process the Data
5.1 Introduction5.2 Sort by Statistic5.2.1 Grouped Report, No ACROSS Variable5.2.2 Grouped Reports with an ACROSS Variable5.3 Use COMPLETEROWS with ACROSS5.3.1 COMPLETEROWS and a GROUP Variable under an ACROSS Variable5.3.2 COMPLETEROWS and a DISPLAY Variable under an ACROSS5.4 Use COMPLETEROWS with Multiple GROUP Variables5.5 Use Information from a Variable in Header and Data Sections5.6 Wrap Text at a Specific Place5.7 Incorporate Various Data Pieces into One Report5.7.1 Combine Detail and Summary Information5.7.2 The Importance of ORDER Variables5.8 Create the Look of Merged Cells5.8.1 Merge Vertically5.8.2 Merge Horizontally
Chapter 6: Styles – How to Change a Report’s Appearance
6.1 Introduction6.2 STYLE= Option6.3 Borders6.3.1 FRAME= and RULES= Attributes6.3.2 Column (Data) Borders6.3.3 Header Borders6.4 Trafficlighting6.4.1 Color Based on Cell’s Value6.4.2 Color Based on Another Report-item6.4.3 Color on the Diagonal6.5 Trafficlighting under an ACROSS Variable6.5.1 Color Based on Cell’s Value6.5.2 Color Based on Another Report-item6.5.3 Color on the Diagonal6.6 Color in Headers6.6.1 STYLE(HEADER)= on PROC REPORT Statement6.6.2 STYLE(HEADER)= on DEFINE Statement6.6.3 Spanning Header6.6.4 ACROSS Variable Label and Value Headers6.6.5 ACROSS Value Headers6.6.6 ACROSS Label versus ACROSS Values6.7 LINE Statements6.8 Advanced Color and Border Assignments6.8.1 Apply Multiple Styles on One Cell6.8.2 Color Every Other Row6.8.3 Change Borders in HTML Output6.8.4 Special Instructions for the ODS Destination6.9 Images6.9.1 Place an Image above or below a Report Table6.9.2 Place an Image inside of the Table6.10 URLs6.10.1 Hyperlink to a Static Location6.10.2 Link to Numerous Files

Chapter 7: Table of Contents – How to Manipulate with CONTENTS= and PROC DOCUMENT
7.1 Introduction7.2 Default Nodes7.3 BY-Variable Nodes7.4 DEFINE Statement CONTENTS=7.5 BREAK Statement CONTENTS=7.6 RBREAK Statement CONTENTS=7.7 ODS DOCUMENT and PROC DOCUMENT7.7.1 ODS DOCUMENT Convention7.7.2 PROC DOCUMENT Statements and Options7.7.3 Default Items7.7.4 BY-Variable Item List7.7.5 Parent Node with Multiple Child Nodes7.7.6 Combine Multiple PROC REPORT Steps under One Node
Chapter 8: Debugging Techniques – How to Troubleshoot
8.1 Introduction8.2 Errors, Warnings, and Notes in the Log8.2.1 DEFINE Statement8.2.2 BREAK Statement8.2.3 Compute Block Statements8.3 Temporary Variable Values8.3.1 Output via a LINE Statement8.3.2 Output via a COMPUTED Variable8.4 General Tips
References
BooksConference PapersTechnical PaperSAS DocumentationSAS Notes
Index

Overview

The SAS Programmer's PROC REPORT Handbook: Basic to Advanced Reporting Techniques is intended for programmers of all skill levels. Learn how to link multiple reports, add graphics and logos, and manipulate table of contents values to help refine your programs, macrotize where possible, troubleshoot easily, and get great-looking reports every time. From beginner to advanced, the examples in this book will help you harness all the power and capability of PROC REPORT.

With dozens of useful examples, this book is completely unique in three ways. First, this book describes the default behavior of table of contents nodes and labels, and how to change the nodes inside of PROC REPORT. The chapter also explains how to use PROC DOCUMENT in conjunction with PROC REPORT. Secondly, an entire chapter is dedicated to the troubleshooting of errors, warnings, and notes that are produced by PROC REPORT, including explanations of what generated the log message and how to avoid it. Third, the book explains how to preprocess your data in order to get the best output from PROC REPORT, and it explores reports that require multiple steps to create. Whether you work in banking/finance, pharmaceuticals, the health and life sciences, or government, this handbook is sure to be your new favorite reporting reference.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

The SAS Programmer's PROC REPORT Handbook

Publisher Resources

ISBN: 9781629602103

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills