topic Re: Age in SAS Programming

Age

Smitha9 — Mon, 17 Jun 2024 14:39:50 GMT

Hi,

I am using this code for pulling the birthdate >17years

FLOOR(intck('MONTH',datepart(pt.BIRTH_DATE), date())/12)> 17

But the person who has DOB of 06/29/2006 is considered as 18years and pulling that person. i tried not to use FLOOR and it still gives me the same 18years.

Can I fix this.

Re: Age

s_lassen — Mon, 17 Jun 2024 14:52:40 GMT

It's probably easier to use the YRDIF function:

yrdif(datepart(pt.BIRTH_DATE),date(),'AGE')>=18

- I think that should give the answer you want.

Re: Age

ballardw — Mon, 17 Jun 2024 15:02:53 GMT

Are you sure that your PT.BIRTH_DATE is a date time value? If the a variable is actually a date value then the DATEPART function is likely returning a date in 1960.

data example;
   x= datepart('29JUN2006'd);
   put x= date9.;
run;

So likely every birth date in your data is generating ages > 17, mostly >60.

If the values are dates remove the DATEPART function call.

Re: Age

Tom — Mon, 17 Jun 2024 19:50:33 GMT

You want to add the CONTINUOUS option to the INTCK() function count. Otherwise it is counting when you cross the BEGINNING of the month.

data test;
  birth_date = '29JUN2006'd;
  birth_dt   = '29JUN2006:00:00'dt;
  format birth_date date9. birth_dt datetime18.;
  age = yrdif(BIRTH_DATE,date(),'AGE') ;
  yr1 = floor(intck('month',birth_date,date(),'c')/12);
  yr2 = floor(intck('month',datepart(birth_dt),date(),'c')/12);
  yr3 = floor(intck('month',datepart(birth_date),date(),'c')/12);
run;