How to fuzzy match by firm names - SAS Support Communities

Fluorite | Level 6

Fluorite | Level 6

How to fuzzy match by firm names

Posted 05-07-2021 09:43 PM (1982 views)

How can I fuzzy match two datasets by firm names? I'd like to find multiple similar names as long as the names are similar.

3 REPLIES 3

Lapis Lazuli | Level 10

Lapis Lazuli | Level 10

Re: How to fuzzy match by firm names

Posted 05-07-2021 11:55 PM (1958 views) | In reply to latte747

@latte747 Can you post sample input data and required output?

Tourmaline | Level 20

Tourmaline | Level 20

Re: How to fuzzy match by firm names

Posted 05-08-2021 09:58 AM (1933 views) | In reply to latte747

There are several ways to do this.

Post sample data if you want a usable code answer.

The DATA to DATA Step Macro
Blog: SASnrd

Super User

Super User

Re: How to fuzzy match by firm names

Posted 05-08-2021 11:01 PM (1909 views) | In reply to latte747

https://communities.sas.com/t5/SAS-Procedures/Name-matching/td-p/82780

April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!