topic Re: Sending Email - LRECL is too small in SAS Programming

Sending Email - LRECL is too small

cxkev — Mon, 20 May 2013 14:44:01 GMT

Hi,

I have created and exported an excel file (Using ODS tagsets,ExcelXP). Now am I trying to send that file via email with the following code:

%macro newrepmail (team, fileloc, recipient,desc);

FILENAME output EMAIL

SUBJECT="Test Subject"

FROM= "My Email Address"

TO= &recipient.

ATTACH=&fileloc.;

/* Sending email */

DATA _NULL_;

FILE output;

PUT "Test Body";

RUN;

%mend newrepmail;

%newrepmail (DLK,

("Location of the File"),

("Recipient"),

WT MI);

I get the error: An attachment record was truncated. The attachment LRECL is too small.

Please can anyone advise of a way round this?

Many Thanks for your help,

cxkev

Re: Sending Email - LRECL is too small

Amir — Tue, 21 May 2013 12:00:27 GMT

Hi,

I searched for the error messages you reported and found the following links:

39996 - "ERROR: An attachment record was truncated" when sending Excel files as email attachments from SAS® 9.2 in the UNIX environment

40143 - E-mail output from SAS® 9.2 fails when attachments have an LRECL value greater than 1000

I'm not sure which platform you're running SAS on, so I'm not sure which (if any) apply.

As a side note, I could not see the "desc" macro function parameter being used anywhere - may be it is in your full code; and I would recommend avoid using SAS statements for naming purposes, e.g. "output".

Hope that helps.

Regards,

Amir.

Re: Sending Email - LRECL is too small

WendyT — Tue, 21 May 2013 15:11:46 GMT

Cxkev- I was wrestling with this same item this morning. I have a monthly batch that sends QA notifications to folks, and it has run without problems for a couple of years under first 9.2, and now 9.3.

I found a problem note that suggested putting the lrecl= in the attachment specification, and it worked for me. http://support.sas.com/kb/4/425.html

We are running 9.3 (TS1M2) via remote login to a Windows 2008 server.

Hope this helps!

WendyT

%LET DAYO=%SYSFUNC(TODAY(),YYMMDDN8.) ;

FILENAME SENDMAIL EMAIL

SUBJECT="SAMPLE QA REPORT"

FROM="WendyT@ouraddress.com"

TO=("person1@ouraddress.com" "person2@ouraddress.com")

ATTACH=("&QA_REPORTS\Monthly_Sample_QA_Report_&DAYO..HTML" LRECL=9999) ;

DATA _NULL_ ;

FILE SENDMAIL ;

PUT "Coded sample results for the last 120 days are attached" ;

PUT " " ;

RUN ;

Re: Sending Email - LRECL is too small

cxkev — Thu, 23 May 2013 09:10:09 GMT

Hi,

I tried that but I still got the same error message. I'm using SAS 9.2. There was a option to install a hot fix on teh SAS site but I don't have those privelages on my work PC.

To get round the issue I simply removed the long text columns in my report, and instead, input a hyperlink within the report to take the user to a seperate report which will include the long text. As the seperate report is not being emailed it doesn't encounter the same error.

Thanks everyone for your help.

Re: Sending Email - LRECL is too small

bulewind — Wed, 30 Nov 2016 16:47:18 GMT

can you try use

CONTENT_TYPE= (or CT=) option in the FILENAME statement for the attachment as shown in the example below:

filename sendit email from="user@company.com" to="someone@domain.com" subject="Excel files from SAS" attach=("myfile.xls" content_type="application/vnd.ms-excel");

official link: http://support.sas.com/kb/39/996.html

Mine works but my file corrupt, I guess because my SAS EG 4.3 version too lower.