Please post example data in a usable form (see my footnotes), and what you expect out of it. Assist us in helping you.
You have to provide sample data that's reflective of your data.
If this turns out to be a fuzzy match it's more difficult because of computational requirements, if you have 5 names you have to check against 5 names that becomes 25 comparisons. Now if that's 10,000 vs 5000 it becomes 50,000,000 comparisons which is significantly higher.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.