Derive AGE off Date of Birth in SAS

libname kaz "...";
data a;
set kaz.Query;
FORMAT fixed_date date9. ;
fixed_date=mdy(10,20,2016);

AGE=INT((fixed_date-Final_DOB)/365);

keep age FINAL_DOB;
run;

Leave a Reply