data1 data2 都是3030行，其中abcd是一样的，，
想把new 加到data2里面去
proc sql noprint;
select data2.* , data1.new
from data2 as s2 ,data1 as s1
where s2.a=s1.a and s2.b=s1.b and s2.c=s1.c
order by a
;
quit;
少了d，可以去重，distinct。
proc sql noprint;
select distinct data2.* , data1.new
from data2 as s2 ,data1 as s1
where s2.a=s1.a and s2.b=s1.b and s2.c=s1.c and s2.d=s1.d
order by a
;
quit;
扫码加好友，拉您进群
全部版块
我的主页
收藏
