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.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.
Ready to level-up your skills? Choose your own adventure.