topic Output/creating multiple excel documents - with preexisting excel template in SAS Programming

Output/creating multiple excel documents - with preexisting excel template

Sir_Highbury — Mon, 24 Oct 2016 16:27:26 GMT

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,

Re: Output/creating multiple excel documents - with preexisting excel template

Oligolas — Mon, 24 Oct 2016 17:14:30 GMT

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;

Re: Output/creating multiple excel documents - with preexisting excel template

Reeza — Mon, 24 Oct 2016 17:50:04 GMT

@Oligolas You can create multi sheet and control it, but it's buggy right now.