Date:         Thu, 11 Jan 2007 22:46:38 -0500
Reply-To:     "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Subject:      Re: compare address

On Thu, 11 Jan 2007 16:22:31 +0000, toby dunn <tobydunn@HOTMAIL.COM> wrote:

>yingtao ,
>
>there are a whole host fo functions in SAS to help you along you can start
>by looking into the COMPLEV Function.  If computes a Lev. distance between
>two strings.  You will be responsible for suppling the cut of number that
>determines a match.

It's often necessary to do some preliminary parsing and standardization.

In particular, an issue here is that you and your immediate neighbors are
likely to have very similar addresses. You would want to segregate the house
number and apartment number, and look for exact equality of those segments.

>
>
>
>Toby Dunn
>
>To sensible men, every day is a day of reckoning. ~John W. Gardner
>
>The important thing is this: To be able at any moment to sacrifice that
>which we are for what we could become. ~Charles DuBois
>
>Don't get your knickers in a knot. Nothing is solved and it just makes you
>walk funny. ~Kathryn Carpenter
>
>
>
>
>
>
>From: yingtao <yingtaoliu@GMAIL.COM>
>Reply-To: yingtao <yingtaoliu@GMAIL.COM>
>To: SAS-L@LISTSERV.UGA.EDU
>Subject: compare address
>Date: Thu, 11 Jan 2007 10:18:41 -0600
>
>Due to some typing error, the address of one property may be different in *
>2* tables like following:
>table a:
>*
>
>999* HIGH MEADOW TRL and zip *75555
>*
>
>table b:
>*
>
>999* HIGHLANDMEADOW TRAIL and zip *75555
>*
>
>Anyone has a good idea to match them with some functions?
>
>thanks.
>
>_________________________________________________________________
>Communicate instantly! Use your Hotmail address to sign into Windows Live
>Messenger now. http://get.live.com/messenger/overview