topic Re: Scheduling a job in sas without using crontab in unix in SAS Procedures

Scheduling a job in sas without using crontab in unix

DOBBINHO — Fri, 24 Nov 2017 15:46:06 GMT

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...

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

DOBBINHO — Fri, 24 Nov 2017 16:23:39 GMT

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?

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

SASKiwi — Sat, 25 Nov 2017 01:14:38 GMT

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.

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

DOBBINHO — Mon, 27 Nov 2017 07:40:52 GMT

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.

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

LinusH — Mon, 27 Nov 2017 11:51:10 GMT

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

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

DOBBINHO — Mon, 27 Nov 2017 12:11:19 GMT

lol..... yeah.... pretty neat huh?