data a;
input a b c $;
format a z4.;
cards;
0001 1.4 啊
0002 1.4 吧
0002 1.5 才
0002 1.6 的
0003 1.5 额
;
data b;
input a b d $;
format a z4.;
cards;
0001 1.4 飞
0002 1.4 个
0003 1.5 好
0003 1.5 额
0003 1.6 了
;
run;
proc sql;
create table c as
select *
from a inner join b
on a.a=b.a and a.b=b.b and a.c^=b.d
;
quit;