topic Email from SAS -Add report to body email and attach 2 files in SAS Programming

Email from SAS -Add report to body email and attach 2 files

Ronein — Mon, 01 Jul 2024 07:06:56 GMT

Hello

I wan tto send an email via SAS with following information:

1- In body email add a summary table ( Data set-summary_report)

2-In body email write a few sentences :

Hello,

Please find attached a summary report on sashelp.cars

Kind Regards,

Joe

3-Attach 2 files in one Excel file (It means that attach one excel file with 2 sheets)

Attach1-summary_report

Attach2-sashelp.cars raw data

What is the code the perform this task?

Should I export the 2 files first ?



proc summary data=sashelp.cars;
class origin;
var msrp;
output out=summary_report mean=;
run;

proc export 
data=sashelp.cars
dbms=xlsx 
outfile="/usr/local/SAS/SASUsers/LabRet/UserDir/udclk79/cars.xlsx"
replace;
sheet='Raw_Data_Cars';
run;

proc export 
data=summary_report
dbms=xlsx 
outfile="/usr/local/SAS/SASUsers/LabRet/UserDir/udclk79/cars_summary_report.xlsx"
replace;
sheet='Raw_Data_Cars';
run;

Re: Email from SAS -Add report to body email and attach 2 files

Kurt_Bremser — Mon, 01 Jul 2024 07:58:57 GMT

Create the Excel files
Define a FILENAME EMAIL with the ATTACH= option for the files
Open a ODS HTML destination to the email file
Run the summary report, and PROC ODSTEXT for the text
Close the ODS destination (the mail will be sent at that point)

Re: Email from SAS -Add report to body email and attach 2 files

Ronein — Wed, 03 Jul 2024 04:54:51 GMT

Can you please show the code?

Re: Email from SAS -Add report to body email and attach 2 files

Kurt_Bremser — Wed, 03 Jul 2024 07:30:51 GMT

As I can see you already solved this here.