topic Re: SAS DATE in SAS Programming

SAS DATE

robertrao — Thu, 09 Oct 2014 19:10:47 GMT

Hi I am trying to find the years between the two dates.

date1 date2

16MAR2011 10JAN1964

difference=date1-date2

this gives me in seconds....

How can I get years??????

Thanks

Re: SAS DATE

stat_sas — Thu, 09 Oct 2014 19:17:25 GMT

data have;

date1='16MAR2011'd;

date2='10JAN1964'd;

difference=intck('year',date2,date1);

run;

Re: SAS DATE

ballardw — Thu, 09 Oct 2014 19:17:46 GMT

If that gives seconds you have DATETIME value, it should be Days if the values are actual SAS dates.

Do you need years as in and date in 2011 and any date in 1964 = 47 or do you need to calculate as if a calendar age?

Re: SAS DATE

robertrao — Thu, 09 Oct 2014 19:24:27 GMT

Hi Ballard,

I have SAS dates and not datetimes. sorry for the confusion.

I think if we can get to the 47 that should be fine

also please let me know how to do the calendar age ....good to know

Thanks

Re: SAS DATE

robertrao — Thu, 09 Oct 2014 19:35:34 GMT

difference=intck('year',date2,date1);

I tried the above and it gives me negative age in years

Do I need to do:

difference=intck('year',date1,date2);

Thanks

Re: SAS DATE

stat_sas — Thu, 09 Oct 2014 19:50:13 GMT

What is your date1?

Re: SAS DATE

robertrao — Thu, 09 Oct 2014 19:54:09 GMT

date1=16MAR2011

date2=10JAN1964

Re: SAS DATE

art297 — Thu, 09 Oct 2014 19:55:31 GMT

Calculating age: SAS(R) 9.3 Functions and CALL Routines: Reference

Re: SAS DATE

stat_sas — Thu, 09 Oct 2014 20:02:00 GMT

Not sure, I am using the same and getting 47.

data have;

date1='16MAR2011'd;

date2='10JAN1964'd;

difference=intck('year',date2,date1);

run;

Re: SAS DATE

ballardw — Thu, 09 Oct 2014 22:44:23 GMT

Your order is different the OP.

Re: SAS DATE

Ksharp — Fri, 10 Oct 2014 13:05:10 GMT

difference=yrdif (date2,date1);