topic Re: INTCK to compute age in SAS Programming

INTCK to compute age

fbl204653 — Wed, 18 May 2016 17:27:52 GMT

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

Re: INTCK to compute age

PGStats — Wed, 18 May 2016 18:02:33 GMT

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.

Re: INTCK to compute age

ballardw — Wed, 18 May 2016 19:25:05 GMT

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

Re: INTCK to compute age

fbl204653 — Wed, 18 May 2016 19:38:21 GMT

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;

Re: INTCK to compute age

PGStats — Wed, 18 May 2016 20:17:01 GMT

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.

Re: INTCK to compute age

fbl204653 — Wed, 18 May 2016 20:31:34 GMT

thanks a lot