For clean up, how about: 1) use proc sql to create a list of distinct values for Var1 2) use data step to detect and translate defective values, write the corresponding desired value to a new var 3) merge the translation table with the original table (by the original var1 values) The result of merge should give you the original vars and plus your new alternative side by side. repeat for var2.
... View more