Use an iterative approach, how many match identically. Remove those. How many match close with fuzzy logic, then remove those and keep going until you'r done. For SHELL, use SCAN() to get the first word and check on that part. See this post and FriedEgg's solution which is iterative.   https://communities.sas.com/t5/SAS-Procedures/Name-matching/td-p/82780 ... View more

Hi Suryakiran,   Oh wow, this looks like exactly what I need - the CASE function example. Awesome, thank you so much for your quick reply. I'm gonna try this over the weekend, as i'll be heading out soon. But will definitely keep you posted!!!!!!   Thanks again for your help and enjoy your weekend!   Kind regards,   esuhco ... View more