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...
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?
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.
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.
So you have someone that pays you to do cool but totally unnecessary stuff?
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.