Here's a snippet of code I wrote the other day to help someone with a similar problem. data test; set your_dataset; length new_category $5 category1-category3 $7; category1 = cat('0 ', byte(150), ' 5'); * USE 150 for an EN (short) DASH and 151 for an EM (long) DASH; category2 = cat('6 ', byte(150), ' 10'); category3 = cat('11 ', byte(150), ' 20'); if Years_Nephrology_ = category1 then new_category='0-5'; else if Years_Nephrology_ = category2 then new_category='6-10'; else if Years_Nephrology_ = category3 then new_category='11-20'; else new_category='> 20'; run; proc freq ; tables new_category; run;
... View more