A SAS/ACCESS connection uses PROC SQL with a pass-through query to…

Question

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?

Accepted Answer

PROC SQL; CONNECT TO oracle (user=&user orapw=&pw); CREATE TABLE work.result AS SELECT FROM CONNECTION TO oracle (SELECT id, score FROM riskmodel WHERE score > 0.7); DISCONNECT FROM oracle; QUIT; — Here's the deal — you use CONNECT TO Oracle to open the connection, SELECT FROM CONNECTION TO Oracle (...) to run native Oracle SQL and bring results back, then DISCONNECT FROM Oracle to close it. The EXECUTE ... AT Oracle form is for non-SELECT commands like UPDATE, not for returning rows.

Answer

PROC SQL; EXECUTE (SELECT id, score FROM riskmodel WHERE score > 0.7) AT oracle; QUIT;

Answer

PROC SQL; PASSTHROUGH oracle; SELECT id, score FROM riskmodel WHERE score > 0.7; ENDPASSTHROUGH; QUIT;

Answer

PROC SQL; ORACLE DIRECT: SELECT id, score FROM riskmodel WHERE score > 0.7; QUIT;

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?

Short Explanation

Full Explanation