proc import out=origin
datafile="E:\原始数据.xls"
replace;
run;
proc import out=keyword
datafile="E:\分类关键词目录.xls"
replace;
run;
proc sql;
create table res as
select a.*,b.key_word as kw from
origin a left join keyword b
on a.c=b.c and kindex(a.name,b.key_word) ne 0;
quit;