How to export to excel a 0 observation data with a "No Data" note.

[sas_student1]

Thank you @andreas_lds for the suggestion, unfortunately it didn't work 😞

[Tom]

Does it not create the sheet at all?

Or does it create the sheet with column headers but no rows of data? 

If the later is there really any need to add something additional?

If the former then you probably just need to run a separate step to create the sheet you want to appear when there is no data.

Please show the code you are currently using to write the sheet as the way to adjust the code depends on what code you are currently using..