200 ORHINTS= Data Set Option Chapter 10
ORHINTS= Data Set Option
Specifies Oracle hints to pass to Oracle from a SAS statement or SQL procedure
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
DBMS support:
Oracle
Default value:
none
Syntax
ORHINTS =’Oracle-hint’
Syntax Description
Oracle-hint
specifies an Oracle hint for SAS/ACCESS to pass to the DBMS as part of an SQL
query.
Details
If you specify an Oracle hint, SAS passes the hint to Oracle. If you omit ORHINTS=,
SAS does not send any hints to Oracle.
Examples
In the following example, you run a SAS procedure on DBMS data and SAS converts
the procedure to one or more SQL queries. The ORHINTS= data set option enables you
to specify an Oracle hint for SAS to pass as part of the SQL query.
libname mydblib oracle user=testuser password=testpass path=’myorapath’;
proc print data=mydblib.payroll(orhints=
’/*+ ALL_ROWS */’);
run;
In the following example, SAS sends the Oracle hint ’/*+ ALL_ROWS */’ to Oracle
as part of the following statement:
SELECT /*+ ALL_ROWS */ * FROM PAYROLL
PRESERVE_COL_NAMES= Data Set Option
Preserves spaces, special characters, and case sensitivity in DBMS column names when you
create DBMS tables
Valid in: DATA and PROC steps (when creating DBMS tables using SAS/ACCESS
software).
