Hello I tried to do this stuff on SAS but without much success so ... And of course i am a total newbie to VBA ... Here is my problem : I need to merge 2 datasets without any common identifier except the name of the company Of course in both datasets the names can be writtent differently, misspelled and so on ... Manually, i was copy/pasting each name from dataset 1 (less than 1800 names) and searching (Find All option after ctrl+f) for any of the occurrences for that name in dataset 2 (500.000 names) Then, manually I was looking into the results of the search if a name in dataset 2 was close to the name from dataset 1 i was looking for for instance COMPANY SA = SA COMPANY but in dataset 1 SA is at the end of the name and in dataset 2 it is at the beginning or FIRM SPA = FIRM Societa per actioni but in dataset 1 it is SPA and in dataset 2 it is Societa ... In SAS, there is a commande that calculates a "score" for the distance between 2 strings ... So you can use that command to calculate such scores and let say ask SAS to make 3 propositions of names that fit best the basic name you want to match The problem is that all this procedure implies transposing datasets and SAS cannot go beyond 32000 variables (or columns)
Then I thought that maybe such trick (the one I do manually in Excel) could be done automatically using a clever VBA macro ... I would appreciate any kind of help Thanks in advance Best CG --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
