topic Re: How to check logs for errors and send email thru sas code in SAS Procedures

How to check logs for errors and send email thru sas code

ren2010 — Fri, 14 May 2010 18:32:56 GMT

Hi All,

Just wondering is there any SAS code available to check SAS logs for errors and if send email if the job was failure or success to the person who ran the job?

I am trying to automate my process,if you all can help me,that would be great.

Thanks in advance.

Re: How to check logs for errors and send email thru sas code

sbb — Fri, 14 May 2010 19:56:26 GMT

What OS platform and verify that you are running SAS on your local machine (or otherwise). Also the SAS version would be helpful.

You can use FILENAME EMAIL engine to send a SAS notification, based on the previous SAS processing success or failure.

Scott Barry
SBBWorks, Inc.

Re: How to check logs for errors and send email thru sas code

ren2010 — Fri, 14 May 2010 23:07:55 GMT

Thanks SBB,
I am using SAS on Windows server,do you have any suggestions/reference document, how to check the errors in SAS log using SAS code.

Re: How to check logs for errors and send email thru sas code

Sandhya — Thu, 20 May 2010 15:49:01 GMT

Hi,

This link is very useful

http://www.tau.ac.il/cc/pages/docs/sas8/cms/z1271256.htm

Sandhya.

Re: How to check logs for errors and send email thru sas code

ren2010 — Thu, 20 May 2010 16:41:03 GMT

Thanks Sandhya.

Re: How to check logs for errors and send email thru sas code

ppsas — Tue, 21 Jun 2011 16:40:53 GMT

Hi Sandhya,

Can you please give me the access for the below link,or can you please send me the macro.to check logs for errors and send email thru sas code.

Thanks in advance.
DUNE

Re: How to check logs for errors and send email thru sas code

LAP — Wed, 22 Jun 2011 19:03:05 GMT

I have several jobs that are scheduled to run each night.

I capture errors based on the &syserr macro variable and %syserrortext (new in SAS 9.2) at relevents spots in my code and assigning to a new macro variable. At the end of my job, I can check the value of each of these error variables and send a status report (via email to myself or project leads).

For instance (simple example)

%let step1err = -1; * Real errors are 0 - ....; -1 indicated that step not run;
%let step1msg = ;

step goes here...

%let STEP1err = &SYSERR;
%LET step= &SYSERRORTEXT;

At the end of the job I collect all my steperrs and create a report that shows how each step completed.

This is very generalized.. you will have to adapt method to your own circumstances. Hope this gives you a startting point

Re: How to check logs for errors and send email thru sas code

kaji — Mon, 26 Oct 2015 12:18:01 GMT

Hi,

I found a pretty cool add-in to Base SAS on www.tatesoft.com that may be very usefull to you. The tool called Log Analyser is integrated into Base SAS and can produce Log summary report in a second. You may also analyse log in details if you wish. Really great tool!