Hello,
Thanks ..Just now I have realised hour function will not output beyond 23. I have changed the logic to use date function for my logic. Below is my code.
This code I will be executing on start day of month and it will check for the trigger file based on last modified time. If the trigger file is within in the last 2 days, then it should complete the job otherwise the job should be waiting until the trigger file is received ( Please note I cant use file exists as the trigger file will not be removed by the owner and it will be ovwewritten always, thats the reason Im using last modified time function) . So I thought of using sleep function for 30mins and again the code should check for trigger file. This should be in loop always until my condition is met.
Below code is not meeting my requirement.
filename fname 'C:\test_loop.txt';
data want ; fid = fopen('fname'); if fid then do ; flm = finfo(fid,'Last Modified'); lm=put(datepart(input(flm,anydtdtm60.)),date9.); lm2=input(lm,date9.); format lm2 date9.; end; else put ' No file'; run;
data have; set want; days_diff=intck('day',lm2,today()); do while (days_diff <=2); call sleep(1800); end; put 'Job Completed'; run;
... View more