SAS processing time calculation problem

[vomer]

hey guys,

so I use this code to calculate the total processing time the sas program took to run but it is reporting a negative value (espicially when the program runs for more than 1 day):

%let datetime_start = %sysfunc(TIME()) ;

%put START TIME: %sysfunc(datetime(),datetime14.);

then at the end of the program I put this:

%put END TIME: %sysfunc(datetime(),datetime14.);

%put PROCESSING TIME:  %sysfunc(putn(%sysevalf(%sysfunc(TIME())-&datetime_start.),mmss.)) (mm:ss) ;

not sure what to fix?

[Haikuo · Accepted solution]

You need to use datetime value if the program running time is more than 1 day. Make them both datatime.

%let datetime_start = %sysfunc(dateTIME()) ;

%put PROCESSING TIME:  %sysfunc(putn(%sysevalf(%sysfunc(dateTIME())-&datetime_start.),mmss.)) (mm:ss) ;

Regards,

Haikuo

[vomer]

thansk!!