Hi, Use this methodology: data a; input accnum amount; datalines; 12345678 4.50 12345679 5.50 12345680 6.50 ; run; data b; input plcynum custn amount; datalines; 12345678 98765432 4.50 12345679 98765431 5.50 12345681 98765432 9.50 ; run; proc sql; create table aa as select * from a,b where a.accnum=b.plcynum or a.accnum=b.custn and a.amount=b.amount; quit; proc print data=aa; run; Output:
... View more