Solved: Do while time() < '21:40:00't

hhchenfx · Posted 10-27-2022 09:45 PM

Hi All,

I would like to get SAS running job while time() < '21:40:00't .

Can you please help to fix it?

Thanks,

HHC

%macro doeveryminute() ;

  %*beware the infinite loop ;
  %do %while ( time() < '21:40:00't) ;

  MY CODE.....

  %end ;

%mend ;

%doeveryminute();

mkeintz · Posted 10-27-2022 11:27 PM

%macro do_while_time;
  %do %while (%sysfunc(time(),time8.0) LE 23:25:29);
    *code here **;
  %end;
%mend;
%do_while_time

Macro is a TEXT language, so you can't use the time-literal notation ('23:25:59't).

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------

mkeintz · Posted 10-27-2022 11:27 PM

%macro do_while_time;
  %do %while (%sysfunc(time(),time8.0) LE 23:25:29);
    *code here **;
  %end;
%mend;
%do_while_time

Macro is a TEXT language, so you can't use the time-literal notation ('23:25:59't).

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------

Ksharp · Posted 10-28-2022 07:34 AM

%macro doeveryminute ;
  %do %while (  %sysevalf(%sysfunc(time())<'21:40:00't,boolean)  ) ;

%put  MY CODE.....;

  %end ;
%mend ;

%doeveryminute

Do while time() < '21:40:00't