Hi,
I would like to know if there is a way how to supress last page break in proc report so I can use ods rtf text to put text immediately after the table and not on the other page.
Example code:
proc report data=data_table nowd split="~" out=pom;
columns page p ord param value value0 value1;
define page/order noprint;
define p/order noprint;
define ord/order noprint;
define param/display style(header)=[just=l] style(column)=[asis=on indent=0 cellwidth=8.6cm ] " ";
define value/display style(header)=[just=c] style(column)=[indent=0 cellwidth=4.47cm just=c] "Total~N=XXX";
define value0/display style(header)=[just=c] style(column)=[indent=0 cellwidth=4.47cm just=c] "Group1~N=XXX";
define value1/display style(header)=[just=c] style(column)=[indent=0 cellwidth=4.47cm just=c] "Group2~N=XXX";
compute before p / style={cellheight=0.26cm FONTSIZE=1mm};
line ' ';
endcomp;
break after page / page;
run;
ods rtf text="#S={outputwidth=100% just=l} {Region: Overall}"
Thank you for any suggestions..
Thank you Cynthia, that works if I wont use
break after page / page;
because now the break statement doesnt start new page. I want to be able to break table after lets say it gets 13cm height, and still I want be able to add some text below table on last page with ods rtf text statement
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.