https://communities.sas.com/t5/SAS-Programming/duplicates/m-p/327204#M72972 <P>Duplicates are easy, close is not. The problem with close is that you literally need to compare each address to all other addresses to determine closenes.&nbsp;</P> <P>&nbsp;</P> <P>Cleaning addresses is not fun, but look at some papers on LexJansen.com for some methods to standardize the data.</P> Tue, 24 Jan 2017 22:00:01 GMT Reeza 2017-01-24T22:00:01Z https://communities.sas.com/t5/SAS-Programming/duplicates/m-p/327202#M72970 <P>Hi,</P><P>&nbsp;</P><P>we won't to flag records that have either duplicate names or names that are close (ie missing the JR or SR or MS vs MRS).</P><P>&nbsp;</P><P>we always want to do this for addresses.</P><P>&nbsp;</P><P>Thank You,</P><P>&nbsp;</P><P>Louise</P> Tue, 24 Jan 2017 21:57:50 GMT https://communities.sas.com/t5/SAS-Programming/duplicates/m-p/327202#M72970 lu2kaseff 2017-01-24T21:57:50Z https://communities.sas.com/t5/SAS-Programming/duplicates/m-p/327204#M72972 <P>Duplicates are easy, close is not. The problem with close is that you literally need to compare each address to all other addresses to determine closenes.&nbsp;</P> <P>&nbsp;</P> <P>Cleaning addresses is not fun, but look at some papers on LexJansen.com for some methods to standardize the data.</P> Tue, 24 Jan 2017 22:00:01 GMT https://communities.sas.com/t5/SAS-Programming/duplicates/m-p/327204#M72972 Reeza 2017-01-24T22:00:01Z https://communities.sas.com/t5/SAS-Programming/duplicates/m-p/327287#M72997 <P>If the task is critical, and you need to do this a lot, you might want to take look at SAS Data Management Studio.</P> Wed, 25 Jan 2017 08:40:34 GMT https://communities.sas.com/t5/SAS-Programming/duplicates/m-p/327287#M72997 LinusH 2017-01-25T08:40:34Z