BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
badikidiki
Fluorite | Level 6

Hello,

what we want to do is to find multiple persones in our dataset.

We do have names and addresses of these persons.

The problem is that there are different ways in spelling names of persons or streets - e.g. with "-" or without / "n" or "nn".

Is there any possibility in SAS to do a "fuzzy" comparison of alphanumeric variables?

Something like "most" (90%, 95%) of two strings is identical ?

Thanks!

badikidiki 

1 ACCEPTED SOLUTION

Accepted Solutions
user24feb
Barite | Level 11

You could look here: http://blogs.sas.com/content/sgf/2015/01/27/how-to-perform-a-fuzzy-match-using-sas-functions/

Or if simple is o.k., you could use for example the compress function to remove dashes, etc. and compare afterwards.

View solution in original post

2 REPLIES 2
user24feb
Barite | Level 11

You could look here: http://blogs.sas.com/content/sgf/2015/01/27/how-to-perform-a-fuzzy-match-using-sas-functions/

Or if simple is o.k., you could use for example the compress function to remove dashes, etc. and compare afterwards.

badikidiki
Fluorite | Level 6

Thank you very much for your helpful answer!

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to choose a machine learning algorithm

Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1040 views
  • 0 likes
  • 2 in conversation