Hi guys, I'm trying to merge two data sets by ticker symbols, but ticker symbols are not unique to every company, they can be reused by other companies, so I also need to merge two data sets by company names, The problem is names for same company in different data sets may be different in formats (such as up or lower case, inc. or corp, with "-" or " " in two words), how could I solve this problem? Please have a look of below codes Kind regards, Songchan proc sql;
create table temp03 as
select distinct a.*, b.permno, b.comnam, b.ticker, b.date
from temp02 as a
left join temp01a as b
on a.ticker=b.ticker;
quit;
... View more
