merge的话是not (ina and inb)
sql做full join的话类似
sql还可以做(union) except (intersect)

merge的话是not (ina and inb)
sql做full join的话类似
sql还可以做(union) except (intersect)

data a;
input id;
cards;
1
3
4
6
;
data b;
input id;
cards;
1
2
3
4
;
run;

/*solution1*/
data c;
merge a(in=a) b(in=b);
by id;
aa=a;bb=b;
run;
/*表c中如果aa和bb都等于1，就证明两张表中都有该数据，否则为相异数据*/

/*solution2*/
proc sql;
create table c as
select id from
(select id from a union select id from b) t
where t.id not in
(select id from a intersect select id from b);
quit;
/*(a∪b)-(a∩b)*/

select distinct

data a;
input id;
cards;
1
3
4
6
;
data b;
input id;
cards;
1
2
3
4
;
run;
proc sort data=a;by id ;run;
proc sort data=b;by id ;run;
data c;
merge a(in=a) b(in=b);
if a and b;
by subjid;
run;
data d;
merge a b;
by subjid;
x=1;
run;
data dd;
merge c d;
by id;
if x^=1;
run;