Something like this?
data mydata;
input ID $ BirthYear BirthMonth PensionYear PensionMonth;
datalines;
1 1944 1 2009 8
2 1947 2 2012 7
3 1941 10 2007 5
;
data PensionData;
set mydata;
Birthdate = mdy(BirthMonth,1,BirthYear);
Pensiondate = mdy(PensionMonth,1,PensionYear);
PensionAgeYears = intck('year', Birthdate, Pensiondate, 'c');
PensionAgeMonth = intck('month', intnx('year', Birthdate, PensionAgeYears, 's'), Pensiondate, 'c');
format Birthdate Pensiondate ddmmyy10.;
drop Birthdate Pensiondate;
run;
http://sasnrd.com/date-basics/
... View more