As mentioned in the above solution, use except with proc sql, and add union to concatenate the outcome. data test1; input pkey $ var1 var2 var3; datalines; a 1 2 3 b 4 5 5 ; run; data test2; input pkey $ var1 var2 var3; datalines; a 1 2 3 b 4 5 6 ; run; proc sql; (select * from test1 except select * from test2 ) union (select * from test2 except select * from test1) ; quit;
... View more