Date:         Fri, 2 Oct 2009 17:53:13 -0400
Reply-To:     Arthur Tabachneck <art297@NETSCAPE.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Arthur Tabachneck <art297@NETSCAPE.NET>
Subject:      Re: How to catch the misspelled names?
Comments: To: nancy0318@GMAIL.COM

Nancy,

In addition to Dan's always sage advice, if and only if you have a rather
large budget to work with, you can look into a SAS product called dataflux.

See: http://www.dataflux.com

It purports to identify inconsistencies in name, address and similar fields.

Art
---------
On Fri, 2 Oct 2009 13:23:08 -0700, Nancy <nancy0318@GMAIL.COM> wrote:

>Hello Everyone,
>
>Is there any software or procesure from SAS or SQL to catch the
>misspelled name?
>
>For example:
>
>Data set:
>record 1:   Nancy Lee
>records 2:     Nanncy Lee
>
>How we can pick up the these two records as duplicated records?
>
>Thank you!
>
>Nancy