Hi All,
As my subject line says, I was wondering whether it is possible to have multiple tables next to each other in a single excel spreadsheet. I tried ODS Excel option 'START_AT= 1,1', 'START_AT= 1,6', 'START_AT= 1,12' for each table I'm using but it is only taking the first START_AT option and displaying the rest of the tables under the first table in vertical manner.
Current Output:-
Expected Output:-
It would be great if you could help me with this.
Thanks,
BD
One possible solution:
you could use ODS Layout Gridded and specify an html output that can be opened into excel.
filename xlout '~/test/gridded.html';
ods html file=xlout options(pagebreak='no');
ods layout gridded columns=3 column_gutter=1in;
ods region style={background=lightblue};
title 'This is the REGION 1 TITLE';
footnote 'This is the REGION 1 FOOTNOTE';
proc print data=sashelp.class(obs=10);
run;
ods region style={background=white};
/* insert space between two tables */
ods region style={background=lightgreen};
title 'This is the REGION 2 TITLE';
footnote 'This is the REGION 2 FOOTNOTE';
proc print data=sashelp.class(firstobs=11 obs=21);
run;
ods layout end;
ods html close;
Thanks for the reply! For some reason my users requested the report should only be in excel. So they changed the requirements. 🙂
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.