topic Re: How to calculate time difference (minutes) between two datetime fields in SAS Enterprise Guide

How to calculate time difference (minutes) between two datetime fields

mdavidson — Wed, 06 Aug 2008 12:42:35 GMT

I have two datetime fields and want to calculate the difference in minutes between the two fields. I don't believe the DATDIF function will return minutes, will it? Is there another function that I can use? So far I haven't had any luck searching the SAS EG help or the web....

Thanks in advance.

Re: How to calculate time difference (minutes) between two datetime fields

mdavidson — Wed, 06 Aug 2008 13:32:39 GMT

Got it: INTCK('minute',field1,field2 )

Re: How to calculate time difference (minutes) between two datetime fields

Doc_Duke — Tue, 26 Jul 2016 17:33:12 GMT

@mdavidson wrote:
got it: INTCK('minute',field1,field2 )

INTCK can give results that aren't what you want in all cases, as it counts from the beginning of the interval (see the Details section of the documentation). If your data are recorded to the minute, it won't matter. If your data are recorded to the second, it might.

As datetime variables are recorded in seconds, an alternative is to use the fact that there are 60 seconds in a minutes and just do the arithmetic directly

(datetime2 - datetime1)/60 provides minutes with decimal fractions.
FLOOR( (datetime2 - datetime1)/60 ) provides the whole minute durations.

For instance, 12:01:50 to 12:02:10 is 1 using INTCK, 0.333 using the decimal minutes, and 0 using the FLOOR version.

Re: How to calculate time difference (minutes) between two datetime fields

Mantagon — Thu, 25 Mar 2010 18:17:30 GMT

This is exactly what I wanted. Thanks very much!