topic Excel On UNIX (SAS GRID) Corrupt As Email Attachment in SAS Programming

Excel On UNIX (SAS GRID) Corrupt As Email Attachment

JayS — Thu, 10 Mar 2022 17:16:45 GMT

EG: 7.15

EG Program creates an Excel file on UNIX SAS Grid.

When attached to a EG Generated email the attachment (email generation is fine) is corrupt and can not be opened.

User gets the 1st warning message then the 2nd MS noted file corrupt message.

When moved (FTP) to local desktop the Excel file opens fine.

Any thoughts... TIA

Here is the EG SAS Code...

/* Setting up email routine to email the Excel to the users */
/******************************************************************/
FILENAME mymail EMAIL
Attach = '/xx/xx/Metric_ReWrite/Acctname_Metric_MatchStatus.xlsx';
RUN;

DATA _null_;
FILE mymail;
PUT "!EM_TO! (&NOTIFY.)";
PUT "!EM_CC! (&NOTIFYCC.)";
PUT "!EM_REPLYTO! (&REPLYTO.)";
PUT "!EM_SUBJECT! Testing Email Of Client Master List VS Master_New (File From UNIX SAS GRID)";
PUT " ";
PUT " *** Testing to see if the Excel is still corrupt *** ";
PUT " ";
PUT "** Confirm Attachment: Acctname_Metric_MatchStatus.xlsx";
PUT " ";
PUT " ";
PUT "<EOF> End Of Testing <EOF>";
PUT " ";
RUN;

Re: Excel On UNIX (SAS GRID) Corrupt As Email Attachment

data_null__ — Thu, 10 Mar 2022 17:48:06 GMT

Maybe this

17036 - DBASE, LNK, and Lotus 123 attachment files can get corrupted when sending via SMTP email (sas.com)

or this

Solved: EMAIL device with .xlsx attachments - SAS Support Communities

Re: Excel On UNIX (SAS GRID) Corrupt As Email Attachment

JayS — Thu, 10 Mar 2022 18:54:30 GMT

Added the code, seems to include another file as an attachment, that is not an excel file.
It's odd as the new file has part of the email message in the file.

I have to open in Notepad to read it...

Still digging, thanks.

Jay

Re: Excel On UNIX (SAS GRID) Corrupt As Email Attachment

JayS — Thu, 10 Mar 2022 19:49:08 GMT

After digging around this nice simple code worked...

Thanks, Jay

filename outbox email
      from='abc@abc.com'
	  to='abc@abc.com' 
	  type='text/html'
	  subject='Test Mail'
	  attach=("/user/test.xlsx" content_type="excel");
	  
ods html body=outbox rs=none style=Htmlblue;

proc odstext;
p 'Hello,';
p ' Please find the attachment';
p 'Thank You';
title;
run;
ods html close;

Re: Excel On UNIX (SAS GRID) Corrupt As Email Attachment

Tom — Thu, 10 Mar 2022 21:59:58 GMT

Why are you sending an HTML file but pretending it is an XLSX file?