topic Re: Calculate hours difference in two datetime fields in SAS Programming

Calculate hours difference in two datetime fields

JanSanford — Thu, 22 Apr 2021 14:34:40 GMT

I have two dates in the following format:

Date 1 - 27JAN2019:22:09:00.00

Date 2 - 28JAN2019:00:24:00.00

How can i calculate difference between these two date in HOURS?

Thanks in Advance for any solution provided.

Re: Calculate hours difference in two datetime fields

Kurt_Bremser — Thu, 22 Apr 2021 14:43:02 GMT

Use the INTCK function:

data test;
dt1 = '27JAN2019:22:09:00.00'dt;
dt2 = '28JAN2019:00:24:00.00'dt;
diff = intck('hour',dt1,dt2);
format dt1 dt2 datetime23.2;
run;

Or simply calculate (dt2 - dt1) / 3600, as times and datetimes in SAS are counts of seconds.

Re: Calculate hours difference in two datetime fields

PaigeMiller — Thu, 22 Apr 2021 14:44:31 GMT

Assuming PROC CONTENTS shows this variable as numeric

difference=(date1-date2)/3600;

Re: Calculate hours difference in two datetime fields

JanSanford — Thu, 22 Apr 2021 14:55:24 GMT

Hello and thanks for the quick response. I had already tried INTCK. It only returns hours (rounded up) and not minutes.

Re: Calculate hours difference in two datetime fields

JanSanford — Thu, 22 Apr 2021 14:56:31 GMT

Hello and thanks for the quick response. I had already tried dividing by seconds. It returns a value with fractions, not minutes. IE 1.3333 rather than 01:20.

Re: Calculate hours difference in two datetime fields

Reeza — Thu, 22 Apr 2021 15:04:49 GMT

duration = (end - start) / 3600;
format duration time8.;

Apply a format.

Re: Calculate hours difference in two datetime fields

Tom — Thu, 22 Apr 2021 15:17:22 GMT

DATETIME values are seconds. So just take the difference and apply the TIME format to have the number of seconds print in the tradition HH:MM:SS style.

difference=datetime1-datetime2;
format difference time8.;

If the difference might be more than 99 hours then use a wider format, TIME12. for example.

Re: Calculate hours difference in two datetime fields

ballardw — Thu, 22 Apr 2021 15:19:43 GMT

@JanSanford wrote:
Hello and thanks for the quick response. I had already tried INTCK. It only returns hours (rounded up) and not minutes.

Since your request explicitly states hours then what is the problem with returning hours?:

How can i calculate difference between these two date in HOURS?

perhaps you need to SHOW exactly what you expect the value to be.

Re: Calculate hours difference in two datetime fields

PaigeMiller — Thu, 22 Apr 2021 15:51:24 GMT

@JanSanford wrote:
Hello and thanks for the quick response. I had already tried INTCK. It only returns hours (rounded up) and not minutes.

This was not a stated requirement of the original problem. You will get better and faster answers when you specify the entire set of requirements in your original question.

Re: Calculate hours difference in two datetime fields

Kurt_Bremser — Thu, 22 Apr 2021 16:24:04 GMT

@JanSanford wrote:
Hello and thanks for the quick response. I had already tried INTCK. It only returns hours (rounded up) and not minutes.

Quote from your initial post:

How can i calculate difference between these two date in HOURS?

If you just want the time difference in hh:mm format, subtract the two dates and assign the TIME5. format to the result.

Re: Calculate hours difference in two datetime fields

JanSanford — Thu, 22 Apr 2021 16:27:32 GMT

Perfect and elegantly simple. Thanks!

Re: Calculate hours difference in two datetime fields

ballardw — Thu, 22 Apr 2021 18:48:37 GMT

@JanSanford wrote:
Hello and thanks for the quick response. I had already tried dividing by seconds. It returns a value with fractions, not minutes. IE 1.3333 rather than 01:20.

Lets resort to a grade-school instruction:

SHOW your work.

We have no idea what you did.

Of course you get decimals, you're doing division.

And are you now saying you want "minutes" as the result? The INTCK function will return intervals of seconds, minutes and a bunch of other intervals.

data example;
    d1 ='01JAN2021:12:15:25'dt;
    d2 ='02JAN2021:10:09:18'dt;
    m = intck('minutes',d1,d2);
    s = intck('seconds',d1,d2);
    h = intck('hours',d1,d2);
run;

Re: Calculate hours difference in two datetime fields

CurtisMackWSIPP — Thu, 22 Apr 2021 22:24:51 GMT

Please mark the answer so other don't spend time seeing if you still need help.

Re: Calculate hours difference in two datetime fields

Tom — Fri, 23 Apr 2021 15:34:10 GMT

This is wrong. Remove the division.

@Reeza wrote:
duration = (end - start) / 3600;
format duration time8.;
Apply a format.