https://communities.sas.com/t5/ODS-and-Base-Reporting/Empty-dataset-in-ods-excel/m-p/542861#M22504 Hello<BR />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?<BR />The code i used is<BR />ods excel file='c:..............\report.xlsx' options(sheet_interval='proc's heet_name='sheet1');<BR />Proc print data=one;<BR />Run;<BR />ods excel options(sheet_name='sheet2');<BR />Proc print data=empty;<BR />Run;<BR />.<BR />.<BR />.<BR />.<BR />.<BR />ods excel close;<BR /><BR />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?<BR /> Wed, 13 Mar 2019 16:18:10 GMT sneha_dodle 2019-03-13T16:18:10Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Empty-dataset-in-ods-excel/m-p/542861#M22504 Hello<BR />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?<BR />The code i used is<BR />ods excel file='c:..............\report.xlsx' options(sheet_interval='proc's heet_name='sheet1');<BR />Proc print data=one;<BR />Run;<BR />ods excel options(sheet_name='sheet2');<BR />Proc print data=empty;<BR />Run;<BR />.<BR />.<BR />.<BR />.<BR />.<BR />ods excel close;<BR /><BR />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?<BR /> Wed, 13 Mar 2019 16:18:10 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Empty-dataset-in-ods-excel/m-p/542861#M22504 sneha_dodle 2019-03-13T16:18:10Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Empty-dataset-in-ods-excel/m-p/543001#M22505 <P>See the discussion at&nbsp;<A href="https://communities.sas.com/t5/General-SAS-Programming/ODS-Excel-Issues-and-Proc-Export/td-p/408267" target="_blank" rel="noopener">https://communities.sas.com/t5/General-SAS-Programming/ODS-Excel-Issues-and-Proc-Export/td-p/408267</A></P> Thu, 14 Mar 2019 03:52:30 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Empty-dataset-in-ods-excel/m-p/543001#M22505 SuzanneDorinski 2019-03-14T03:52:30Z