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?
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.
It purports to identify inconsistencies in name, address and similar fields.
On Fri, 2 Oct 2009 13:23:08 -0700, Nancy <nancy0318@GMAIL.COM> wrote:
>Is there any software or procesure from SAS or SQL to catch the
>record 1: Nancy Lee
>records 2: Nanncy Lee
>How we can pick up the these two records as duplicated records?