SAS/ACCESS Interface to
Aster
nCluster passes the following
SAS functions to Aster
nCluster
for processing. Where the Aster
nCluster
function name differs from the SAS function name, the Aster
nCluster
name appears in parentheses. For more information, see
Passing Functions to the DBMS Using PROC SQL.
| ABS |
MAX |
| ARCOS (ACOS) |
MIN |
| ARSIN (ASIN) |
MLOWCASE (lower)INUTE (date_part) |
| ATAN |
MOD |
| ATAN2 |
MONTH (date_part) |
| AVG |
QTR (date_part) |
| BYTE (chr) |
REPEAT |
| CEIL (ceiling) |
SIGN |
| COALESCE |
SIN |
| COS |
SQRT |
| COUNT |
STRIP (btrim) |
| DAY (date_part) |
SUBSTR (substring) |
| EXP |
SUM |
| FLOOR |
TAN |
| HOUR (date_part) |
TRANWRD (replace) |
| INDEX (strpos) |
TRIMN (rtrim) |
| LOG (ln) |
UPCASE (upper) |
| LOG10 (log) |
YEAR (date_part) |
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 Aster
nCluster.
Due to incompatibility in date and time functions between Aster
nCluster
and SAS, Aster
nCluster 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.