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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: