topic Re: Find difference (in days) between 2 days in SAS Programming

Find difference (in days) between 2 days

toesockshoe — Thu, 19 Jul 2018 17:00:05 GMT

I'm trying to find the difference in dates of the format 01DEC2017... when I'm pulling in these dates they suddenly get converted to dates in the 1960's.

How can I pull these dates in and not change these dates? also how can I find the difference in dates of this format? thanks

Re: Find difference (in days) between 2 days

PaigeMiller — Thu, 19 Jul 2018 17:17:43 GMT

If they get converted to a date in 1960, then you are using a datetime function on them, this won't get you the desired results.

To find the difference between two dates, subtract them.

Re: Find difference (in days) between 2 days

Reeza — Thu, 19 Jul 2018 17:32:56 GMT

You likely have datetime variables not dates. Use DATEPART() to get the date portions or use INTCK to find the intervals.

@toesockshoe wrote:

I'm trying to find the difference in dates of the format 01DEC2017... when I'm pulling in these dates they suddenly get converted to dates in the 1960's.

How can I pull these dates in and not change these dates? also how can I find the difference in dates of this format? thanks

Re: Find difference (in days) between 2 days

toesockshoe — Thu, 19 Jul 2018 17:47:35 GMT

I checked and it is of date9. format.

Re: Find difference (in days) between 2 days

ballardw — Thu, 19 Jul 2018 17:57:37 GMT

@toesockshoe wrote:

I'm trying to find the difference in dates of the format 01DEC2017... when I'm pulling in these dates they suddenly get converted to dates in the 1960's.

How can I pull these dates in and not change these dates? also how can I find the difference in dates of this format? thanks

Show the code for how you are "pulling in these dates".

Re: Find difference (in days) between 2 days

toesockshoe — Thu, 19 Jul 2018 18:00:52 GMT

in the select statement (using proc SQL) I have:

RWS.DATE as birthdate format = date9.

Re: Find difference (in days) between 2 days

PaigeMiller — Thu, 19 Jul 2018 18:01:39 GMT

@ballardw wrote:

@toesockshoe wrote:

I'm trying to find the difference in dates of the format 01DEC2017... when I'm pulling in these dates they suddenly get converted to dates in the 1960's.

How can I pull these dates in and not change these dates? also how can I find the difference in dates of this format? thanks

Show the code for how you are "pulling in these dates".

And show us a portion of the data too.

If you do the subtraction, and you find out, for example that the difference between two dates is 22 days, and you format this difference as DATE9., you will get a date in 1960. You don't want this difference formatted.

Re: Find difference (in days) between 2 days

toesockshoe — Thu, 19 Jul 2018 18:09:14 GMT

so when I'm pulling in the dates (just pulling....not subtracting) the dates change from dates in the 2017 range to the 1960 range.

how the data looks:

RWS.DATE is 30OCT2007

then I pull it to create a new table using the statement in the above comment and it just changes to a date in the 1960's.... is that what you were asking for?

Re: Find difference (in days) between 2 days

Reeza — Thu, 19 Jul 2018 18:11:07 GMT

Post a reproducible example of your problem then please.

@toesockshoe wrote:

I checked and it is of date9. format.

Re: Find difference (in days) between 2 days

PaigeMiller — Thu, 19 Jul 2018 18:15:21 GMT

@toesockshoe wrote:

so when I'm pulling in the dates (just pulling....not subtracting) the dates change from dates in the 2017 range to the 1960 range.

how the data looks:

RWS.DATE is 30OCT2007

then I pull it to create a new table using the statement in the above comment and it just changes to a date in the 1960's.... is that what you were asking for?

You don't format the difference. It is an integer. If you don't format the difference, it looks like an integer, such as 22. If you format the difference it looks like a date in 1960.

Re: Find difference (in days) between 2 days

toesockshoe — Thu, 19 Jul 2018 18:19:01 GMT

ok so heres how I'm pulling stuff in:

proc sql;

create table new as

select A.DATE as birthdate format = date9.

from rws.people A;

quit;

table A's DATE column looks like this:

20AUG2012
22MAR2015
01JUN2002
13MAR2004
02SEP2005
03AUG2012

and the outputted birthday column looks like

04APR1962
13NOV1960
05FEB1963
17OCT1961
10OCT1962
21OCT1962
25DEC1963

Re: Find difference (in days) between 2 days

toesockshoe — Thu, 19 Jul 2018 18:20:00 GMT

I'm not formatting any difference..... I'm just pulling in the data from one dataset to another... the difference part will come later once I figure out how to pull the data correctly

Re: Find difference (in days) between 2 days

Reeza — Thu, 19 Jul 2018 19:16:32 GMT

Ok, time to stop guessing. Please post your full code and sample input and/or proc contents on your data set after retrieval.

@toesockshoe wrote:

I'm not formatting any difference..... I'm just pulling in the data from one dataset to another... the difference part will come later once I figure out how to pull the data correctly

Re: Find difference (in days) between 2 days

toesockshoe — Thu, 19 Jul 2018 20:31:56 GMT

whoops sorry... I made a dumb dumb mistake.... I realized I was calling the wrong variable