SAS/ACCESS Interface to ODBC passes
the following SAS functions to the data source for processing if the
DBMS server supports this function. Where the ODBC function name differs
from the SAS SQL function name, the ODBC name appears in parentheses.
For more information,
see Passing Functions to the DBMS Using PROC SQL.
| ABS |
LOG10 |
| ARCOS |
LOWCASE |
| ARSIN |
MAX |
| ATAN |
MIN |
| AVG |
SIGN |
| CEIL |
SIN |
| COS |
SQRT |
| COUNT |
STRIP |
| EXP |
SUM |
| FLOOR |
TAN |
| LOG |
UPCASE |
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 ODBC. Due to incompatibility in date
and time functions between ODBC and SAS, ODBC might not process them
correctly. Check your results to determine whether these functions
are working as expected.
| BYTE (CHAR) |
REPEAT |
| COMPRESS (REPLACE) |
SECOND |
| DATE (CURDATE) |
SOUNDEX |
| DATEPART |
SUBSTR (SUBSTRING) |
| DATETIME (NOW) |
TIME (CURTIME) |
| DAY (DAYOFMONTH) |
TIMEPART |
| HOUR |
TODAY (CURDATE) |
| INDEX (LOCATE) |
TRIMN (RTRIM) |
| LENGTH |
TRANWRD (REPLACE) |
| MINUTE |
WEEKDAY (DAYOFWEEK) |
| MONTH |
YEAR |
| QTR (QUARTER) |