Age calculation (leap year)

[SASdevAnneMarie]

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 !

[maguiremq]

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

[ballardw]

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.