Proc Report Secreates
PharmaSUG 2012 - Paper TF20-SAS
PROC REPORT Unwrapped: Exploring the Secrets behind One of the Most
Popular Procedures in Base SAS® Software
Allison McMahill Booth, SAS Institute Inc., Cary, NC, USA
ABSTRACT
Have you ever wondered why a numeric variable is referenced in different forms within a COMPUTE block? Do you know the difference between a DATA step variable and a variable that is listed in the COLUMN statement? Then, this paper is for you! Welcome to PROC REPORT Unwrapped. We are looking at PROC REPORT and uncovering some of the behind-the-scenes details about this classic procedure. We will explore the components associated with
PROC REPORT and discover ways to move column headings and change default attributes with styles and CALL
DEFINE statements. We will also dig deep into example code and explore the new ability to use multilabel formatting for creating subgroup combinations. So for anyone who has ever written PROC REPORT code, stay tuned. It's
PROC REPORT Unwrapped!
INTRODUCTION
Which popular SAS procedure has features of the PRINT, MEANS, and TABULATE procedures and features of the
DATA step in a single report-writing tool? It enables you to create a variety of reports including a detail report, which contains a row of data for every input data set observation, or a summary report, which consolidates data so that each row represents multiple input data set observations. Here is another hint: this same procedure provides the ability to create both default and customized summaries, add text and statistics, and create columns of data that do not exist in the input data set. If you guessed PROC REPORT, you are correct!
For anyone who has written PROC REPORT code and has wondered what is going on behind the scenes, this is the paper for you. This paper explores some of the behind-the-scenes secrets of PROC REPORT. We will dig deep into example code as we begin to uncover some of the details of this classic report-writing
PROC REPORT Unwrapped: Exploring the Secrets behind One of the Most
Popular Procedures in Base SAS® Software
Allison McMahill Booth, SAS Institute Inc., Cary, NC, USA
ABSTRACT
Have you ever wondered why a numeric variable is referenced in different forms within a COMPUTE block? Do you know the difference between a DATA step variable and a variable that is listed in the COLUMN statement? Then, this paper is for you! Welcome to PROC REPORT Unwrapped. We are looking at PROC REPORT and uncovering some of the behind-the-scenes details about this classic procedure. We will explore the components associated with
PROC REPORT and discover ways to move column headings and change default attributes with styles and CALL
DEFINE statements. We will also dig deep into example code and explore the new ability to use multilabel formatting for creating subgroup combinations. So for anyone who has ever written PROC REPORT code, stay tuned. It's
PROC REPORT Unwrapped!
INTRODUCTION
Which popular SAS procedure has features of the PRINT, MEANS, and TABULATE procedures and features of the
DATA step in a single report-writing tool? It enables you to create a variety of reports including a detail report, which contains a row of data for every input data set observation, or a summary report, which consolidates data so that each row represents multiple input data set observations. Here is another hint: this same procedure provides the ability to create both default and customized summaries, add text and statistics, and create columns of data that do not exist in the input data set. If you guessed PROC REPORT, you are correct!
For anyone who has written PROC REPORT code and has wondered what is going on behind the scenes, this is the paper for you. This paper explores some of the behind-the-scenes secrets of PROC REPORT. We will dig deep into example code as we begin to uncover some of the details of this classic report-writing