topic Re: calculate time difference between two macro var created from %sysfunc(time(),timeampm.); in SAS Programming

calculate time difference between two macro var created from %sysfunc(time(),timeampm.);

Suzy_Cat — Sun, 22 Dec 2019 23:52:08 GMT

Hi there,

Can anyone helps me to calculate time difference between two macro vars?

%let STARTTIME =%sysfunc(time(),timeampm.);

%let CompletedTime =%sysfunc(time(),timeampm.);

data want;

Running_time=input(&CompletedTime,timeampm.)-input(&STARTTIME,timeampm.)

run;

Thanks

Sue

novinosrin — Mon, 23 Dec 2019 00:02:41 GMT

Hi @Suzy_Cat If you keep the macro vars as numbers rather than having a formmatted char value, the numeric computation is straigh forward i.e

 

%let STARTTIME =%sysfunc(time());

%let CompletedTime =%sysfunc(time());

 

data want;

Running_time=&CompletedTime-&STARTTIME;

run;

Suzy_Cat — Mon, 23 Dec 2019 00:04:40 GMT

Cool, testing now

Suzy_Cat — Mon, 23 Dec 2019 00:08:22 GMT

Cool, it worked perfectly

data want;

Running_time=&CompletedTime-&STARTTIME;

format Running_time tod9.;

run;