I have an Oracle table I would like to acces in SAS but using either the datastep or proc sql it returns the column headers but no rows of data. In SQL developer the same issue occurs, but I am able to resolve it by first running the SQL command below: begin apps.mo_global.set_policy_context('S',101); end; I have tried to run that exact SQL statement using the SQL pass-through facility as follows: proc sql; connect to oracle as ALIAS (user=username orapw=password path='path'); execute(begin apps.mo_global.set_policy_context('S',org#); end; ) by ALIAS; disconnect from ALIAS; quit; The issue is that whenever I run this I get an error that the table or view does not exist. I do not know if there the problem is with my proc sql or if there is other code that is the SAS equivalent of the SQL command above. I have tried it in both SAS 9.3 and Enterprise Guide 5.1. Any help would be greatly appreciated. Thank you.
... View more