stormhoof 发表于 2012-8-7 11:47
if index(x,”上海") ne 0 then x="上海",不知是否可以这样

binyehan 发表于 2012-8-7 13:18
明白你的意思，但是我们目标数据集的“上海”这个观测值，有将近一百来个（例如北京、天津、江苏、江西、 ...

ziyenano 发表于 2012-8-7 13:33
proc sql;
create table c as
select b.x,b.w,a.y,a.z from a inner join b on index(a.x,compress(b.x)) ...

ziyenano 发表于 2012-8-7 13:33
proc sql;
create table c as
select b.x,b.w,a.y,a.z from a inner join b on index(a.x,compress(b.x)) ...

ziyenano 发表于 2012-8-7 13:33
proc sql;
create table c as
select b.x,b.w,a.y,a.z from a inner join b on index(a.x,compress(b.x)) ...