topic Re: Send sas7bdat format file through SAS in SAS Programming

Send sas7bdat format file through SAS

Min3 — Fri, 25 Sep 2020 15:31:57 GMT

I created a macro, and try to use the macro to send a .sas7bdat file to an email. And I got the error message of "ERROR: An attachment record was truncated. The attachment LRECL is too small.", even after I specified the LRECL=32767, and file type as filetype=application/octet-stream, extension = sas7bdat. The code is as below.

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

%macro email2box(emailaddress=, filepath=, filetype=);

filename MailBox email "&emailaddress" attach="&filepath";

data _null_;
file MailBox;
put '!EM_ATTACH!' "&filepath" LRECL=32767;
put '!EM_CONTENTTYPE!' "&filetype" extension = 'sas7bdat';

run;

%mend email2box;

%email2box(emailaddress=abc@u.box.comm,filepath=/box/icon_lab.sas7bdat, filetype=application/octet-stream);

Re: Send sas7bdat format file through SAS

pink_poodle — Fri, 25 Sep 2020 21:29:10 GMT

There does not seem to be a fix for this error yet:
https://support.sas.com/kb/39/996.html

Re: Send sas7bdat format file through SAS

ballardw — Fri, 25 Sep 2020 21:57:45 GMT

Another option would be to create a transport file using proc Cport. This will require a recipient to use Proc Cimport to bring it into the SAS system but these files are intended for interchange between different systems, are text files and may be less sensitive to things that binary files encounter and may be preferred if sending to different operating systems.

Re: Send sas7bdat format file through SAS

Kurt_Bremser — Sat, 26 Sep 2020 13:06:10 GMT

Try this:

filename MailBox email
  to="&emailaddress"
  attach=("&filepath" content_type="application/x-sas")
;

Re: Send sas7bdat format file through SAS

Min3 — Thu, 01 Oct 2020 16:12:04 GMT

Thanks everybody for your replies.

I tried

filename MailBox email
  to="&emailaddress"
  attach=("&filepath" content_type="application/x-sas")
;

But somehow, it still doesn't work for me.

Re: Send sas7bdat format file through SAS

pink_poodle — Thu, 01 Oct 2020 16:14:13 GMT

It does not work for me either - does not give an error, just doesn’t send any email.