Previous Page | Next Page

SAS/ACCESS Interface to OLE DB

Passing SAS Functions to OLE DB

SAS/ACCESS Interface to OLE DB passes the following SAS functions for OLE DB to DB2, Microsoft SQL Server, and Oracle for processing. Where the OLE DB function name differs from the SAS function name, the OLE DB name appears in parentheses. For more information, see Passing Functions to the DBMS Using PROC SQL.

DAY DTEXTWEEKDAY SECOND
DTEXTDAY HOUR WEEKDAY
DTEXTMONTH MINUTE YEAR
DTEXTYEAR MONTH

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 OLE DB. Due to incompatibility in date and time functions between OLE DB and SAS, OLE DB might not process them correctly. Check your results to determine whether these functions are working as expected.

ABS EXP SIN
ARCOS (ACOS) FLOOR SOUNDEX
ARSIN (ASIN) INDEX SQRT
ATAN LENGTH STRIP (TRIM)
AVG LOG SUBSTR
BYTE LOG10 SUM
CEIL LOWCASE TAN
COMPRESS MAX TIME
COS MIN TIMEPART
COUNT MOD TODAY
DATE QRT TRANWRD
DATEPART REPEAT TRIM
DATETIME SIGN UPCASE

Previous Page | Next Page | Top of Page