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;
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 25. 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.