Overview of FedSQL Functions

A FedSQL function performs a computation on FedSQL expressions and returns either a single value or a set of values if the FedSQL expression is a column. Functions that perform a computation on a column are aggregate functions. In other SQL environments, aggregate functions are also known as set functions.
FedSQL functions can be used in FedSQL applications or in DS2 programs where embedded FedSQL is part of a DS2 application.
For more information, see FedSQL Expressions and the SET Statement in SAS DS2 Language Reference.
Note: For the FedSQL functions that are like-named in Base SAS, these functions can take DOUBLE and character arguments and return values, but all character return values are NVARCHAR.