Hi All,
What is the best way to find and replace values in a field separated by , from values in a mapping table
DATA HAVE;
length R_TYP $250. ;
infile datalines ;
input R_TYP;
datalines;
son,daughter
uncle
aunty
son,uncle
;
run;
DATA TEST_MAPPING;
length K_TYP $100. S_TYP $100.;
infile datalines delimiter=',' dsd truncover;
input K_TYP S_TYP;
datalines;
son,family
daughter,family
uncle,extended family
aunty,extended family
;
run;
DATA WANT;
length R_TYP $250. ;
infile datalines ;
input R_TYP;
datalines;
family,family
extended family
extended family
family,extended family
;
run;
The output in WANT table is what I need as my final output by checking values in the MAPPING table - TEST_MAPPING
... View more