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

[AK100]

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 🙂

[Kurt_Bremser]

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

[AK100]

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?

[Kurt_Bremser]

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;