topic Re: Age calculation (leap year) in SAS Programming

Age calculation (leap year)

SASdevAnneMarie — Mon, 09 Oct 2023 15:00:11 GMT

Hello Experts,

I'm calclulating the age between 2 dates as int(yrdif(datepart(D_NAISSANCE),datepart(d_2),'ACTUAL')), I'm wondering how to take into consideration the leap year (366 days)?

Thank you !

Re: Age calculation (leap year)

maguiremq — Mon, 09 Oct 2023 15:16:11 GMT

INTCK and INTNX (INTNX is what you would want) takes care of leap years.

https://blogs.sas.com/content/iml/2017/05/15/intck-intnx-intervals-sas.html

Re: Age calculation (leap year)

ballardw — Mon, 09 Oct 2023 20:21:08 GMT

Suggestion: Pick dates that you know the expected result for "age". Put those into the function and see the result.

If you don't know how to put a specific data the structure is 'ddMONyyyyy'd where MON is the 3-letter abbreviation of the month.

So yrdif ('02JAN2015'd, '15JUL2023'd) is what yrdif returns for a date of birth of 02JAN2015 with age evaluated on 15Jul2023.