topic Re: Run code when minutes is 0,5,10... in SAS Programming

Run code when minutes is 0,5,10...

hhchenfx — Wed, 14 Jun 2023 00:04:56 GMT

Hi Everyone,

Inside a macro (which run every minutes), I want to run a code only when minutes = 0,5,10...45,50,55.

I can get away with the OR statement as below.

However, I would like to know if there is any "cooler" way to get it don?

Thanks

HHC

%macro time ();
	data _null_;
   	call symput('hh', hour(time()));
   	call symput('mm', minute(time()));
	run;
%if &mm =2 or &mm =5 or &mm =10 or &mm = 15 %then %do;

	%put &mm.;
%end;
%mend;

%time ();

Re: Run code when minutes is 0,5,10...

SASKiwi — Wed, 14 Jun 2023 03:07:41 GMT

What OS do your SAS sessions run on? The SLEEP function or the Windows-only WAKEUP function are likely to be useful here. How long does your repeating code run for? I'd suggest using a DO loop, using the SLEEP function to pause between loops.

Re: Run code when minutes is 0,5,10...

Kurt_Bremser — Wed, 14 Jun 2023 06:22:48 GMT

Put your code in a batch program and use the system's scheduler (e.g. cron on UNIX).

Re: Run code when minutes is 0,5,10...

hhchenfx — Wed, 14 Jun 2023 15:59:08 GMT

The problem is that my outer macro is already use the sleep function.

So I can't do sleep for the inner code.

Anyway, I do it the long way.

Thank you all for helping

HHC

%let mm = %sysfunc(minute(%sysfunc(time())));

%IF &mm=0 or &mm=5 or &mm=10 or &mm= 15 or &mm=20 or &mm=25 or &mm=30 or &mm=35 or &mm=40 or &mm=45 or &mm=50 or &mm=55
%THEN %DO;

Re: Run code when minutes is 0,5,10...

Reeza — Wed, 14 Jun 2023 16:09:14 GMT

Use IN with MINOPERATOR option?
https://www.9to5sas.com/in-operator-sas-macro/

Re: Run code when minutes is 0,5,10...

Reeza — Wed, 14 Jun 2023 16:21:01 GMT

Or do a calculation with SYSFUNC and MOD?

%macro test(mm=);

%IF %sysfunc(mod(&mm, 5))= 0
%THEN %put mm=&mm;

%mend;

%test(mm=0);
%test(mm=6);
%test(mm=10);

Re: Run code when minutes is 0,5,10...

hhchenfx — Fri, 16 Jun 2023 18:11:02 GMT

Hi Reeza,

It is exactly what I am looking for.

Thanks,

HHC