The code i wrote is this Proc sql, Create table want1 as select b.&colnm.,b.&lkp1.b.&lkp2.,'Accept' as flag_&seq_no from dbn.&tblnm. b Inner join wrk.tbl2 a On b.&colnm.=a.&lkp1. ---result from these dataset means the records are updated Proc sql, Create table want2 as select b.&colnm.,b.&lkp1.b.&lkp2.,'Reject' as flag_&seq_no from dbn.&tblnm. b Inner join wrk.tbl2 a On b.&colnm.=a.&lkp2. ----------result from these dataset means the records are not yet updated And again I have 3rd table which i will call as final table where I have created flags 1 to flag 20 wherein if Want1 is 0 then flag_&seqno is updated with 'accept' and if want2 have 0 records my flag_&seqno is updated to 'Reject'..so basically i am checking conditions from 2 table and updating the third one Flag_&seqno is the macro variable created for table name. I hope i am able to explain it not.. PS_cant post the screenshot of sample data due to security constraints
... View more
