PROC REPORT

e-Guide	Gallery
Mind Map	Getting Started

Smarter PROC REPORT searches - The best SAS® Procedure for producing publication quality summary tables or listings. Visit the PROC REPORT Gallery to select SAS® example from one of the table layouts, access the PROC REPORT e-Guide for a complete list of table layouts, or access the Technical Report for complete list of examples by tasks. See DATA Step and Merge for post RTF file processing example, ODS and Clinical Data Reporting. For formatting syntax, see ODS Style example. See e-Guide. See Anatomy of Proc Report.

Beginner_SAS_Programmer
Advanced_SAS_Programmer
Macro_SAS_Programmer

B1.4 One or more Table Sections STYLE(X1 X2) (Best to always specify)	PROC REPORT Statement (DEFINE/BREAK/RBREAK/ COMPUTE BLOCK overrides PROC REPORT level)	C2. Override Default Style Element with one or more Style Attribute and Value STYLE(TABLE_SECTION(S)) = [ATTRIBUTE1 = VALUE1 ATTRIBUTE2 = VALUE2]
REPORT (Default)	PROC REPORT	TABLE (Default Style Element)
COLUMN	PROC REPORT, DEFINE	DATA (Default Style Element)
HEADER (Default for DEFINE)	PROC REPORT, DEFINE	HEADER (Default Style Element)
SUMMARY	PROC REPORT, BREAK/RBREAK	DATAEMPHASIS (Default Style Element)
LINES	PROC REPORT, BREAK/RBREAK, COMPUTE BLOCK	NOTECONTENT (Default Style Element)
CALLDEF	PROC REPORT, CALL DEFINE within COMPUTE BLOCK	DATA (Default Style Element)

B1.4 Examples Insert Style In - SAS Paper, In-Line Fomatting	Affects this Table Section
proc report data=sashelp.prdsale nowd style(summary) = {background=green};	All Summary rows
proc report data=sashelp.prdsale nowd style(column) = {background=green};	All Columns (Not recommended)
define actual / style(column) = {background=green});	ACTUAL column
compute actual; call define(actual, 'style', 'style = {background=green}'); endcomp;	Computed ACTUAL column

B1.4 Useful Proc Report Style Attributes

Statement	Section	Attribute Value
PROC REPORT	STYLE(REPORT)=	{CELLSPACING=3 BORDERWIDTH=5 JUST=CENTER ASIS=ON RULES=GROUPS};
PROC REPORT	STYLE(HEADER)=	{VJUST=MIDDLE};
DEFINE N	STYLE(COLUMN)=	{FONT_WEIGHT=BOLD CELLWIDTH=3CM FONT_FACE=HELVETICA JUST=CENTER INDENT=10PT};
DEFINE RACE	STYLE(COLUMN)=	{FONT_FACE=ITALICS 'Race'};
DEFINE RACE		/'^R" \i\fs24 " Race'; (alternative to STYLE(COLUMN))

Without BREAK statement

With BREAK statement, _BREAK_

(N/A for RTF)

Continuous rows across pages

Create page variable to count rows with manual determination of page breaks

Header/Footer Section contains Global Titles/Footnotes

BODYTITLE option produces Titles/Footnotes within the Table

Alternative to BODYTITLE and ^{PAGEOF} issues:

1 - Add BODYTITLE_AUX option

2 - Insert Microsoft Word syntax for Page X of Y. This technique keeps titles and footnotes with the table as well as correctly display the Page X of Y in the footnote.

ods rtf file = "&path\&dirname\demog_rpt4.rtf" bodytitle;

footnote3 j=l "Table run: &dtm";
j=r "{Page} {\field{\*\fldinst { PAGE }}}\~{of}\~{\field {\*\fldinst
{ NUMPAGES }}}";

(Note that BODYTITLE issue such as with PAGEOF may be resolved with more recent SAS versions - See ODS.)

BREAK statement controls the display of Titles/Footnotes or blank rows by variable for per page breaks

N/A

SUMMARIZE, STYLE, PAGE, SUPPRESS

Listing only: DOL, OL, DUL, UL, SKIP

***code for generating page numbers in proc report;

PROC SQL NOPRINT;

SELECT max(page) into :tpg FROM rpt ;

SELECT length(compress(put(max(page),best.))) into :tpgd FROM rpt ;

QUIT; %put &tpgd;

data _null_;

call symput("_tpg",compress(put(&tpg,&tpgd..)));

run; %put ****&_tpg.***;

