SAS/ACCESS Interface to OLE DB passes the following
SAS functions for OLE DB to DB2, Microsoft SQL Server, and Oracle
for processing. Where the OLE DB function name differs from the SAS
function name, the OLE DB name appears in parentheses.
For more information,
see Passing Functions to the DBMS Using PROC SQL.
| DAY |
MINUTE |
| DTEXTDAY |
MONTH |
| DTEXTMONTH |
SECOND |
| DTEXTYEAR |
WEEKDAY |
| DTEXTWEEKDAY |
YEAR |
| HOUR |
SQL_FUNCTIONS=ALL
allows for SAS functions that have slightly different behavior from
corresponding database functions that are passed down to the database.
(See SQL_FUNCTIONS=.) Only when SQL_FUNCTIONS=ALL can the
SAS/ACCESS engine also
pass these SAS SQL functions to OLE DB. Due to incompatibility in
date and time functions between OLE DB and SAS, OLE DB might not process
them correctly. Check your results to determine whether these functions
are working as expected.
| ABS |
MAX |
| ARCOS (ACOS) |
MIN |
| ARSIN (ASIN) |
MOD |
| ATAN |
QRT |
| AVG |
REPEAT |
| BYTE |
SIGN |
| CEIL |
SIN |
| COMPRESS |
SOUNDEX |
| COS |
SQRT |
| COUNT |
STRIP (TRIM) |
| DATE |
SUBSTR |
| DATEPART |
SUM |
| DATETIME |
TAN |
| EXP |
TIME |
| FLOOR |
TIMEPART |
| INDEX |
TODAY |
| LENGTH |
TRANWRD |
| LOG |
TRIM |
| LOG10 |
UPCASE |
| LOWCASE |