Hi guys,
suppose to have the following:
data DB;
input ID :$20. Date_of_Birth :date09. Age_of_class1 Age_of_class2;
format Date_of_Birth date9.;
cards;
0001 01JUL1938 85 89
0002 01JUL1977 50 54
0003 01JUL1928 55 60
;
run;
Is there a way to get the following?
data DB1;
input ID :$20. Date_of_Birth :date09. Age_of_class1 Age_of_class2 Bday_class1 :date9. Bday_class2 :date9.;
format Date_of_Birth date9. Bday_class1 date9. Bday_class2 date9.;
cards;
0001 01JUL1938 85 89 01JUL2023 01JUL2027
0002 01JUL1977 50 54 01JUL2027 01JUL2031
0003 01JUL1928 55 60 01JUL1983 01JUL1988
;
run;
In other words given the birthday date (date_of_birth), how can I get the date (Bday_class1 and Bday_class2) when each ID will have the age shown in Age_of_calss1 and Age_of_class2 variables?
Thank you in advance