topic Re: How do i find age from Date o Birth in dd/mm/yyyy format? in New SAS User

How do i find age from Date o Birth in dd/mm/yyyy format?

Sharan — Wed, 16 Feb 2022 23:49:53 GMT

I am trying to find age using the date of birth.

Re: How do i find age from Date o Birth in dd/mm/yyyy format?

Reeza — Wed, 16 Feb 2022 23:55:34 GMT

You need two dates to calculate age, the day of birth and a reference day, for example, Age as of February 1, 2022.

YRDIF() is one method, see the second example here:
https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.2/lefunctionsref/p1pmmr2dtec32an1vbsqmm3abil5.htm#n1hxxgh4x8gx82n1tdzndva45dgo

Or an older method:
https://www.pauldickman.com/sastips/age/

@Sharan wrote:

I am trying to find age using the date of birth.

Re: How do i find age from Date o Birth in dd/mm/yyyy format?

Sajid01 — Sun, 20 Feb 2022 19:40:29 GMT

Hello
Here is an interesting paper that reviews many approaches. Select the one that suits your needs

Your Age In People Years: Not All Formulas Are the Same (pharmasug.org)

And do revie this too

The YRDIF Function (wordpress.com)

Re: How do i find age from Date o Birth in dd/mm/yyyy format?

tarheel13 — Sat, 26 Feb 2022 17:46:34 GMT

what is the second date you're comparing to?

Re: How do i find age from Date o Birth in dd/mm/yyyy format?

PaigeMiller — Sat, 26 Feb 2022 21:06:35 GMT

@Sharan wrote:

I am trying to find age using the date of birth.

Please take a minute and explain how you would do this pencil and paper? What are the exact steps? Once you know that, you (perhaps with our help) can create SAS code to do the same thing.

Re: How do i find age from Date o Birth in dd/mm/yyyy format?

Sajid01 — Sat, 26 Feb 2022 19:35:27 GMT

Hello @Sharan
Further to the references I have cited above, you can use the code which gives the age in years months and days. I have taken 01/01/1960 as the date of birth. Make sure that it serves your purpose.

I would like to emphasize that the references I gave above are a must read if you want a good understanding of the pros and cons of different approaches.

data a;
  input @1 dob mmddyy10.;
  tod=today();            
   years = intck('year', dob, tod, 'c');
   months = intck('month', intnx('year', dob, years, 's'), tod, 'c');
  days = tod - intnx('month', dob, months + years*12, 's');
  put "Age is " years "Years  "  months "Months and "  Days   "Days.";
   format dob tod mmddyy10.;
datalines;
01/01/1960 
;
run;

You can see this in the log for todays date (February 26,2022).

Age is 62 Years  1 Months and 25 Days.