DATA Step, Macro, Functions and more

Name match algorithm

Reply
Super Contributor
Posts: 647

Name match algorithm

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
SAS Super FREQ
Posts: 8,743

Re: Name match algorithm

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
Super Contributor
Posts: 647

Re: Name match algorithm

Hi Cynthia,
Thank you,
Super Contributor
Posts: 647

Re: Name match algorithm

Using soundex or spedis couldnt capture this phy name:
GARRY L AUGUST
GARRY AUGUST
Ask a Question
Discussion stats
  • 3 replies
  • 179 views
  • 1 like
  • 2 in conversation