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

[Suzy_Cat]

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 · Accepted solution]

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]

Cool, testing now

[Suzy_Cat]

Cool, it worked perfectly

data want;

Running_time=&CompletedTime-&STARTTIME;

format Running_time tod9.;

run;