Help using Base SAS procedures

Scheduling a job in sas without using crontab in unix

Reply
Contributor
Posts: 31

Scheduling a job in sas without using crontab in unix

I have been working on an experimental code to schedule a job in sas without using unix. The code is as follows:

%macro incrementvar(vartoincrement);

%let &vartoincrement = %eval(&&&vartoincrement + 86400);

%mend;

%macro chronjb;

data _null_;

now=datetime();

start='07NOV2017:04:35:00'dt;

wait_sec=0;

%mid: wait_sec=%sysfunc(ABS(wait_sec-(start-now)));

      zzz=sleep((wait_sec),1);

      %include 'V2D.sas';

%incrementvar(wait_sec);

%goto mid;

run;

%mend;

%chronjb;

%put &=wait_sec;

 

But it has come to me now that there has been a big issue all along. On running this program, it executes the included program after the required amount of wait time, after which it goes on a never ending loop without waiting for a day. I want the included program to execute at a specific time and keep repeating at that very same time everyday till we stop it. How do I include this way to stop the program, and how do I make it repeat at the same time everyday? Please advice...

Contributor
Posts: 31

Re: Scheduling a job in sas without using crontab in unix

Note: I know I could try using the "break" and "Window" option to try and specify if I want to continue the loop..... But how do I do so?

 

Super User
Posts: 3,927

Re: Scheduling a job in sas without using crontab in unix

Curious to know why you are trying to create your own scheduler in SAS when there are more functional OS, SAS-supplied and third party schedulers available. I would check out what schedulers are already being used in your organisation. Also scheduling is available in SAS using SAS Management Console.

Contributor
Posts: 31

Re: Scheduling a job in sas without using crontab in unix

Your curiosity is totally agreeable, but I actually want to be able to not use any external schedulers since it would be cool to find an alternative. The sleep function is a great yet cumbersome way to do so, but I kinda figured that it would probably be the only way, provided I can debug the program I made.

Super User
Posts: 5,888

Re: Scheduling a job in sas without using crontab in unix

So you have someone that pays you to do cool but totally unnecessary stuff?

Data never sleeps
Contributor
Posts: 31

Re: Scheduling a job in sas without using crontab in unix

lol..... yeah.... pretty neat huh?
Ask a Question
Discussion stats
  • 5 replies
  • 200 views
  • 4 likes
  • 3 in conversation