Can original column contain non numeric value? IF negative better read this column as numeric and you can use format to do the create the new column. I understand you have two tables - (1) defines the transformation/replacement (2) data to deal with:
proc format lib=work;
value replace
1 = '4'
2 = '5'
3 = '7'
4 = '6'
5 = '14'
6 = '13'
7 = '10'
8 = '15'
9-11 = '9'
; run;
data want;
set work.DM2_BRANDENBURG;
new_var = put(org_var,replace.);
run;
Pay attention, if original column is char type then you may have issues as '1 ' ne ' 1' for excmaple.
... View more
