topic Re: Computing difference of two dates in SAS Enterprise Guide

Computing difference of two dates

deleted_user — Tue, 10 Feb 2009 16:41:13 GMT

I am new to SAS and I am not familiar with how it handles dates.

When the difference of two dates is computed, what is the output in the form of? The default is integer, but I do not know what it represents.

For example:

12DEC2005:13:00:00 - 07DEC2005:00:00:00 = 478800

If I format the computed column to be date it gives me a non-sense value (at least non-sense to me).

Is there a conversion I should perform to get the value into days?

Thank you in advance for the help.

Re: Computing difference of two dates

Doc_Duke — Wed, 11 Feb 2009 00:30:40 GMT

Dates are the number of days from 1/1/1960.
Date-Times are the number of seconds from midnight on 1/1/1960.

Date1-Date2 = number of days from date2 to date 1.
DateTime1-DateTime2 = number of seconds between the two.

There are at least two ways to get days from datetime1 and datetime2:

datepart(datetime1) - datepart(datetime2) yields the number of days (dropping off the times).

(datetime1-datetime2)/(60*60*24) yields days that have a decimal component.

Re: Computing difference of two dates

deleted_user — Wed, 11 Feb 2009 18:28:13 GMT

Thank you Doc@Duke for the help