Language Reference


Mathematical Functions and Subroutines

ABS

returns the absolute value

AIRY

returns the Airy function

BETA

returns the value of the beta function.

COALESCE

returns the first non-missing value from a list of numeric arguments

COALESCEC

returns the first non-missing value from a list of character arguments

COMPFUZZ

returns the result of a fuzzy comparison of numeric values

CONSTANT

returns some machine and mathematical constants

CNONCT

returns the noncentrality parameter from a chi-squared distribution

DAIRY

returns the derivative of the Airy function

DEVIANCE

returns the deviance from a specified distribution

DIGAMMA

returns the DIGAMMA function

ERF

returns the normal error function

ERFC

returns the complementary normal error function

EXP

returns the exponential function

FNONCT

returns the noncentrality parameter of an F distribution

GAMMA

returns the gamma function

IBESSEL

returns a modified Bessel function

JBESSEL

returns a Bessel function

LOGBETA

returns the logarithm of the beta function

LGAMMA

returns the natural logarithm of the gamma function

LOG

returns the natural (base e) logarithm

LOG1PX

returns the log of 1 plus the argument

LOG2

returns the logarithm base 2

LOG10

returns the logarithm base 10

LOGISTIC

returns the logistic value of each argument

MOD

returns the remainder value

MSPLINT

returns the ordinate of a monotonicity-preserving interpolating spline

SIGN

returns the sign of a value

CALL SOFTMAX

returns the softmax value for each argument

SQRT

returns the square root of a value

TNONCT

returns the value of the noncentrality parameter from the
Student’s t distribution

TRIGAMMA

returns the value of the TRIGAMMA function