topic Re: How to do a fuzzy comparison of texts? in SAS Data Science https://communities.sas.com/t5/SAS-Data-Science/How-to-do-a-fuzzy-comparison-of-texts/m-p/203255#M9460 <HTML><HEAD></HEAD><BODY><P>Thank you very much for your helpful answer!</P></BODY></HTML> Thu, 11 Jun 2015 11:58:59 GMT badikidiki 2015-06-11T11:58:59Z How to do a fuzzy comparison of texts? https://communities.sas.com/t5/SAS-Data-Science/How-to-do-a-fuzzy-comparison-of-texts/m-p/203253#M9458 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>what we want to do is to find multiple persones in our dataset.</P><P>We do have names and addresses of these persons. </P><P>The problem is that there are different ways in spelling names of persons or streets - e.g. with "-" or without / "n" or "nn".</P><P></P><P>Is there any possibility in SAS to do a "fuzzy" comparison of alphanumeric variables?</P><P>Something like "most" (90%, 95%) of two strings is identical ?</P><P></P><P>Thanks!</P><P></P><P>badikidiki&nbsp; </P></BODY></HTML> Thu, 11 Jun 2015 11:04:48 GMT https://communities.sas.com/t5/SAS-Data-Science/How-to-do-a-fuzzy-comparison-of-texts/m-p/203253#M9458 badikidiki 2015-06-11T11:04:48Z Re: How to do a fuzzy comparison of texts? https://communities.sas.com/t5/SAS-Data-Science/How-to-do-a-fuzzy-comparison-of-texts/m-p/203254#M9459 <HTML><HEAD></HEAD><BODY><P>You could look here: <A href="http://blogs.sas.com/content/sgf/2015/01/27/how-to-perform-a-fuzzy-match-using-sas-functions/" title="http://blogs.sas.com/content/sgf/2015/01/27/how-to-perform-a-fuzzy-match-using-sas-functions/">http://blogs.sas.com/content/sgf/2015/01/27/how-to-perform-a-fuzzy-match-using-sas-functions/</A></P><P></P><P>Or if simple is o.k., you could use for example the compress function to remove dashes, etc. and compare afterwards.</P></BODY></HTML> Thu, 11 Jun 2015 11:20:22 GMT https://communities.sas.com/t5/SAS-Data-Science/How-to-do-a-fuzzy-comparison-of-texts/m-p/203254#M9459 user24feb 2015-06-11T11:20:22Z Re: How to do a fuzzy comparison of texts? https://communities.sas.com/t5/SAS-Data-Science/How-to-do-a-fuzzy-comparison-of-texts/m-p/203255#M9460 <HTML><HEAD></HEAD><BODY><P>Thank you very much for your helpful answer!</P></BODY></HTML> Thu, 11 Jun 2015 11:58:59 GMT https://communities.sas.com/t5/SAS-Data-Science/How-to-do-a-fuzzy-comparison-of-texts/m-p/203255#M9460 badikidiki 2015-06-11T11:58:59Z