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. 🙂
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
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.