I personally believe that SAS Data Quality tools (DataFlux) should be used in such cases, because it's specially designed for this kind of purpose and already has QKB (Quality Knowledge Base) built-in to correct the typo mistakes like "Ameriica", About your question, if you don't have SAS Data Quality tools, you've to make your word list for this table and have to pass it through if condition, for an example :
data have;
input x $8.;
infile datalines;
datalines;
Ameriica
Ceneda
;;;;
run;
data want;
set have;
if x in ("Ameriica", "Americca", "Amarica") then x="America";
if x in ("Ceneda", "Caneda" ) then x="Canada";
run;
You can manually identify the wrong spellings from the data by using Proc Freq (by checking unique values of it) or any other reporting procedure and add those wrong spellings in the list like above, but it might take a long if you've so many columns and data to correct it.
... View more
