SAS/ACCESS Interface to Oracle passes the following
SAS functions to Oracle for processing. Where the Oracle function
name differs from the SAS function name, the Oracle name appears in
parentheses. For more information, see
Passing Functions to the DBMS Using PROC SQL.
| ABS |
LOG10 |
| ARCOS (ACOS) |
LOG2 |
| ARSIN (ASIN) |
LOWCASE (LCASE) |
| ATAN |
MAX |
| AVG |
MIN |
| CEIL |
SIGN |
| COS |
SIN |
| COSH |
SINH |
| COUNT |
SOUNDEX |
| DATEPART |
SQRT |
| DATETIME (SYSDATE) |
STRIP (TRIM) |
| DTEXTDAY |
SUM |
| DTEXTMONTH |
TAN |
| DTEXTYEAR |
TRANSLATE |
| EXP |
TRIMN (RTRIM) |
| FLOOR |
UPCASE (UPPER) |
| LOG |
When the Oracle server
is 9i or above, these additional functions are also passed.
| COALESCE |
MONTH (EXTRACT) |
| DAY (EXTRACT) |
YEAR (EXTRACT) |
SQL_FUNCTIONS=ALL allows for SAS functions that have slightly different
behavior from corresponding database functions that are passed down
to the database. Only when SQL_FUNCTIONS=ALL can the
SAS/ACCESS engine
also pass these SAS SQL functions to Oracle. Due to incompatibility
in date and time functions between Oracle and SAS, Oracle might not
process them correctly. Check your results to determine whether these
functions are working as expected. For more information, see
SQL_FUNCTIONS=
LIBNAME option .
| DATE (TRUNC(SYSDATE))* |
ROUND |
| DATEPART (TRUNC)* |
SUBSTR |
| INDEX (INSTR) |
TODAY (TRUNC(SYSDATE))* |
| LENGTH |
TRANWRD (REPLACE) |
| MOD |
TRIM (TRIMN) |
*Only in WHERE or HAVING
clauses.