Find difference (in days) between 2 days

[toesockshoe]

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

[PaigeMiller]

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.

[Reeza]

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

---

[toesockshoe]

I checked and it is of date9. format.

[Reeza]

Post a reproducible example of your problem then please.

---

@toesockshoe wrote:

I checked and it is of date9. format.

---

[toesockshoe]

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

.

.

.

[ballardw]

---

@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".

[toesockshoe]

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

RWS.DATE as birthdate format = date9.

[PaigeMiller]

---

@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.

[toesockshoe]

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?

[PaigeMiller]

---

@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.

[toesockshoe]

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

[Reeza]

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

---

[toesockshoe]

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