topic Re: Run a code every hour in SAS Programming

Run a code every hour

hhchenfx — Thu, 18 May 2023 03:05:03 GMT

Hi Everyone,

I have a code that runs every minutes.

I want to add to that code a section (which contain quite a few data steps) that should be run every hour at 00:01 (hh:mm).

Look like this added part could be something a macro inside the big one.

Can you please help me with that?

Many thanks,

HHC

%MACRO _BREAK() ;
%DO %WHILE (   %sysevalf(%sysfunc(time())<'16:00:08't,boolean)  ) ;

	/*------ADDED part that run every hour---------*/

	/*My MAIN CODE*/

    %*Sleep until 5 seconds after the start of the next minute ;
    %put %sysfunc(wakeup("%sysfunc(putn(%eval(%sysfunc(intnx(minute,"%sysfunc( time(), time )"t,1))+5),time.))"t));
  %end ;
%mend ;

Re: Run a code every hour

ballardw — Thu, 18 May 2023 03:43:02 GMT

If something needs to run at very specific times I would suggest using an actual scheduling program to start a SAS batch job at the given time.

Re: Run a code every hour

SASKiwi — Thu, 18 May 2023 04:32:12 GMT

What hours does this process need to run for? Continuously, or only for certain hours and / or on certain days?

Re: Run a code every hour

hhchenfx — Thu, 18 May 2023 13:08:58 GMT

Hi,

My main code run every minutes.

The added section need to run inside this main code but only need to be executed every hour (instead of every minute).

That's why I will can't schedule that part as a separate job.

Thanks,

HHC

Re: Run a code every hour

SASKiwi — Thu, 18 May 2023 20:56:23 GMT

Is your hourly processing related to your "by minute" processing? Does one rely on the other or not? If there is no interaction between the minute and the hourly processing then running to two separately is an option.

Also you didn't really answer my question regarding over what time periods does your process run. Does it run 24 hours per day, every day, or only for certain hours on certain days? The more hours the processing runs, the more robust and reliable it has to be.

Re: Run a code every hour

hhchenfx — Fri, 19 May 2023 02:17:37 GMT

Thank you all.

I think I got it as below.

HHC

%MACRO _BREAK() ;
%DO %WHILE (   %sysevalf(%sysfunc(time())<'16:00:08't,boolean)  ) ;

	/*------ADDED part that run every hour---------*/
		%let now=%sysfunc(time());%let hh=%sysfunc(hour(&now),z2.);%put &now;%put &hh;
		%let mm=%sysfunc(minute(&now),z2.);
		%put &mm;


		%macro run_hourly;
		%if &mm=1 %then %do;
			%put 'HERE we go';
		%end;
		%mend;
		%run_hourly;


	/*My MAIN CODE*/

    %*Sleep until 5 seconds after the start of the next minute ;
    %put %sysfunc(wakeup("%sysfunc(putn(%eval(%sysfunc(intnx(minute,"%sysfunc( time(), time )"t,1))+5),time.))"t));
  %end ;
%mend ;