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.
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 .
Why not print "Continue... " at the beginning of every page ??
compute _page_ ;
line "Continue... " ;
endcomp;
Xia Keshan
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;
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 .
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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.