4# 天堂之路
写了个繁琐的,你看一下,行不行
data a;
input x y@@;
cards;
1 2 2 3 3 3 4 5 76 8 6 5 4 7 9 6
;
run;
data b;
input x z@@;
cards;
1 5 3 6 7 7 8 9 4 7 5 7
;
run;
proc sql;
create table a_ls as
select * from a
where x in ( select x from b);
delete from a
where x in (select x from a_ls);
quit;