topic Trying to delay SAS Schedule in SAS Enterprise Guide

Trying to delay SAS Schedule

mmagnuson — Thu, 30 Jul 2020 19:06:09 GMT

Hi,

Currently there is a schedule that automatically runs SAS programs at 12:00 am every morning. I've included the following code to delay it until 3 pm but it has not worked.

data _null_;
start=DHMS(DATE(), 15, 00, 00);
wait_sec=start-datetime();
zzz=sleep(wait_sec,1);
run;

Is there something wrong with the code above?

Thanks!

Re: Trying to delay SAS Schedule

SASKiwi — Thu, 30 Jul 2020 20:36:45 GMT

I don't see anything wrong with the logic, but how it works in practice might be different. What does 'has not worked' mean? It would be better to create a new 3pm schedule.

Re: Trying to delay SAS Schedule

TomKari — Thu, 30 Jul 2020 22:22:56 GMT

If you submit it after 3PM (as I just did!) your interval will be negative. Here's a fix to move it to the NEXT 3PM.

Tom

data _null_;
	starttime=hms(23, 00, 00);
	if time() < starttime start=DHMS(DATE(), 0, 0, starttime);
	else start=DHMS(DATE()+1, 0, 0, starttime);
	wait_sec=start-datetime();
	zzz=sleep(wait_sec,1);
run;