*--------------------------------------------------------------;

options missing='';* ls=120 ps=65 nodate nonumber orientation = Landscape;

%macro rpt;

ods escapechar '^';

proc report data=rpt nowindows headskip headline missing split = '~' spacing=1 style(column)={asis=on} style={pretext="\b &tblnum &_t_1 \line &_t_2 \line"};

by page pg;

column page pg ord1

(label1 col1 (" ^R/RTF'\brdrb\brdrs Phase 2" col2 col3 col4 ) ) ;

define page / order order = internal noprint ;

define pg / order order = internal noprint ;

define ord1 / order order = internal noprint ;

define label1 /display style(column)={just=left cellwidth= 4in} style(header)={just=left} "" width = 40 flow;

define col1 / display style(column)={just=center cellwidth=1.25in} "Phase 1~(N = &n1)" flow ;

define col2 / display style(column)={just=center cellwidth=1.25in} "Cohort 1~(N = &n2_1)" flow ;

define col3 / display style(column)={just=center cellwidth=1.25in} "Cohort 2~(N = &n2_2)" flow ;

define col4 / display style(column)={just=center cellwidth=1.25in} "Total~(N = &n3)" flow ;

compute before ord1; line @1 ""; endcomp;

compute before page; comppage=page; endcomp;

compute after _page_/center;

line "^R/RTF'\qr\ Page " comppage &tpgd.. " of &_tpg."

"\par\sbys\ql &_f_1" ;

line "&_f_2 "; line "&_f_3"; line "&_f_4"; line "&_f_5"; line "&_f_6";

line "^R/RTF'\par\sbys\ql PROGRAM NAME: &pgm"

" DATE: &systime/&sysdate9";

endcomp; run;

PROC SORT DATA; BY AGE SEX; RUN;

PROC REPORT; COLUMN AGE SEX;
<outer Group> <Inner Group>

BREAK AFTER AGE / PAGE;
BREAK AFTER SEX / PAGE; RUN;

Output -
Age Name Sex
12 Barb F <- break after sex
12 Carl M
12 Dave M <- break after sex same as age

13 Edna F
13 Fran F <- break after sex
13 Gene M
13 Harry M
13 Ivan M <- break after sex same as age

14 Jill F
14 Kathy F
14 Laura F <-break after sex same as age

SAS Paper, Unicode List, Hex to Decimal List, Help with Character Map

TABLE BODY	COMPUTE_COLUMN_VARIABLE
COMPUTE_ROW_VARIABLE	Summary Stats (.MIN, .MAX, .SUM, .MEAN)

Basic Syntax of PROC REPORT statements:
COLUMNS <VAR1> <VAR2>;

DEFINE <VAR1> / <OPTIONS>;
DEFINE <VAR2> / <OPTIONS>;

COMPUTE;
ENDCOMP;

BREAK;
RBREAK;
RUN;

Proc Report Gallery

SAS Course Notes Practically Perfect Presentations Using ODS and PROC REPORT, Cynthia Zender

SAS Course Notes A Tutorial on Proc Report, Cynthia Zender

RTF Control Words Reference

See Top Pharmaceutical Industry Papers section for more Proc Report examples

Default Proc Report Listing

LAB_TEST	VISIT_DT Columns 1 to 50	VISIT_DT Columns 51 to 100
Records 1 to 50	1	3
Records 51 to 100	2	4

Order for records and columns spanning across multiple pages using either ACROSS variable for dynamic columns or fixed column variables. For ACROSS variable, columns 1 to 50 for all records 1 to 50 and then 51 to 100 are displayed before columns 51 to 100 for all records 1 to 50 and then 51 to 100. Columns 1 to 50 and 51 to 100 represent unique values of VISIT_DT variable. All LAB_TEST values are displayed first before displaying the next set of VISIT_DT values. Table headers may repeat if number of records is less that the page length number of records.

Options to control Proc Report Listing

LAB_TEST	VISIT_DT Columns 1 to 50	VISIT_DT Columns 51 to 100
Records 1 to 50	1	2
Records 51 to 100	3	4

Order and page breaks - sort by key variables, group blocks of records with counters, fill blank records to end of page, and subset Proc Report for each page basically. This techniqe not only prevents dupluicate table headers on pages, but also displays all VISIT_DT for a set of LAB_TEST before displaying the next set of LAB_TEST values. Note that you may need to test and adjust your code to perfect this method and that this technique will work with as a SAS Listing but not with ODS.