I'm using ODS layout gridded and ODS PDF to publish 6 tables (2 rows and 3 columns) in one page.
However, SAS keeps separating the tables into three pages and publishes two tables on each page only.
I already stated STARTPAGE=NO in the options.
What else am I missing?
I use 6 ODS REGION statements along with the ODS GRIDDED:
Options nodate nonumber /*nocenter*/ orientation=landscape /*papersize=A4*/ leftmargin=0.25in rightmargin=0.001in bottommargin=0.001in; /*avoid date and timestamp on pdf outputs*/
ods pdf file='/test.pdf' NOGTITLE NOGFOOTNOTE STARTPAGE=no;
ods escapechar='~';
ods layout gridded
columns=2 ;
ods region ;
ods text='Text1';
proc tabulate data=sep_dataset s=[just=c ] format=comma12.2;
class servbd /order=data preloadfmt mlf;
class band2 /order=data preloadfmt mlf;
var pri;
table
servbd='Years of Service' ALL='Total'*{style=[font_weight=bold]},
band2='Age Groups'*(N='') ALL='Total'*(n='Total' colpctn='%'*f=pctfmt.)*{style=[font_weight=bold]}
/printmiss misstext='0';
where region='HQ' and status=1;
format servbd $servbd. band2 $Band2_.;
run;
ods region ;
ods text='Text2';
proc tabulate data=sep_dataset s=[just=c] format=comma12.2;
class retfy /order=data preloadfmt mlf;
class branch;
var pri;
table
retfy='Fiscal Years' ALL='Total'*{style=[font_weight=bold]}, pri=''*(N='Number' colpctn='%'*f=pctfmt.*{style=[font_weight=bold]})/*Add column here*/
/printmiss misstext='0';
where region='HQ' and status=1;
format retfy $retfy. ;
run;
ods region ;
ods text='Text3';
proc tabulate data=sep_dataset s=[just=c] format=comma12.2;
class group /order=data preloadfmt mlf;
class level /order=data preloadfmt mlf;
class branch;
var pri;
table
group='Group' ALL='Total'*{style=[font_weight=bold]},
level='Level'*(N='') ALL='Total'*(n='Total' colpctn='%'*f=pctfmt.)*{style=[font_weight=bold]}
/printmiss misstext='0';
where region='HQ' and status=1;
format group $group. level $level.;
run;
ods region ;
ods text='Text4';
proc tabulate data=sep_dataset s=[just=c] format=comma12.2;
class sex/order=data preloadfmt mlf;
class branch;
var age psserv ;
table
sex='Gender' all='Total'*{style=[font_weight=bold]}, age*(mean=''*f=8.1) psserv='Years of Service'*(mean=''*f=8.1)*{style=[just=c ]}
/box='Average' printmiss misstext='0';
where region='HQ' and status=1;
format sex $sex. ;
run;
ods region;
ods text='Text5';
proc tabulate data=sep_dataset s=[just=c] format=comma12.2;
class status /order=data preloadfmt mlf;;
class branch;
var pri ;
table branch='Program' ALL='Total'*{style=[font_weight=bold just=c]},
status='Employment Type'*(n='') ALL='Total'*{style=[font_weight=bold just=c]}*(n='Total' colpctn='%'*f=pctfmt.)
/printmiss misstext='0';
where region='HQ';
format branch $program. status status.;
run;
ods region;
ods text='Text6';
proc tabulate data=sep_dataset s=[just=c] format=comma12.2;
class sex /order=data preloadfmt mlf;
class status;
class branch;
var pri ;
table
sex='Gender' all='Total'*{style=[font_weight=bold just=c]}, status='Employment Type'*(N='') ALL='Total'*{style=[font_weight=bold just=c]}*(N='')
/printmiss misstext='0';
where region='HQ'; *FOR HQ TABLES ONLY;
format sex $sex. status status.;
run;
footnote1 j=left 'footnote';
ods layout end;
ods pdf close;
