hi, I would like to join table A with Table B on three different columns and any matching records from Table B should be deleted in table A. In the below code I've written the records in data set NEW should be removed from Cons3. how can i do it? proc sql; create table home as select a.tlnbr, b.home, b.busi, b.alt, b.ACCT_ID from acct_dtl as a inner join cons3 as b on a.tlnbr = b.home; quit; proc sql; create table busi as select a.tlnbr, b.home, b.busi, b.alt, b.ACCT_ID from acct_dtl as a inner join cons3 as b on a.tlnbr = b.busi; quit; proc sql; create table alt as select a.tlnbr, b.home, b.busi, b.alt, b.ACCT_ID from acct_dtl as a inner join cons3 as b on a.tlnbr = b.alt; quit; data new; set home busi alt; run;
... View more