Can anyone please help me on this
1. when we are using SQL pass through facility can we create a view or update a table directly in the database we are connecting to if so Can you plz help me on that.
2. Consider a situation where i have created a permenant SAS dataset using SQL pass through facility and then next time i need to update the same dataset with new columns and data flowing from the query of tera data
can i write as
(select * -query)
thanks in advance