topic Matching Name & Addresses in SAS Data Science https://communities.sas.com/t5/SAS-Data-Science/Matching-Name-Addresses/m-p/172217#M9398 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I am hoping that someone out there has already solved this and can share some handy code.</P><P>I have two separate datasets that contain client information listing Name, Address, City, State and Zip code.&nbsp; data1 is supplied by an external vendor while data2 is our internal records so they are not entered exactly the same way.&nbsp; I need some ideas on best way to use SAS to process both files and find matches for same customer between the two files even if the name or address information is not entered as identical between the 2 files.&nbsp; I use base SAS v9.4 in Windows environment.</P><P>Thanks, in advance, for any insight!</P></BODY></HTML> Wed, 12 Feb 2014 19:43:59 GMT gwcanalytics 2014-02-12T19:43:59Z Matching Name & Addresses https://communities.sas.com/t5/SAS-Data-Science/Matching-Name-Addresses/m-p/172217#M9398 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I am hoping that someone out there has already solved this and can share some handy code.</P><P>I have two separate datasets that contain client information listing Name, Address, City, State and Zip code.&nbsp; data1 is supplied by an external vendor while data2 is our internal records so they are not entered exactly the same way.&nbsp; I need some ideas on best way to use SAS to process both files and find matches for same customer between the two files even if the name or address information is not entered as identical between the 2 files.&nbsp; I use base SAS v9.4 in Windows environment.</P><P>Thanks, in advance, for any insight!</P></BODY></HTML> Wed, 12 Feb 2014 19:43:59 GMT https://communities.sas.com/t5/SAS-Data-Science/Matching-Name-Addresses/m-p/172217#M9398 gwcanalytics 2014-02-12T19:43:59Z Re: Matching Name & Addresses https://communities.sas.com/t5/SAS-Data-Science/Matching-Name-Addresses/m-p/172218#M9399 <HTML><HEAD></HEAD><BODY><P>There isn't an exact way, but you look at some fuzzy matching options. Some functions to look into are:</P><P></P><P>COMPGED</P><P>COMPLEV</P><P>SOUNDS LIKE</P><P>SOUNDEX</P><P>SPEDIS</P><P></P><P>There's a post I like on here that goes through several iterations to find a match, by FriedEgg.</P><P></P><P><A __default_attr="133974" __jive_macro_name="message" class="jive_macro jive_macro_message" href="https://communities.sas.com/"></A></P></BODY></HTML> Wed, 12 Feb 2014 20:20:58 GMT https://communities.sas.com/t5/SAS-Data-Science/Matching-Name-Addresses/m-p/172218#M9399 Reeza 2014-02-12T20:20:58Z Re: Matching Name & Addresses https://communities.sas.com/t5/SAS-Data-Science/Matching-Name-Addresses/m-p/172219#M9400 <HTML><HEAD></HEAD><BODY><P>Hello Reeza,</P><P>Thank you very much for sharing the post from FriedEgg.&nbsp; It was exactly what I needed!</P></BODY></HTML> Thu, 13 Feb 2014 14:17:49 GMT https://communities.sas.com/t5/SAS-Data-Science/Matching-Name-Addresses/m-p/172219#M9400 gwcanalytics 2014-02-13T14:17:49Z