Hi,
Do you know if it's possible to add two blank sheets before exporting SAS outputs ?
I found that it is possible to add one before and after a sheet in which there is a SAS table, or one between two different sheets containing SAS outputs. I want to know if it is possible to add two blank sheets consecutively.
I did this
ods excel file = ""
%macro reporting(...) ; proc report data = ... ; run ; %mend ;
options (sheet_interval="none" blank_sheet="INFORMATION") ;
ods excel options(sheet_name="A" blank_sheet="INFORMATION_A") ;
%reporting(...) ;
...
Yet it only outputs two sheets : "INFORMATION_A" and "A" while i want 3 sheets in this order : INFORMATION, INFORMATION_A, A
Thanks
It appears only one blank sheet can be added before your data sheet, but here's a work around you can try, add an extra ods options statement.
ods excel file="c:\temp\file.xlsx"
options (sheet_name="A" blank_sheet="Information_A");
proc print data = sashelp.class;
run;
ods excel options (blank_sheet="Information");
ods excel close;
Try this one :
ods excel file="c:\temp\file.xlsx" options (sheet_name="A" );
proc print data = sashelp.class;
run;
ods excel options (sheet_name="BlankSheet1");
proc sql;
select name label='#' from sashelp.class(obs=0);
quit;
ods excel options (sheet_name="BlankSheet2");
proc sql;
select name label='#' from sashelp.class(obs=0);
quit;
ods excel close;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.