Thanks Reeza, I've made progress with your help. This is what I have so far, however I'm missing a statement and some formats to automatically add year (program will run on large dataset over more than one year). There might be a better way to express today's date so I don't need to remove the year afterwards data want; set have; Birthday = cat(MOB,DOB); new=input(Birthday, 4.0); drop Birthday; rename new=Birthday; today = DATE(); /*Insert statement to convert today MMDD (simple numeric format like Birthday above)*/ if today >= Birthday then do; YOB=/*Format to insert current year*/ - age; end; if today < Birthday then do; YOB=/*Format to insert current year*/ - (age-1); end; run;
... View more
