A SERVICE OF

logo

128 SQL_FUNCTIONS= LIBNAME Option Chapter 9
EXP
FLOOR
LOG
LOG10
SIGN
SIN
SQRT
TAN
DATE
DATEPART
DATETIME
TIME
TIMEPART
TODAY
DAY
HOUR
MINUTE
MONTH
QRT
SECOND
WEEKDAY
YEAR
BYTE
COMPRESS
INDEX
LENGTH
REPEAT
SOUNDEX
SUBSTR
TRANWRD
TRIMN
MOD
Use of this option can cause unexpected results, especially if used for NULL
processing and date/time/timestamp handling. For example, the following SAS code
executed without SQL_FUNCTIONS= enabled returns the SAS date 15308:
proc sql;
select distinct DATE () from x.test;
quit;