topic similar data search in SAS Programming https://communities.sas.com/t5/SAS-Programming/similar-data-search/m-p/90450#M257277 <HTML><HEAD></HEAD><BODY><P><BR />I have two files that I merged into one.&nbsp; I have two columns with names.&nbsp; I want to be able to query both columns and find names that are similar (not same), ie Sam Smith and Sam A. Smith.&nbsp; Doable?</P></BODY></HTML> Tue, 09 Oct 2012 19:21:45 GMT pixie79 2012-10-09T19:21:45Z similar data search https://communities.sas.com/t5/SAS-Programming/similar-data-search/m-p/90450#M257277 <HTML><HEAD></HEAD><BODY><P><BR />I have two files that I merged into one.&nbsp; I have two columns with names.&nbsp; I want to be able to query both columns and find names that are similar (not same), ie Sam Smith and Sam A. Smith.&nbsp; Doable?</P></BODY></HTML> Tue, 09 Oct 2012 19:21:45 GMT https://communities.sas.com/t5/SAS-Programming/similar-data-search/m-p/90450#M257277 pixie79 2012-10-09T19:21:45Z Re: similar data search https://communities.sas.com/t5/SAS-Programming/similar-data-search/m-p/90451#M257278 <HTML><HEAD></HEAD><BODY><P>Doable?&nbsp; Yes.</P><P></P><P>One source of a bunch of code, and a couple of articles, is the site where the following article can be found:</P><P><A href="http://www.sconsig.com/sastips/obswww15.pdf" title="http://www.sconsig.com/sastips/obswww15.pdf">http://www.sconsig.com/sastips/obswww15.pdf</A></P><P></P><P>Conversely, if your site can afford it, SAS also has a product designed to facilitate such tasks, namely:</P><P><A href="http://www.dataflux.com/home.aspx?lang=en-us" title="http://www.dataflux.com/home.aspx?lang=en-us"> DataFlux - Data Quality, Data Integration and Master Data Management</A></P></BODY></HTML> Tue, 09 Oct 2012 19:48:02 GMT https://communities.sas.com/t5/SAS-Programming/similar-data-search/m-p/90451#M257278 art297 2012-10-09T19:48:02Z