I am facing problem while updating one table from another using key say (product_id). Actually UPDATE transformation has where clause but it is throwing error : something like correlated query . Could someone help me how to use correlated query in update transform in SAS DI Problem is like this Twol table product(prod_id , current_flag) and prod_update(prod_id , current_flag) update product a inner join prod_update b on (a.prod_id=b.prod_id) set a.current_flag=b.current_flag I want to Achive DI UPDATE transform .Could someone please help me?
... View more