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?
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
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.