Thank you!! For Example, if data present in any of the cond1,cond2,cond3,cond4 tables and key column is fcl_id,cus_id,app_id. Then need to provide flag as Y else N. proc sql; connect to Teradata as db(user=xxx pwd='xxx'); create table cond as select * from connection to db( select distinct a.*,b.*,c.*,d.*, case when fcl_id^=. or cus_id ^=. or app_id^=. then 'Y' else 'N' end as condition from cond1 as a left join cond2 as b on a.fcl_id=b.fcl_id and a.cust_id=b.cust_id and a.app_id=b.app_id left join cond3 as c on a.fcl_id=c.fcl_id and a.cust_id=c.cust_id and a.app_id=c.app_id left join cond4 as d on a.fcl_id=c.fcl_id and a.cust_id=c.cust_id and a.app_id=c.app_id ); disconnect from db; quit; But it doesn't work. Kindly suggest the best method to accomplish.
... View more