Hi all, i'm trying to match two different firm names using COMPGED (maybe SPECID, SOUNDEX can be used as alternative method) but before that, I am thinking of making firm names similar as possible, by removing abbreviations at the end (e.g: CO LTD, PTE LTD, Limited, INC, Incorporated, AG, SpA, Corp) simplest way would be using the function TRANWRD, but i'm afraid this would replace not only abbreviations but letters that are part of the firm names. (say, if I was trying to remove 'Corp' at the end of firm names but by using TRANWRD i made 'Corpastta SpA' to 'astta SpA') Thus, what is the best way to do this and has anyone done the same work as me? maybe I should use reg expression?
... View more