topic Re: Chekking the data and if its not correct sending an alarm in the form of an Email in SAS EG in SAS Enterprise Guide

Chekking the data and if its not correct sending an alarm in the form of an Email in SAS EG

AK100 — Thu, 16 Apr 2020 08:19:53 GMT

Hello All,

I have a data-project in SAS EG (which is connected to SAS VA through LASR Tables). Now this data-project is being runned 2x a day automatically through the SAS management console and the task scheduler (so it is being updated 2 times a day). It is a fully automated data-set, which means that I won't check everyday if the data is realistic. It is only the end-user who sometimes tells he sees some strange values or blank fields.

Now I want the following, I want to receive an alarm message (preferable in the form of an email) if the data that is being updated is not valid. Just to give some examples: If the column speed for example contains an unrealistic value (with a 9 digit) while the normal speed should be somewhere between 0 - 200 KM/H, or if some fields are blank fields or like some datevalues are unrealistic.

Any deviation should cause the alarm to go off and send me (and others!) an e-mail (text-message, or something else, if you have any ideas?) so I can check why the data is not being updated in a correct manner. (In my head I already have made a list which could cause possible deviations).

I hope someone has a great idea, I appreciate your help. Thank you in advance 🙂

Re: Chekking the data and if its not correct sending an alarm in the form of an Email in SAS EG

Kurt_Bremser — Thu, 16 Apr 2020 09:36:53 GMT

Put the checks into your scheduled job program, and send the email instead of updating the LASR table.

Re: Chekking the data and if its not correct sending an alarm in the form of an Email in SAS EG

AK100 — Thu, 16 Apr 2020 09:45:35 GMT

Hi Kurt,

Thanks for the reply. Okay So I don't run the automated LASR tables anymore. But how exactly do you build checks in the task scheduler and send e-mails?

Re: Chekking the data and if its not correct sending an alarm in the form of an Email in SAS EG

Kurt_Bremser — Thu, 16 Apr 2020 10:11:56 GMT

In the program, there will be data steps that create a table for further processing. You can build a detection mechanism like this:

%let detect=0; /* "false" */

data next_step;
set from_previous_step;
/* processing */
if missing(variable) then call symput('detect','1');
run;

%if not &detect. %then %do;
/* create final table */
%end;
%if &detect. %then %do;
/* send email */
%end;