When I am using the ACROSS option which results in too many columns to fit across the page, the second set of columns are showing on the same page, rather than starting on a new page. How can I force the overflow columns onto a new page? Here is an example of my current program: data TEST;
CATEGORY = "CATEGORY";
SUBCATEGORY = "SUBCATEGORY";
RESULT = "XXXXXXXXXXXXXXXXXXXXXXX";
do i=1 to 10;
GROUP=i;
output;
end;
run;
ods _all_ close;
ods tagsets.rtf_sample file="&basepath./&subfile./TEST.rtf";
options nonumber nodate PAGENO=1 orientation=landscape papersize="ISO A4"
topmargin="0.5 in" bottommargin="0.5 in" rightmargin="0.5 in" leftmargin="0.5 in";
Title1 j=l "Title";
Footnote1 j=l "Footnote";
proc report data=TEST headline headskip missing split="|" nocenter nowd spanrows;
column CATEGORY SUBCATEGORY GROUP, RESULT;
define CATEGORY / group order=data id;
define SUBCATEGORY / group id;
define GROUP / group across "";
define RESULT / group "Result";
break after CATEGORY / page;
run;
ods tagsets.rtf_sample close;
ods listing;
... View more
