Macro to Send Error Email Not Working

[sun538]

Hi,

I need to send an email to some body about the status of the main SAS code execution, such that if any error occurs, it send an email and inform that. I used the following macro at the end of my code:

  %macro send_mail;
   filename mymail email 'ABC@gmail.com' subject='Status';
     %if &syscc>0 %then %do;
       data _null_;
         file mymail;
         put 'An ERROR has occurred in the code';
       run;
     %end;
     %else %do;
       data _null_;
         file mymail;
         put 'The job ran to completion';
       run;
     %end;
   %mend;
   %send_mail

However, it sends an error email (An ERROR has occurred in the code) even when there is no error in the main body of my code. Can you please let me know why it happens and how to resolve it?

Thanks.

[ChrisHemedinger · Accepted solution]

Do you have any WARNINGs in the log?  SYSCC is set to 4 when there is a warning.  So if you want to flag just errors, try >4 for a check.

[sun538]

Many Thanks Chris. Yes, I have some warnings in the log. I changed it to &SYSCC >4 and works fine. Great. Thank you. So, there is no error type that set SYSCC a number between 0 and 4, is that correct?

[ChrisHemedinger]

Yes, for example see https://support.sas.com/kb/35/553.html.

But I agree with @Kurt_Bremser -- you should resolve the warnings too to avoid issues.  Sometimes warnings are an indicator of a problem that could cause unexpected results, even if not a SAS error.

[Kurt_Bremser]

The only thing you need to change is this:

put 'An ERROR has occurred in the code';

to this:

put 'An ERROR or WARNING has occurred in the code';

Any run that ends with SYSCC ne 0 is not acceptable, and the code needs to be fixed, or any other cause (e.g. wrong input data, wrong time to start the code etc) straightened out.