SAS/ACCESS Interface to Sybase IQ passes the following
SAS functions to Sybase IQ for processing. Where the Sybase IQ function
name differs from the SAS function name, the Sybase IQ name appears
in parentheses. For more information, see
Passing Functions to the DBMS Using PROC SQL.
| ABS |
MIN |
| ACOS (ACOS) |
MINUTE |
| ARSIN (ASIN) |
MOD |
| ATAN |
MONTH |
| AVG |
QTR (QUARTER) |
| BYTE (CHAR) |
REPEAT |
| CEIL |
SECOND |
| COALESCE |
SIGN |
| COS |
SIN |
| COUNT |
SQRT |
| DAY |
STRIP (TRIM) |
| EXP |
SUBSTR (SUBSTRING) |
| FLOOR |
SUM |
| HOUR |
TAN |
| INDEX (LOCATE) |
TRANWRD (REPLACE) |
| LOG |
TRIMN (RTRIM) |
| LOG10 |
UPCASE (UPPER) |
| LOWCASE (LOWER) |
WEEKDAY (DOW) |
| MAX |
YEAR |
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 Sybase IQ. Due to incompatibility in date and time functions
between Sybase IQ and SAS, Sybase IQ 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.
| COMPRESS (REPLACE) |
SOUNDEX |
| DATE (CURRENT_DATE) |
TIME (CURRENT_TIME) |
| DATEPART (DATE) |
TIMEPART (TIME) |
| DATETIME (CURRENT_TIMESTAMP) |
TODAY (CURRENT_DATE) |
| LENGTH (BYTE_LENGTH) |
TRIM |