FedSQL Functions

Overview of FedSQL Functions
General Function Syntax
Using FedSQL Functions
Aggregate Functions
Function Categories
FEDSQL Functions by Category

ABCDEFGHIJKLMNOPQRSTUVWY

ABS Function
ACOS Function
ASIN Function
ATAN Function
ATAN2 Function
AVG Function
BAND Function
BETA Function
BLACKCLPRC Function
BLACKPTPRC Function
BLKSHCLPRC Function
BLKSHPTPRC Function
BLSHIFT Function
BOR Function
BRSHIFT Function
BXOR Function
CAST Function
CEIL Function
CEILZ Function
CHARACTER_LENGTH Function
COALESCE Function
COALESCEC Function
COS Function
COSH Function
COT Function
COUNT Function
CSS Function
CURRENT_DATE Function
CURRENT_LOCALE Function
CURRENT_TIME Function
CURRENT_TIME_GMT Function
CURRENT_TIMESTAMP Function
CURRENT_TIMESTAMP_GMT Function
CV Function
DATE Function
DATEJUL Function
DATEPART Function
DAY Function
DEGREES Function
E Function
EXP Function
FLOOR Function
FLOORZ Function
GAMMA Function
GCD Function
GEOMEAN Function
GEOMEANZ Function
HARMEAN Function
HARMEANZ Function
HOUR Function
IFNULL Function
IQR Function
JULDATE Function
JULDATE7 Function
LARGEST Function
KURTOSIS Function
LCM Function
LOG Function
LOG2 Function
LOG10 Function
LOGBETA Function
LOWCASE Function
MAD Function
MAKEDATE Function
MAKETIME Function
MAKETIMESTAMP Function
MARGRCLPRC Function
MARGRPTPRC Function
MAX Function
MEAN Function
MEDIAN Function
MIN Function
MINUTE Function
MOD Function
MONTH Function
NMISS Function
OCTET_LENGTH Function
ORDINAL Function
PCTL Function
PI Function
POWER Function
PROBBNML Function
PROBBNRM Function
PROBCHI Function
PROBT Function
PUT Function
QTR Function
QUOTE Function
RADIANS Function
RANGE Function
REPEAT Function
REVERSE Function
RMS Function
SECOND Function
SIGN Function
SIN Function
SINH Function
SKEWNESS Function
SMALLEST Function
SQRT Function
STD Function
STDDEV Function
STDERR Function
STUDENTS_T Function
SUBSTRING Function
SUM Function
TAN Function
TANH Function
TIMEPART Function
TODAY Function
TRIM Function
UPCASE Function
USS Function
VARIANCE Function
WEEKDAY Function
YEAR Function
YYQ Function
Copyright © SAS Institute Inc. All rights reserved.