topic Sending Email and attachment in SAS Programming

Sending Email and attachment

Eugenio211 — Fri, 10 Mar 2023 14:41:43 GMT

Hello, hope everyone is alright.

I just want to ask if someone has a ready code on how to stop sending an email with attachment when there's error in the data steps, instead send an 'error' email to myself.

I have written the below code but it's not working.

%if &syscc=0 %then %do;
proc export data=Test_List
dbms=xlsx
replace
outfile='\\SAS_WIP\Test_List';
sheet='Sheet1';
run;

filename mymail email 'myemail@email.com'
from='myemail <myemail@email.com>'
subject='Test List'
attach=("\\SAS_WIP\Test_List.xlsx");

data _null_;
file mymail
to=('yourmail@email.com'
)
cc=('myemail@email.com');
run;
%end;

%else %do;
filename mymail email 'myemail@email.com'
from='InternalReports <myemail@email.com>'
subject='Test List';

data _null_;
file mymail
to=('myemail@email.com');
put "ERROR :(";
run;
%end;

Thanks a lot.

Re: Sending Email and attachment

Quentin — Fri, 10 Mar 2023 14:54:45 GMT

Can you say more about what you mean by "not working"? Is the macro sending the wrong email (if so, it could be that &syscc is not being set). Or is your macro generating an error? When you have an error in your main code, does SAS enter syntaxcheckmode (set obs=0)? If so, than you may need to recover from syntaxcheckmode with something like:

%if %sysfunc(getoption(obs))=0 %then %do;
  options obs=max replace NoSyntaxCheck;
%end;

so that your data _null_ step will execute.

Re: Sending Email and attachment

Eugenio211 — Fri, 10 Mar 2023 15:10:21 GMT

it's sending the error message even though there's no error in the data steps.

Re: Sending Email and attachment

Quentin — Fri, 10 Mar 2023 15:16:57 GMT

Add %put &=syscc; before the code, to see what the value of SYSCC is. Or turn on options SYMBOLGEN MLOGIC.

Make sure you are using a new clean session when you test the code. Some tools like DI studio will maintain a session across multiple submissions. As a hack, you can %let syscc=0; at the top of your program to force it to start at 0.