topic Re: How to Create Alerts on any condition in SAS? in SAS Procedures

How to Create Alerts on any condition in SAS?

Sarvendra — Wed, 05 Feb 2014 07:52:20 GMT

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

Re: How to Create Alerts on any condition in SAS?

DBailey — Thu, 06 Feb 2014 13:52:29 GMT

The process we use requires you to:

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

Re: How to Create Alerts on any condition in SAS?

RobertWoodruff — Fri, 07 Feb 2014 14:31:57 GMT

That'll do it nicely!

Re: How to Create Alerts on any condition in SAS?

Sarvendra — Mon, 10 Feb 2014 18:01:40 GMT

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

Re: How to Create Alerts on any condition in SAS?

DBailey — Mon, 10 Feb 2014 22:01:08 GMT

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 "This email address is not monitored for replies.";

put ;

run;

%end;

Re: How to Create Alerts on any condition in SAS?

Sarvendra — Tue, 11 Feb 2014 09:29:53 GMT

Much Thanks Bailey

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

Re: How to Create Alerts on any condition in SAS?

DBailey — Tue, 11 Feb 2014 18:34:12 GMT

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

Re: How to Create Alerts on any condition in SAS?

SASKiwi — Tue, 11 Feb 2014 18:53:54 GMT

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.