topic Page Gap and Compute in SAS Programming

Page Gap and Compute

S_Proskurnin — Mon, 22 Sep 2014 14:16:02 GMT

I have next structure in my table: Name / subname.

I need next thing in proc report: if column transfer to the next page then I need to write (Name || " (continued)") on the next page. E.g.:

Something

111

222

333

*page gap*

Something (continued)

444

555

666

Probably it can be done by compute block, but I don't know how. Please help me to solve it.

Re: Page Gap and Compute

Ksharp — Tue, 23 Sep 2014 13:49:16 GMT

Why not print "Continue... " at the beginning of every page ??

compute _page_ ;

line "Continue... " ;

endcomp;

Xia Keshan

Re: Page Gap and Compute

RW9 — Tue, 23 Sep 2014 14:01:10 GMT

Problem then is if you have multiple groups. What you could do is assign a page no in your data based on your formula (note not exact syntax, just poping this out there theoretically):

data want;

set have;

pgno=floor(_n_ / 20) + 1; /* 20 obs per page */

run;

proc report...

compute before pgno / break;

if pgno > 1 then do;

line "Continue";

end;

endcomp;

run;

Re: Page Gap and Compute

Ksharp — Wed, 24 Sep 2014 11:56:11 GMT

LINE statement is global statement, you can't execute it conditionally as you did. But you can use format $varying200. to get the same thing .

Re: Page Gap and Compute

mohamed_zaki — Wed, 24 Sep 2014 12:04:50 GMT

Check

Item 52: The ability to print the word 'CONTINUED' when a report spans pages and to print 'END' on the last page.

in this doc:http://www.sascommunity.org/seugi/SEUGI2000/trenery_havingtheproc.pdf

If it may help