topic PROC REPORT: force page break in SAS Procedures

PROC REPORT: force page break

Jaheuk — Tue, 08 Nov 2011 11:04:53 GMT

Hi all,

how/can we force a page break in a COMPUTE BLOCK based on a variable like in DATA STEP programming using PUT _PAGE_ ??

I do NOT mean :

compute before xxxx _page_;

endcomp;

Regards,

Herman

PROC REPORT: force page break

Ksharp — Wed, 09 Nov 2011 02:46:09 GMT

A page break in proc report is achieve usually by break after/before.

You can not make a page break in compute block. But you can make a variable to break at appropriate place

by using break after/page.

Ksharp

Re: PROC REPORT: force page break

Jaheuk — Wed, 09 Nov 2011 14:37:23 GMT

indeed, this seems to be the only solution and it works!!

however, the reporting total also skips to a new page ???

that's the only issue I have so far

quick example:

title;
ODS LISTING CLOSE;
ODS PDF NOTOC FILE='c:\temp\mypdf.pdf' STYLE=SASWEB NOTOC;

proc sort data=sashelp.class;
by age;
run;
data WORK;
set sashelp.class;
if age < 13 then skip=0;
else skip=1;
gr_age=put(age,z4.) ;
run;

proc report data=WORK nowd;
column skip name sex gr_age age ;
define skip / noprint group;
define name / display;
define sex / display;
define gr_age / noprint group;
define age / analysis ;

BREAK AFTER gr_age / SUMMARIZE ;
break after skip / page ;
RBREAK AFTER / SUMMARIZE ;
quit;
ODS PDF CLOSE ;
ODS LISTING ;

PROC REPORT: force page break

Cynthia_sas — Wed, 09 Nov 2011 15:03:49 GMT

Hi:

If you are only using the SKIP variable for your forced page break, try this combination of BREAK/RBREAK statements:

BREAK AFTER gr_age / SUMMARIZE ;
break before skip / page ;
RBREAK AFTER / SUMMARIZE ;

I believe that you will get the grand total placed on the last page if you do a BREAK BEFORE SKIP.

Also, I would recommend that you make the GR_AGE variable an ORDER variable instead of a GROUP usage variable. You should be seeing this in the log:

NOTE: Groups are not created because the usage of xxxxxx is DISPLAY. To avoid this note, change all GROUP variables to ORDER variables.

cynthia