Forced page break in proc report

Question

I am creating a two-column report in SAS using PROC REPORT inside an ODS PDF statement.

My code looks something like this:

ods pdf file='/file/here.pdf' columns=2; ods pagestart=now; proc report data=rpt\_data nowd missing contents=''; columns abc; by a; define a /group order=internal; define b /display; define c /display; break after a /page; run; 

This is like the “break” of the next column on the page, not on the actual new page as we would like.

Any suggestions!?!?

Running this code will lead to the problem I'm asking about.

 %let file1='/file/directory/test.pdf'; ods pdf file=&file1. columns=2; ods pdf startpage=now; proc sort data=sashelp.class out=temp; by age; run; proc report data=temp nowd missing contents=''; columns age name sex; by age; define age /group order=internal; define name /display; define sex /display; break after age /page; run; ods \_all\_ close; 

Answer 1

As far as I know, it is not yet possible to assign ods pdf from 9.2. That is, without very ugly hacks, such as adding ghost lines to a short group and coloring them with a background color so that they are invisible on paper, etc. SAS technical support is quite responsive. However, I would call them / them by email before giving up. Hope this helps a bit.

Answer 2

This may not be practical in your case, but just in case: you can set page breaks if you use ODS "Measured RTF" destination ; then you can convert the RTF file to pdf ...