topic Re: Send EMail as soon as job fails in SAS Programming

Send EMail as soon as job fails

Son_Of_Krypton — Thu, 11 Jun 2020 09:26:47 GMT

i want to send a mail as soon as it gets error on condition below

data _null_;

if nobs>0 then
do;
put 'ERROR: No of observations that need to be corrected are ' nobs ;
abort abend;
end;
stop;

set test;

run;

Mail should be sent out as nobs "need to be corrected based on test.xlsx file".

Can anyone help me with this

Re: Send EMail as soon as job fails

Kurt_Bremser — Thu, 11 Jun 2020 09:37:00 GMT

@Son_Of_Krypton wrote:

i want to send a mail as soon as it gets error on condition below

data _null_;

if nobs>0 then
do;
put 'ERROR: No of observations that need to be corrected are ' nobs ;
abort abend;
end;
stop;

set test;

run;

Mail should be sent out as nobs "need to be corrected based on test.xlsx file".

Can anyone help me with this

nobs will always be missing at the beginning of the data step, so your condition can never be true. Did you actually want to send the mail depending on the number of observations in dataset test, and not on a variable called nobs in that dataset?

Re: Send EMail as soon as job fails

Son_Of_Krypton — Thu, 11 Jun 2020 09:41:53 GMT

scenario is like if table has more than one record then it should fail and mail should be sent.as i mentioned ignore nobs then

Re: Send EMail as soon as job fails

Kurt_Bremser — Thu, 11 Jun 2020 10:14:13 GMT

Then you need the NOBS= option in the SET statement:

data _null_;
if nobs > 1
then do;
  put 'ERROR: No of observations that need to be corrected are ' nobs ;
  abort abend;
end;
stop;
set test nobs=nobs;
run;

Re: Send EMail as soon as job fails

ChrisNZ — Thu, 11 Jun 2020 11:06:00 GMT

Like this?

filename EMAIL email;
data_null_;
  if 0 then set TABLE nobs=NOBS;
  if NOBS>1 then do;
    file MAIL to      = 'user@company.com'
              subject = 'Error Mail message';
    put "Hello";
    put "We have a problem";  
  end;
  stop;
run;

Re: Send EMail as soon as job fails

Son_Of_Krypton — Thu, 11 Jun 2020 11:13:00 GMT

program also need to be aborted

Re: Send EMail as soon as job fails

ChrisNZ — Thu, 11 Jun 2020 11:21:44 GMT

Surely you can add that.

And the proper email content.

Re: Send EMail as soon as job fails

Son_Of_Krypton — Thu, 11 Jun 2020 12:54:44 GMT

I am getting below error:

filename EMAIL email;

data _null_;
3834 if 0 then set TEST nobs=NOBS;
3835 if NOBS>1 then do;
3836 file MAIL to = 'user@company.com'
^
ERROR: Option "to" is not known for FILE
3837 subject = 'Error Mail message';
3838 put "Hello";
3839 put "We have a problem";
3840 put "Error: Records not matching" ;
3841 end;
3842 stop;
3843 run;

Re: Send EMail as soon as job fails

Kurt_Bremser — Thu, 11 Jun 2020 13:11:07 GMT

Specify the EMAIL file reference in a separate FILENAME Statement, EMAIL (SMTP) Access Method, and study the documentation I linked to.

Re: Send EMail as soon as job fails

ChrisNZ — Thu, 11 Jun 2020 22:32:12 GMT

Apologies for the botched email syntax and glad you could solve your question.

I copied without thinking from the first source I found.