topic Re: SAS-send email and attach multiple files in SAS Programming

SAS-send email and attach multiple files

Ronein — Tue, 04 Jun 2024 06:25:29 GMT

Hello,

I want to send email from SAS and in the email will have:

1-Attach XLSX file with summary data (summary data set)

2-Attach XLSX file with raw data (sashelp.cars data set)

3-In email Body print summary data (summary data set)

In the code below I attach one file (summary data)

My question-What is the way to attach also raw data (sashelp.cars data set)?


proc sql;
create table summary as
select type,
       sum(invoice) as sum_invoice
from  sashelp.cars
group by type
;
quit;


/**CREATE EXCEL FILE***/
ODS EXCEL FILE="/usr/local/SAS/SASUsers/LabRet/UserDir/udclk79/summary_Report_Cars.xlsx" style=htmlblue options(
frozen_headers="ON" 
/*autofilter = "1-17" */
row_heights="30,13,13,13,13,13,13"
flow = "header, data" 
absolute_column_width = "18,20,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10" 
sheet_name = "Cars"
) ;
title;
footnote;
title1 'Smmary of cars';
proc print data=summary  noobs;
Run;
ods excel close;

FILENAME mail EMAIL 
TO=("Ron.gdansk@gmail.com")
FROM='SAS  <Ron.Einstein@BankLeumi.co.il>'
SUBJECT="Cars"
encoding='utf-8'   
CONTENT_TYPE="text/html" 
encoding="utf-8"
attach=("/usr/local/SAS/SASUsers/LabRet/UserDir/udclk79/summary_Report_Cars.xlsx" content_type="excel");
/*******Here I want to attach also another data set called sashelp.cars****/
ODS LISTING CLOSE;
ODS HTML BODY=mail;
/*** EMAIL BODY TEXT**********/
title;
footnote;
title  JUSTIFY=center color="purple" height=25pt bold italic underlin=1  'Cars';
proc report data=summary nowd;
column _all_;
run;

Re: SAS-send email and attach multiple files

Kurt_Bremser — Tue, 04 Jun 2024 08:12:54 GMT

As almost always, Maxim 1.

From the documentation of FILENAME Statement, EMAIL method:

ATTACH='filename.ext' | ATTACH= ('filename.ext'attachment-options)

specifies the physical name of the file or files to be attached to the message and any options to modify attachment specifications. The physical name is the name that is recognized by the operating environment. Enclose the physical name in quotation marks. To attach more than one file, enclose the group of files in parentheses, enclose each file in quotation marks, and separate each with a space. Here are examples:

For the raw data, use PROC EXPORT to create the second Excel file.

Re: SAS-send email and attach multiple files

Mazi — Tue, 04 Jun 2024 08:36:58 GMT

Hi, I tried attaching using the filename statement and could not get it to work despite specifying content_type as application/x-sas-data.
I received the following error: 39996 - "ERROR: An attachment record was truncated" when sending files as email attachments

ERROR: An attachment record was truncated. The attachment LRECL is too small.

FILENAME mail EMAIL 
TO=("johndoe@email.com")
FROM=("johndoe@email.com")
SUBJECT="Cars"
encoding='utf-8'
CONTENT_TYPE="text/html"
encoding="utf-8"
lrecl=32767
attach=("%sysfunc(pathname(work))/cars.sas7bdat" content_type="application/x-sas-data");
/*******Here I want to attach also another data set called sashelp.cars****/

Data _null_;
	file mail;
	put "Testing";
	put "Testing";
run;

Though, I was wondering if you could try using the mailx command in conjunction with %sysexec macro statement instead?

Re: SAS-send email and attach multiple files

Patrick — Tue, 04 Jun 2024 12:09:10 GMT

I don't have an environment where I could try it myself but just looking at your code, the referenced usage note and doing some further Internet research I can't see anything wrong in your code.

I couldn't find any confirmed solution anywhere how to send a single .sas7bdat as email attachment.

I believe what would add value to the forums here: Contact SAS Tech Support directly and then post the final answer/resolution back here and mark it as solution/answer as provided by SAS Tech Support.

Re: SAS-send email and attach multiple files

yabwon — Tue, 04 Jun 2024 12:25:32 GMT

Try SAS7BDAT:

FILENAME mail EMAIL 
TO=("xxx@email.com")
FROM=("yyyy@email.com")
SUBJECT="Cars"
encoding='utf-8'
CONTENT_TYPE="text/html"
encoding="utf-8"
attach=(
"%sysfunc(pathname(work))/cars.sas7bdat" 
content_type="application/SAS7BDAT" /* <-----------------------*/
)
;

Bart

Re: SAS-send email and attach multiple files

Mazi — Tue, 04 Jun 2024 14:57:16 GMT

ods excel file = "~/test.xlsx";
	proc print data=sashelp.cars;
	run;
ods excel close;

proc copy in=sashelp out=work;
	select cars;
run;

FILENAME mail EMAIL 
TO=("xxx@email.com")
FROM=("xxx@email.com")
SUBJECT="Cars"
encoding='utf-8'
CONTENT_TYPE="text/html"
encoding="utf-8"
attach=(
"%sysfunc(pathname(work))/cars.sas7bdat" 
content_type="application/SAS7BDAT" "~/test.xlsx" content_type="excel"
)
;

data _null_;
	file mail;
	Put "Testing";
	Put "Testing";
run;

This seems to have worked for me.
Thank you @yabwon for the suggestion.

topic Re: SAS-send email and attach multiple files in SAS Programming

SAS-send email and attach multiple files

Re: SAS-send email and attach multiple files

ATTACH='filename.ext' | ATTACH= ('filename.ext'attachment-options)

Re: SAS-send email and attach multiple files

Re: SAS-send email and attach multiple files

Re: SAS-send email and attach multiple files

Re: SAS-send email and attach multiple files