SAS/ACCESS Interface to Hadoop passes the following
SAS functions to Hadoop for processing. Where the Hadoop function
name differs from the SAS function name, the Hadoop name appears in
parentheses.
For more information,
see Passing Functions to the DBMS Using PROC SQL.
| ABS |
MAX |
| ARCOS (ACOS) |
MIN |
| ARSIN (ASIN) |
MINUTE |
| ATAN |
MONTH |
| AVG |
SECOND |
| CEIL |
SIN |
| COALESCE |
SQRT |
| COS |
STD (STDDEV_SAMP) |
| COUNT |
STRIP (TRIM) |
| DAY |
SUBSTR |
| EXP |
SUM |
| FLOOR |
TAN |
| HOUR |
TRANSTRN (REGEXP_REPLACE) |
| INDEX (LOCATE) |
TRIMN (RTRIM) |
| LENGTH |
UPCASE (UPPER) |
| LOG (LN) |
VAR (VAR_SAMP) |
| LOG10 |
YEAR |
| LOWCASE (LOWER) |
SQL_FUNCTIONS=ALL allows for SAS functions that have slightly different behavior
from corresponding Hadoop functions. Due to incompatibility in date
and time functions between Hadoop and SAS, Hadoop might not process
them identically. Check your results to determine whether these functions
are working as expected.
SeeSQL_FUNCTIONS= LIBNAME Option.
| COMPRESS (REGEXP_REPLACE) |
DATETIME (FROM_UNIXTIME(UNIX_TIMESTAMP)) |
| DATE (TO_DATE(UNIX_TIMESTAMP)) |
REPEAT |
| DATEPART (TO_DATE(UNIX_TIMESTAMP)) |
TODAY (TO_DATE(UNIX_TIMESTAMP) |