BookmarkSubscribeRSS Feed
elsfy
Quartz | Level 8

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 


%macro reporting(...) ; proc report data = ... ; run ; %mend ;
ods excel file = ""
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

2 REPLIES 2
JOL
SAS Employee JOL
SAS Employee

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;

Ksharp
Super User

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;

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 984 views
  • 0 likes
  • 3 in conversation