similar data search

Reply
Occasional Contributor
Posts: 12

similar data search


I have two files that I merged into one.  I have two columns with names.  I want to be able to query both columns and find names that are similar (not same), ie Sam Smith and Sam A. Smith.  Doable?

PROC Star
Posts: 7,356

Re: similar data search

Doable?  Yes.

One source of a bunch of code, and a couple of articles, is the site where the following article can be found:

http://www.sconsig.com/sastips/obswww15.pdf

Conversely, if your site can afford it, SAS also has a product designed to facilitate such tasks, namely:

DataFlux - Data Quality, Data Integration and Master Data Management

Ask a Question
Discussion stats
  • 1 reply
  • 178 views
  • 0 likes
  • 2 in conversation