fing age and age&month and age&month&day

[sas_university]

i have 2 variables

p_id      dob

101      21/01/2000

i want like this

p_id  dod               age     month  age_m_d

101  21/01/2000    22        22.9     22Y9M11D

 help me

[Ksharp · Accepted solution]

data have;
input p_id      dob :ddmmyy10.;
temp=intck('month',dob,date(),'c');
age=int(temp/12);
month=mod(temp,12);
day=date()-intnx('month',dob,temp,'s');
age_m_d=cats(age,'Y',month,'M',day,'D');
drop temp;
format dob ddmmyy10.;
cards;
101      21/01/2000
;

[sas_university]

Thank you