FedSQL Functions

Overview of FedSQL Functions
General Function Syntax
Using FedSQL Functions
Aggregate Functions
Function Categories
SAS Output Delivery System and FedSQL
FEDSQL Functions by Category

ABCDEFGHIJKLMNOPQRSTUVWY

ABS Function
ARCOS Function
ARSIN Function
ATAN Function
ATAN2 Function
AVG Function
BAND Function
BETA Function
BETAINV Function
BLACKCLPRC Function
BLACKPTPRC Function
BLKSHCLPRC Function
BLKSHPTPRC Function
BLSHIFT Function
BOR Function
BRSHIFT Function
BXOR Function
BYTE Function
CAST Function
CEIL Function
CEILZ Function
CHARACTER_LENGTH Function
COALESCE Function
COALESCEC Function
COMPOUND Function
COMPRESS 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
DATDIF Function
DATE Function
DATEJUL Function
DATEPART Function
DATETIME Function
DAY Function
DEGREES Function
DHMS Function
DIGAMMA Function
E Function
ERF Function
ERFC Function
EXP Function
FLOOR Function
FLOORZ Function
FUZZ Function
GAMINV Function
GAMMA Function
GCD Function
GEOMEAN Function
GEOMEANZ Function
HARMEAN Function
HARMEANZ Function
HMS Function
HOUR Function
IFNULL Function
INDEX Function
INDEXC Function
INTCK Function
INTNX Function
INTRR Function
IQR Function
IRR Function
JULDATE Function
JULDATE7 Function
KURTOSIS Function
LARGEST Function
LCM Function
LGAMMA 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
MDY Function
MEAN Function
MEDIAN Function
MIN Function
MINUTE Function
MOD Function
MONTH Function
MORT Function
N Function
NETPV Function
NMISS Function
NPV Function
OCTET_LENGTH Function
ORDINAL Function
PCTL Function
PI Function
POISSON Function
POWER Function
PROBBETA Function
PROBBNML Function
PROBBNRM Function
PROBCHI Function
PROBF Function
PROBGAM Function
PROBHYPR Function
PROBIT Function
PROBNEGB Function
PROBNORM Function
PROBT Function
PUT Function
QTR Function
QUOTE Function
RADIANS Function
RANGE Function
RANK Function
REPEAT Function
REVERSE Function
RMS Function
ROUND Function
SAVINGS Function
SCAN 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
TINV Function
TODAY Function
TRIM Function
TRUNC Function
UPCASE Function
USS Function
VAR Function
VARIANCE Function
VERIFY Function
WEEK Function
WEEKDAY Function
YEAR Function
YYQ Function
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: February 23, 2017