SAS/ACCESS Interface to ODBC |
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 |
EXP |
SIGN |
ARCOS |
FLOOR |
SIN |
ARSIN |
LOG |
SQRT |
ATAN |
LOG10 |
STRIP |
AVG |
LOWCASE |
SUM |
CEIL |
MAX |
TAN |
COS |
MIN |
UPCASE |
COUNT |
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 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) |
LENGTH |
TIME
(CURTIME) |
COMPRESS
(REPLACE) |
MINUTE |
TIMEPART |
DATE (CURDATE) |
MONTH |
TODAY (CURDATE) |
DATEPART |
QTR
(QUARTER) |
TRIMN (RTRIM) |
DATETIME (NOW) |
REPEAT |
TRANWRD (REPLACE) |
DAY (DAYOFMONTH) |
SECOND |
WEEKDAY
(DAYOFWEEK) |
HOUR |
SOUNDEX |
YEAR |
INDEX
(LOCATE) |
SUBSTR (SUBSTRING) |
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.