Hi I need some help to calculate the Member age at end of the month each month. I have Member's date of the birth and Reporting end date.
Thank You
Ahsan
Something like this should do it:
AgeinYears = INTCK('YEAR',BirthDate, ReportDate, 'C');
Here is a link to the function:
Where is your sample input and wanted output dataset and why is this question posted on
I need to verify this variable in the data base
MBR_AGE_EOM TEST_AGE
20
20
20
20
Something like this should do it:
AgeinYears = INTCK('YEAR',BirthDate, ReportDate, 'C');
Here is a link to the function:
I moved this topic to Base SAS Programming, where it belongs.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.