Dear experts,
I have to report my data in 2 excel sheets, therefore I am usinf the option sheet interval = non but how can I move to the next sheet afterwards? I checke the forum and someone mentioned a bug, any news on it? Thanks a lot in advance for your support.
ods select all;
ods excel options(
sheet_interval="none"
suppress_bylines="yes"
sheet_label="sheet2"
embedded_titles="yes"
embed_titles_once="yes"
);
ods excel close
%include "W:\04-Programfiles\dashboard\monitoring_S02_claims_as-is_analysis.sas";
ods excel close
;run;
Best regards,
SH
IMHO, with sheet_interval=none you can not create multisheet excel files. ODS EXCEL seems not to be as flexible as EXCELXP is, since it doesn't allow to switch or to display 2 tables on sheet and 1 table on the other.
Multisheets with one table can be created like this.
ods excel file="c:\example.xlsx"
options(
suppress_bylines="yes"
sheet_label="class"
embedded_titles="yes"
embed_titles_once="yes"
);
proc print data=sashelp.class (obs=5);run;
ods excel options(
suppress_bylines="yes"
sheet_label="only cars"
embedded_titles="yes"
embed_titles_once="yes"
);
proc print data=sashelp.cars (obs=5);run;
ods excel close;
- Cheers -
@Oligolas You can create multi sheet and control it, but it's buggy right now.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.