BookmarkSubscribeRSS Feed
prolifious
Obsidian | Level 7

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

 

3 REPLIES 3
vellad
Obsidian | Level 7
You don't see an 'Enable editing' option at the top when you open it in Excel?
prolifious
Obsidian | Level 7

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?

 

 

vellad
Obsidian | Level 7
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.

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 832 views
  • 1 like
  • 2 in conversation