INTCK to compute age

[fbl204653]

Method 1: Age=FLOOR((INTCK('month',dob,eventdate)-(day(eventdate)<day(dob)))/12)

Method 2: Age= INTCK('year',dob,eventdate,"Continuous")

Hi I was wondering if two methods above have the same function on calculating Age based on DOB.

Thanks a lot

[PGStats]

No, the results will differ sometimes.

Method 2 will give you the exact age. 

Method 1 will sometimes give you the wrong result when eventdate occurs in the same month as dob.

[fbl204653]

Hi PG,

I tried one example, somehow, two methods gave me the same result (see age and age2).

%macro age(date,birth);
floor ((intck('month',&birth,&date) - (day(&date) < day(&birth))) / 12)
%mend age;

data c;
WeddingDay='19may2000'd;
Today='18MAY2016'd;
age=%age(Today,WeddingDay);
age1=intck('year',WeddingDay,Today,"D");
age2=intck('year',WeddingDay,Today,"C");
run;

[ballardw]

May also want to investigate YRDIF with the 'ACT/ACT' option.

[PGStats · Accepted solution]

YRDIF actually accepts "AGE" as third argument and returns an age with a fractional part. So

floor(YRDIF(birthDate, today(),"AGE"))

is another way to get the current age in years.

[fbl204653]

thanks a lot