ODS EXCEL, 1 sheet with multi proc step (no dividng/separating sheet per proc step).

[t_ar_taat]

Hi
I want to avoid separating sheets per proc step.
In ods pdf, we have "startpage=no" for avoid page break.
This time no sheet break is needy.

This output has 2 sheet because 2 proc step, but 1 sheet is better for me.

ods excel file= "D:\test.xlsx" ;
proc odstext;
  p "A";
run;  

proc print data=sashelp.heart(obs=5);
 var Status;
run;
ods excel close;

2 sheets like this.

My try was failed.

ods excel options(sheet_name="sheet1");
proc odstext;
  p "A" ;
run;  

ods excel options(sheet_name="sheet1");
proc print data=sashelp.heart(obs=5);
 var Status;
run;

[t_ar_taat · Accepted solution]

Sorry this topic is already discussed.[ Sheet_Interval='none' ]
https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-EXCEL-Single-Sheet-with-By-Groups/td-p/321...