topic Re: Difference between two time periods in SAS Enterprise Guide

Difference between two time periods

avatar — Thu, 29 May 2014 18:37:46 GMT

I would like to calculate difference between two time periods in days Hours, minutes ( how long it takes to complete the task)

for example difference between 12MAY2014:08:20:19:00 and 07MAY2014:08:00:45:00

Please help

Thanks,

Re: Difference between two time periods

Reeza — Thu, 29 May 2014 19:07:00 GMT

Subtract the two records will give you the time in seconds. Then you can convert that to minutes/hours with some basic math (ie divide by 60). You can also try formatting using various time formats but because you cross days that might be an issue.

Re: Difference between two time periods

PGStats — Thu, 29 May 2014 19:10:25 GMT

Take the difference between the two, the result is a number of seconds, then express in the required units:

data _null_;

t1 = '12MAY2014:08:20:19.00'dt;

t2 = '07MAY2014:08:00:45.00'dt;

dt = t1 - t2; /* time expressed in seconds */

dtStr = catx(":", put(dt/(24*60*60),6.0), put(mod(abs(dt),24*60*60),hhmm.));

put dt= dtStr=;

run;

Message was edited by: PG To get the sign right all the time.

Re: Difference between two time periods

avatar — Thu, 29 May 2014 19:12:46 GMT

I did subtract the two . However, I like to get the results in Days Hours using format statement or functions?

Re: Difference between two time periods

avatar — Thu, 29 May 2014 19:13:30 GMT

Thanks. I will give this a try

Re: Difference between two time periods

Reeza — Thu, 29 May 2014 19:14:06 GMT

How would you like that to look? I don't believe there's a standard way to indicate days for duration in standard format.

Re: Difference between two time periods

tammy_dezilva — Thu, 29 May 2014 22:29:24 GMT

The intck function does this for you. You specify what interval you want e.g. days, hours

INTCK Function :: SAS(R) 9.4 Functions and CALL Routines: Reference, Second Edition

and the different intervals you can use:

http://support.sas.com/documentation/cdl/en/lrcon/67227/HTML/default/p0g056g35ez8son1sfavozh0lfb3.htm#n1d3z2e1f8u8drn1j70702vf4q3h http://support.sas.com/documentation/cdl/en/lefunctionsref/67239/HTML/default/viewer.htm#p1md4mx2crzfaqn14va8kt7qvfhr.htm

Re: Difference between two time periods

lloydc — Thu, 29 May 2014 22:31:22 GMT

Something like:

data _null_;

t1 = '12MAY2014:08:20:19.00'dt;

t2 = '07MAY2014:08:00:45.00'dt;

howlong = intck('second',t2,t1);

days = datepart(howlong); /* basically taken from Professional SAS Programming Secrets, dating back to V6.03 and page 366-367 */

partday = timepart(howlong);

put days 3. ':' partday time8.

run;

Re: Difference between two time periods

Ksharp — Fri, 30 May 2014 14:49:05 GMT

data x;
t1 = '12MAY2014:08:20:19.00'dt;
t2 = '07MAY2014:08:00:45.00'dt;
days = int((t1-t2)/'24:00:00't);
time= mod((t1-t2),'24:00:00't); 
format time time8. t1 t2 datetime.;
run;

Xia Keshan

Re: Difference between two time periods

avatar — Fri, 30 May 2014 14:52:35 GMT

Thanks for sample code. I will give it a try