sql - How would I iterate through a list in SAS and translate / replace each piece with an imported mapping? -
i new sas , i'm not sure how go replacing each part of dataset have_1 translation data set (have_2) imported sas. data have_1 1111 1234 2222 2938 3849 1234 9388 ... 2222 2222 data have_2 1111 1234 b 2222 c 2938 d 3849 e ... 9388 f data want b c d e b f c c whether or not want replace them, proc format in sas - maps value value. here how might that. note cannot reuse original 3 variables (since they're numeric), rename , drop combination if wanted same variable names. using format statement directly achieve same result visually (but underlying value still numeric one). data have_1; infile datalines missover; input var1-var3; datalines; 1111 1234 2222 2938 3849 1234 9388 2222 2222 ;;;; run; data have_2; input numval charval $; datalines; 1111 1234 b 2222 c 2938 d 3849 e 9388 f ;;;; run; data for_fmt; set have_2; start=numval; label=charval; *could use rename these mak...