Empty dataset in ods excel

[sneha_dodle]

Hello
Im creating. xlsx spreadsheets of 11 datasets using ods excel. i got all the datasets except for one which was an empty dataset. How do i get the empty dataset into the spreadsheet using ods excel?
The code i used is
ods excel file='c:..............\report.xlsx' options(sheet_interval='proc's heet_name='sheet1');
Proc print data=one;
Run;
ods excel options(sheet_name='sheet2');
Proc print data=empty;
Run;
.
.
.
.
.
ods excel close;

The dataset empty has no observations. I want a sheet that has only variable names.. But when i run the code, the sheet related to dataset empty is missing. Is there a way to get that sheet using ods excel?

[SuzanneDorinski]

See the discussion at https://communities.sas.com/t5/General-SAS-Programming/ODS-Excel-Issues-and-Proc-Export/td-p/408267