topic Re: Difference between Two date in years in SAS Procedures

Difference between Two date in years

sasphd — Thu, 15 Dec 2016 14:10:08 GMT

hello,

I make the difference between two dates using this program.

data age;
set JOINT_FO;
age=caldt-FIRST_OFFER_DT;
run;

The program give me the difference in days but I want it in year or in fraction of year????

Kurt_Bremser — Thu, 15 Dec 2016 14:12:48 GMT

Look at the extremely flexible INTCK function.

Kurt_Bremser — Thu, 15 Dec 2016 14:17:54 GMT

For the simplest calculation, just consider that a year has 365.24237 days (Gregorian calendar). So divide your difference in days by that.

TheShark — Thu, 15 Dec 2016 14:24:34 GMT

Many ways to do this, I've used intck and yrdif in the past!

Age = yrdif(FirstDate, SecondDate,'AGE');

sasphd — Thu, 15 Dec 2016 14:29:56 GMT

thanks for your help guys