Function Categories

Functions can be categorized by the types of values that they operate on. Each FedSQL function belongs to one of the following categories:
Aggregate
operates on the values in a table column
Bitwise Logical Operations
operates on one or more bit patterns or binary numbers at the level of their individual bits
Character
operates on character SQL expressions
Date and Time
operates on date and time SQL expressions
Descriptive Statistics
operates on values that measure central tendency, variation among values, and the shape of distribution values
Financial
calculates financial values such as interest, periodic payments, depreciation, and prices for European options on stocks.
Mathematical
operates on values to perform general mathematical calculations
Probability
returns probability calculations.
Special
operates on null values and SAS missing values
Trigonometric
operates on values to perform trigonometric calculations
Truncation
truncates numeric values and returns numeric values, often using fuzzing
Last updated: February 23, 2017