topic Re: Correct the spelling if middle of the string in SAS Programming

Correct the spelling if middle of the string

BrahmanandaRao — Sun, 05 Jan 2020 13:51:23 GMT

data test;
x='Ameriica';
run;

correct the spelling its is one data if we have huge file in that miss spell words how to solve it

Re: Correct the spelling if middle of the string

Kalind_Patel — Sun, 05 Jan 2020 15:11:56 GMT

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.

Re: Correct the spelling if middle of the string

hashman — Sun, 05 Jan 2020 22:24:44 GMT

@BrahmanandaRao:

Spell checking isn't simple business. Instead of restating what has already been eloquently said elsewhere, I'd suggest that you take a look at this thread:

https://communities.sas.com/t5/SAS-Programming/Speling-Korrecter/td-p/33164

Kind regards

Paul D.

Re: Correct the spelling if middle of the string

PaigeMiller — Sun, 05 Jan 2020 22:36:38 GMT

How would a programmer in your situation know what are incorrect spellings that need to be corrected?