Functions

SPD Server supports the use of SAS functions in the DATA step and SAS procedures. Most functions also work in SQL pass-through statements. See SAS Functions and CALL Routines: Reference for information about the functions.
Note that DATE, INT, LEFT, RIGHT, LENGTH, and TRIM are reserved keywords. Therefore, they must be preceded by a backslash in server SQL queries:
 select \date() from t
Last updated: February 8, 2017