topic Re: Sending Email in SAS Programming

Sending Email

Eugenio211 — Tue, 11 Apr 2023 18:09:59 GMT

Hi,

Hope all is well.

Does anybody have an email code where in if there is data an email will send with attachment and if there is no data just an email saying 'no data to report'?

Thank you in advance.

Re: Sending Email

Kurt_Bremser — Tue, 11 Apr 2023 18:56:16 GMT

Please show your code which sends the mail when data is present.

Also describe what you mean by "no data". Dataset does not exist, or dataset has zero observations?

You can retrieve such information like this:

%let data = 0;

proc sql noprint;
select nobs into :data from dictionary.tables
where libnamem= "YOURLIB" and memname = "YOURDATASET";
/* library and dataset name must be uppercase */
quit;

You can then use &data in macro statements to run your code conditionally.

Re: Sending Email

Eugenio211 — Tue, 11 Apr 2023 19:14:41 GMT

hi below is the code I use to send email with attachement, I just want to add a step that if there is no data generated i'll send an email without attachment. thank you.

filename mymail email 'myemail@email.com' from='myemail@email.com'
subject='Daily Chargebacks Report'
attach=("\\shared\Auto Reports\Chargebacks Report.xlsx");

data _null_;
file mymail
to=("someone@emailcom
)
cc=("myeamil@email.com");
put 'Hi,';
put ' ';
put 'Attached is the Chargeback report.';
put ' ';
put 'Cheers';
run;

Re: Sending Email

AhmedAl_Attar — Tue, 11 Apr 2023 19:15:28 GMT

Hi @Eugenio211

Can you please clarify:

Did you want

SAS code to send the email

OS script (Windows: PowerShell/Bat | Linux/Unix: Shell Script)

Which one?

The syntax would vary depending on your choice of language.

Re: Sending Email

Eugenio211 — Tue, 11 Apr 2023 19:18:42 GMT

SAS code to send the email, above is the
code I use to send the email. thank you.

Re: Sending Email

AhmedAl_Attar — Tue, 11 Apr 2023 19:19:38 GMT

IF you are using SAS 9.4 M5+, then you can add this to test for your data set

%if (%sysfunc(exists(lib.dataset) GT 0) %then
%do;
%end;
More details are listed in this blog
https://blogs.sas.com/content/sasdummy/2018/07/05/if-then-else-sas-programs/

Hope this helps

Re: Sending Email

Kurt_Bremser — Tue, 11 Apr 2023 19:24:27 GMT

Use my previous code, then do

%if &data.
%then %do;

filename mymail email 'myemail@email.com' from='myemail@email.com'
subject='Daily Chargebacks Report'
attach=("\\shared\Auto Reports\Chargebacks Report.xlsx");

data _null_;
file mymail
to=("someone@emailcom
)
cc=("myeamil@email.com");
put 'Hi,';
put ' ';
put 'Attached is the Chargeback report.';
put ' ';
put 'Cheers';
run;

%end;
%else %do;

filename mymail email 'myemail@email.com' from='myemail@email.com'
subject='Daily Chargebacks Report'
;

data _null_;
file mymail
to=("someone@emailcom
)
cc=("myeamil@email.com");
put 'Hi,';
put ' ';
put 'No data was created!';
put ' ';
put 'Cheers';
run;

%end;