I'd suggest explicitly referencing each column name in the select instead of doing "select *" as if the schema changes, you could be hiding bugs by using "select *" ...

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 ...