Hi, I am struggling with a particular join that I hope has a solution in SAS. I have 2 tables as follows: Reference table 1: CityRef: NewYork London Paris Brussels Canberra Raw extracted table 2: CityRaw: oshNewYorkd whatevrLondon Parisowjshg Brssuls I would like the following right join to be returned: CityRaw | CityRef oshNewYorkd | NewYork whatevrLondon | London Parisowjshg | Paris Brssuls | - So I would like to join these two tables together if the key from table 1 can be found within the key from table 2. I hope this makes sense. Perhaps proc sql is the answer? Any help would be greatly appreciated and would save me writing a complex iterative find macro in VBA! I am using EG 9.3. Rob
... View more