topic Re: Name match algorithm in SAS Programming

Name match algorithm

SASPhile — Fri, 25 Sep 2009 14:55:53 GMT

Hi,
I have to compare the physician's names from two sources and and determine if they match or not.
One source, patient data has physician's listed differently from physician's listed in vendor's list.
Say for example
GARRY L AUGUST is listed in patient data
GARRY AUGUST is listed in vendor's list.
When performing a join they dont match.

Thanks,
SASPhile

Re: Name match algorithm

Cynthia_sas — Fri, 25 Sep 2009 15:07:59 GMT

Hi:
Look at the functions listed in these previous forum postings and in these papers. They should point you in the right direction. In addition, if you have the DataFlux software, as part of DI Studio, you may be able to clean up the data using the DataFlux routines.

cynthia
Postings:
http://support.sas.com/forums/thread.jspa?messageID=20055乗
http://support.sas.com/forums/thread.jspa?messageID=17020䉼
http://support.sas.com/forums/thread.jspa?messageID=20647傧

Papers:
http://www.nesug.org/proceedings/nesug07/ap/ap23.pdf
http://www.geocities.com/nyasug2002/COMPGED.pdf

Re: Name match algorithm

SASPhile — Fri, 25 Sep 2009 15:45:58 GMT

Hi Cynthia,
Thank you,

Re: Name match algorithm

SASPhile — Fri, 25 Sep 2009 16:15:42 GMT

Using soundex or spedis couldnt capture this phy name:
GARRY L AUGUST
GARRY AUGUST