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?
Since DI Studio is involved, I moved this post to the Data Management forum.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.