A SAS/ACCESS connection uses PROC SQL with a pass-through query to execute native Oracle SQL. Which statement correctly implements an explicit SQL pass-through query to Oracle?
Select an answer to reveal the explanation.
Short Explanation and Infographic
Here's the deal — a is correct because the SAS SQL pass-through facility uses CONNECT TO <dbms> to establish the connection, then uses SELECT * FROM CONNECTION TO <dbms> (...) to execute native DBMS SQL and return results to SAS, and DISCONNECT FROM <dbms> to close the connection. B is wrong; EXECUTE is used for non-SELECT statements (like UPDATE).
Full explanation below image
Full Explanation
A is correct because the SAS SQL pass-through facility uses CONNECT TO <dbms> to establish the connection, then uses SELECT * FROM CONNECTION TO <dbms> (...) to execute native DBMS SQL and return results to SAS, and DISCONNECT FROM <dbms> to close the connection. B is wrong; EXECUTE is used for non-SELECT statements (like UPDATE). C and D use invalid SAS SQL syntax.