Hello,
I am attempting to email an XLSX file that is created via ODS from a Unix environment, but I am getting two different error messages when trying to open the file in Excel 2013. The first is: "We found a problem with some cotent in 'MY_FILE.xlsx'.Do you want to try to recover as much as we can? If you trust hte source of this workbook, click Yes." After clicking "Yes", I am getting "Excel cannot open the file "MY_FILE.xlsx" becaause the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file."
When I download the file via an FTP client directly from the Unix environment, I still get the first message, but after clicking "Yes", Excel can successfully repair the file and I can view the contents.
My SAS version is 9.04 and the code that I am using is below:
<code>
ods excel file="/unix/path/MY_FILE.xlsx";
proc report data=libname.my_dataset headline headskip missing;
define product/ width=20 display style(column)={tagattr='Format:TEXT'};
define description/ width=20 display style(column)={tagattr='Format:TEXT'};
define total/ width=20 display style(column)={tagattr='Format:TEXT'};
define sub_total/ width=20 display style(column)={tagattr='Format:TEXT'};
RUN;
ods excel close;
ODS LISTING;
%let attachment = /unix/path/MY_FILE.xlsx;
filename SENDMAIL email TO= "asdf@email.com"
subject= "Email Subject"
type = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
attach= ("&attachment");
run;
DATA _NULL_;
file SENDMAIL;
RUN;
</code>
I have tried defining the content type in several ways, including adding it into the attachment arguments, but that just attempts to attach random files to the email and I still get the same error messages. I have also tried "application/xlsx" and "application/excel" content-types, both with the same results.
Any help would be greatly appreciated.
Thanks!
-Jordan
I can replicate the problem with:
%let attachment=%sysfunc(pathname(work))/MY_FILE.xlsx ;
ods excel file="&attachment";
proc print data=sashelp.class ;
run ;
ods excel close;
filename SENDMAIL email
to= "me@blah.com"
from="me@blah.com"
subject= "Email Subject"
attach= ("&attachment") ;
run;
data _null_;
file SENDMAIL;
run ;
Thanks for the verfication! Glad I'm not the only one. We've created a work around by just zipping the file first and attaching, but I'd rather not have to do that long term.
-Jordan
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.