Dear,
You can try many ways to get it done...
As @dcruik Proc sql is good to use and we can use datastep as well for the same...
try below code ....
data A;
input X $ Y;
cards;
Apples 1
Oranges 3
Pears 3
;
run;
data b;
input X $ Y;
cards;
Apples 1
Watermellon 1
Oranges 3
Pears 3
Banana 2
;
run;
/*method 1*/
proc sql;
create table want as select * from b where x not in (select distinct x from a);
quit;
/*Method two */
Proc sort data=a; by x;run;
Proc sort data=b; by x;run;
data want;
merge a(in=_x) b(in=_y);
by x;
if _y and not _x;
run;
... View more