topic fing age and age&month and age&month&day in SAS Programming

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

sas_university — Sat, 10 Sep 2022 03:21:37 GMT

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

Re: fing age and age&month and age&month&day

Ksharp — Sat, 10 Sep 2022 10:27:42 GMT

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
;

Re: fing age and age&month and age&month&day

sas_university — Wed, 14 Sep 2022 08:53:18 GMT

Thank you