Date:         Fri, 20 Jan 2006 13:58:32 -0800
Reply-To:     David L Cassell <davidlcassell@MSN.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         David L Cassell <davidlcassell@MSN.COM>
Subject:      Re: trying to match on email address
In-Reply-To:  <200601201926.k0KIBnof004898@mailgw.cc.uga.edu>
Content-Type: text/plain; format=flowed

davefickbohm@YAHOO.COM wrote:
>   I have two files.  each file holds email addresses.   I know that at
>least one email address in file A matches an email address in file B.
>   I have used a length email1 $38 on both.   I have done email1 =
>lowcase(trim(left(email) on both.
>   I still get no matches.

You may not be able to get any matches, even though there are addresses in
file A which map to the same address as in file B.  Are the following
addresses
the same?

cassell.david@epa.gov
cassell.david@epamail.epa.gov
davidcassell@mercury.cor.epa.gov
   .
   .
   .

Short answer?  At one time, all of these were legal addresses that would
reach me.
(Spammers, have fun - these are no longer valid addresses for me.)

So you may have features involving mail administration and email routing
which may totally mess up your matching.  I think you need to try sorting
both files and just *looking*.  Can you find features that need to be
accounted for?  Do you need to take the name before the '@' apart
and check individual components?  Do you need to pull apart the destination
after the '@' and look for pieces to throw away or other ways to re-combine?

This could be a monumental headache to match up *all* addresses.

HTH,
David
--
David L. Cassell
mathematical statistician
Design Pathways
3115 NW Norwood Pl.
Corvallis OR 97330

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/