Auto run of the SAS jobs

[ambadi007]

Hi

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 .

[SimonDawson]

A solution would involved the following language constructs -

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

%IF-%THEN/%ELSE Statement

http://documentation.sas.com/?docsetId=mcrolref&docsetTarget=n18fij8dqsue9pn1lp8436e5mvb7.htm&docset...

%MACRO Statement

http://documentation.sas.com/?docsetId=mcrolref&docsetTarget=p1nypovnwon4uyn159rst8pgzqrl.htm&docset...

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

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

and lastly

endsas statement

http://documentation.sas.com/?docsetId=lestmtsref&docsetTarget=p1aok1r21bw4oqn17duao6d81m2l.htm&docs...

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

[RW9]

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.

[s_lassen · Accepted solution]

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.