topic Re: Detecting Page Break in PDF Output in PROC REPORT in SAS Procedures

Detecting Page Break in PDF Output in PROC REPORT

DonH — Thu, 02 Sep 2010 21:21:44 GMT

Am using proc report and my user has asked about a feature I thought I saw somewhere online. But I can't seem to find it now that I am actually looking for it.

The issue is to show group/order values on the first row of a new page when the group extends to a second page. I seem to recall an example doing it with temp/data step variables in a compute block.

Is this possible?

Re: Detecting Page Break in PDF Output in PROC REPORT

Cynthia_sas — Thu, 02 Sep 2010 22:08:47 GMT

Hi, Don:
Have you tried SPANROWS??? New in 9.2???
http://support.sas.com/kb/35/544.html described here for ODS RTF -- I think it also works for ODS PDF.

cynthia

Re: Detecting Page Break in PDF Output in PROC REPORT

DonH — Thu, 02 Sep 2010 22:42:33 GMT

Thanks Cynthia. Just tested it and it seems to work for a single group variable. More testing to do, but looks good so far. Thx for the pointer.

Now if only I can get it to say continued or something like that on the sucessive pages. That would be the icing on the cake. I tried a few things using temp vars and posttext, but could not get it to work. Do you have any ideas/suggestions?

Re: Detecting Page Break in PDF Output in PROC REPORT

Cynthia_sas — Thu, 02 Sep 2010 23:02:57 GMT

Ah, if you switched to TAGSETS.RTF, you CAN get "continued" when a table breaks across a page. Which is pretty cool...but I don't think it works for PDF -- it's built into the RTF tags.

It's probably too much trouble to build the RTF and then distill the RTF to PDF.

cynthia