topic ODS Excel Output Read-only File Help in SAS Programming

ODS Excel Output Read-only File Help

prolifious — Thu, 15 Oct 2020 15:43:44 GMT

i have a temp dataset that I use ODS to output as a .xlsx:

ods excel file="/myDir/…/myFile&datz..xlsx"
 options(sheet_name="mySheet0");
 proc print data=temp1 noobs label;
run;

and i send to email with

…
attach = ("/myDir/…/myFile&datz..xlsx" content_type="application/xlsx")
…

my issue is, when i retrieve the file, i cannot add filters or do anything with the data...unless i simply add another sheet to the workbook; then i can interact with it. How can i send an email with a .xlsx file that is useable without having to create a new sheet each time i open it?

Thank you

Re: ODS Excel Output Read-only File Help

vellad — Thu, 15 Oct 2020 16:24:02 GMT

You don't see an 'Enable editing' option at the top when you open it in Excel?

Re: ODS Excel Output Read-only File Help

prolifious — Thu, 15 Oct 2020 17:25:13 GMT

I know what you mean - it's like yellowish and kind of stands out at the top of the workbook. However, for these ones, that option is not there. i save it to my desktop and i still cannot edit it until i create a new sheet. i look in the advanced options of excel and allow editing is checked off.

Any other ideas out there?

Re: ODS Excel Output Read-only File Help

vellad — Thu, 15 Oct 2020 17:51:06 GMT

Hmm few suggestions to figure out root cause:
1. Try sending to another email client.
2. Try not giving sheet_name option in ods.
2. Try using proc export instead of ods.