An SQL statement looks something like this: " select customer_name, ship_date from orders where product_id=17 and state='CA'." There are two things to notice here.

The PROC SQL SELECT statement uses a CONNECTION TO component in the FROM clause to retrieve data from the ORACLE table. The Pass-Through query (in italics) is enclosed in parentheses and uses ORACLE ...