topic Re: Auto run of the SAS jobs in SAS Programming

Auto run of the SAS jobs

ambadi007 — Tue, 13 Mar 2018 10:19:56 GMT

I used to schedule the SAS codes using windows scheduler. The sas codes are running daily basis from the system.
Now I need to schedule the job only in Monday and Tuesday. And I want to use a logic in macro for running the code in Monday and Tuesadyand disable the other days run .

Re: Auto run of the SAS jobs

SimonDawson — Tue, 13 Mar 2018 10:34:05 GMT

A solution would involved the following language constructs -

%sysfunc macro function
http://documentation.sas.com/?docsetId=mcrolref&docsetVersion=9.4&docsetTarget=p1o13d7wb2zfcnn19s5ssl2zdxvi.htm

%IF-%THEN/%ELSE Statement

http://documentation.sas.com/?docsetId=mcrolref&docsetTarget=n18fij8dqsue9pn1lp8436e5mvb7.htm&docsetVersion=9.4&locale=en

%MACRO Statement

http://documentation.sas.com/?docsetId=mcrolref&docsetTarget=p1nypovnwon4uyn159rst8pgzqrl.htm&docsetVersion=9.4&locale=en

today function
http://documentation.sas.com/?docsetId=lefunctionsref&docsetTarget=p0hm9egy8s7mokn1mz0yxng80ax5.htm&docsetVersion=9.4&locale=en

weekday function
http://documentation.sas.com/?docsetId=lefunctionsref&docsetTarget=p0ahi8tk3trkv5n173sil9hd7c62.htm&docsetVersion=9.4&locale=en

and lastly

endsas statement

http://documentation.sas.com/?docsetId=lestmtsref&docsetTarget=p1aok1r21bw4oqn17duao6d81m2l.htm&docsetVersion=9.4&locale=en

Take a read through this documentation and you should have what you need to put together a nice solution.

Re: Auto run of the SAS jobs

RW9 — Tue, 13 Mar 2018 10:42:23 GMT

You are already using a scheduler:

"windows scheduler"

Within that application, there is the functionality to schedule code to run on specific days. Use that, don't try to re-invent the wheel.

Re: Auto run of the SAS jobs

s_lassen — Tue, 13 Mar 2018 11:43:40 GMT

You do not need a macro for that, a simple datastep with an ABORT statement will suffice:

data _null_;
  if weekday(today()) not in(2,3) then
    abort return 0;
run;

If you put that in the top of your program, it will only run on Mondays and Tuesdays.