How to Create Alerts on any condition in SAS?

[Sarvendra]

Hi

I have a task of creating Alerts upon certain condition.

Task-Provide an alert for any card with $10000 or more in cash loads in 30 days.

Can anyone please tell how to create Alerts in SAS

Waiting for your replies!!!

Thanks

Sarvendra

[DBailey]

The process we use requires you to:

1. code a query that identifies the conditions for which you want to send an alert
2. wrap the code in a macro that generates an email if there are records found
3. use SAS Managment Console to schedule the job at whatever interval you need

[RobertWoodruff]

That'll do it nicely!

[Sarvendra]

Thanks a lot Bailey for the reply.but can you please elaborate step 2 and 3.how email can be genrated inside a maco and

how job can be scheduled using SAS console..can u give any detailed document link as i dont have much exp in SAS management console

Thanks

[DBailey]

unfortunately, the scheduling is site specific.

As for the email in a macro...

%macro tst();

all of your code...

proc sql noprint;

select count(*)

into :recs

from work.final_output;

quit;

%if &recs ne 0 %then %do;

     filename mailit email;

     data _null_;

    file mailit

     to=('emailaddress')

     from=('from email address')

     sender='Sender'

     Subject="subject"

     ;

    Line1= 'email text line 1';

    Line2= 'email text line 2';

    Line3 = "Syscc = &syscc";

    put Line1;

    put Line2;

    put Line3;

    put ;

    put ;

    put "This email address is not monitored for replies.";

    put ;

    run;

%end;

[Sarvendra]

Much Thanks  Bailey

But I did not get the line "unfortunately, the scheduling is site specific."..what does it mean?

[DBailey]

it means that you should talk to your site administrator or SAS support for more details.

[SASKiwi]

To provide a little bit more detail on scheduling...you can only schedule from SAS Management Console if the SAS LSF scheduler is installed as part of your SAS Server installation.

You need to find out what scheduling facilities you have available to you before we can offer further advice - as per DBailey.