| Category | Language Elements | Description |
|---|---|---|
| Aggregate | AVG Function | Returns the average of all values in a column. |
| COUNT Function | Returns the number of rows retrieved by a SELECT statement for a specified table. | |
| CSS Function | Returns the corrected sum of squares of all values in an expression. | |
| KURTOSIS Function | Returns the kurtosis of all values in an expression. | |
| MAX Function | Returns the maximum value in a column. | |
| MIN Function | Returns the minimum value in an expression. | |
| NMISS Function | Returns the number of null values or SAS missing values in an expression. | |
| PROBT Function | Returns the probability from a t distribution of the values in an expression. | |
| RANGE Function | Returns the range between values in an expression. | |
| SKEWNESS Function | Returns the skewness of all values in an expression. | |
| STD Function | Returns the standard deviation. | |
| STDDEV Function | Returns the statistical standard deviation of all values in an expression. | |
| STDERR Function | Returns the statistical standard error of all values in an expression. | |
| STUDENTS_T Function | Returns the Student's t distribution of the values in an expression. | |
| SUM Function | Returns the sum of all the values in an expression. | |
| USS Function | Returns the uncorrected sum of squares of all the values in an expression. | |
| VARIANCE Function | Returns the measure of the dispersion of all values in an expression. | |
| Arithmetic | ERF Function | Returns the value of the (normal) error function. |
| ERFC Function | Returns the value of the complementary (normal) error function. | |
| Bitwise Logical Operations | BAND Function | Returns the bitwise logical AND of two arguments. |
| BLSHIFT Function | Returns the bitwise logical left shift of two arguments. | |
| BOR Function | Returns the bitwise logical OR of two arguments. | |
| BRSHIFT Function | Returns the bitwise logical right shift of two arguments. | |
| BXOR Function | Returns the bitwise logical EXCLUSIVE OR of two arguments. | |
| Character | BYTE Function | Returns one character in the ASCII or the EBCDIC collating sequence. |
| CHARACTER_LENGTH Function | Returns the number of characters in a string of any data type. | |
| COALESCEC Function | Returns the first non-null or nonmissing value from a list of character arguments. | |
| COMPRESS Function | Returns a character string with specified characters removed from the original string. | |
| CURRENT_LOCALE Function | Returns the five character name of the current locale. | |
| INDEX Function | Searches a character expression for a string of characters, and returns the position of the string's first character for the first occurrence of the string. | |
| INDEXC Function | Searches a character expression for specified characters and returns the position of the first occurrence of any of the characters. | |
| LOWCASE Function | Converts all letters in a character expression to lowercase. | |
| OCTET_LENGTH Function | Returns the number of bytes in a string of any data type. | |
| QUOTE Function | Adds double quotation marks to a character value. | |
| RANK Function | Returns the position of a character in the ASCII or EBCDIC collating sequence. | |
| REPEAT Function | Repeats a character expression. | |
| REVERSE Function | Reverses a character expression. | |
| SCAN Function | Returns the nth word from a character expression. | |
| SUBSTRING Function | Extracts a substring from a character string. | |
| TRIM Function | Removes leading characters, trailing characters, or both from a character string. | |
| UPCASE Function | Converts all letters in an argument to uppercase. | |
| VERIFY Function | Returns the position of the first character that is unique to an expression. | |
| Date and Time | CURRENT_DATE Function | Returns the current date for the time zone. |
| CURRENT_TIME Function | Returns the current time for your time zone. | |
| CURRENT_TIME_GMT Function | Returns the current GMT time. | |
| CURRENT_TIMESTAMP Function | Returns the date and time for your time zone. | |
| CURRENT_TIMESTAMP_GMT Function | Returns the current GMT date and time. | |
| DATDIF Function | Returns the number of days between two dates after computing the difference between the dates according to specified day count conventions. | |
| DATE Function | Returns the current date as a SAS date value. | |
| DATEJUL Function | Converts a Julian date to a SAS date value. | |
| DATEPART Function | Returns the date as year, month, and day. | |
| DATETIME Function | Returns the current date and time of day as a SAS datetime value. | |
| DAY Function | Returns the numeric day of the month from a date or datetime value. | |
| DHMS Function | Returns a SAS datetime value from date, hour, minute, and second values. | |
| HMS Function | Returns a SAS time value from hour, minute, and second values. | |
| HOUR Function | Returns the hour from a time or datetime value. | |
| INTCK Function | Returns the number of interval boundaries of a given kind that lie between two SAS dates, times, or timestamp values encoded as DOUBLE. | |
| INTNX Function | Increments a SAS date, time, or datetime value encoded as a DOUBLE, and returns a SAS date, time, or datetime value encoded as a DOUBLE. | |
| JULDATE Function | Returns the Julian date from a SAS date value. | |
| JULDATE7 Function | Returns a seven-digit Julian date from a SAS date value. | |
| MAKEDATE Function | Returns the date as year, month, and day. | |
| MAKETIME Function | Returns the time as hours, minutes, and seconds. | |
| MAKETIMESTAMP Function | Returns the timestamp. | |
| MDY Function | Returns a SAS date value from month, day, and year values. | |
| MINUTE Function | Returns the minute from a time or datetime value. | |
| MONTH Function | Returns the numeric month from a date or datetime value. | |
| QTR Function | Returns the quarter of the year from a SAS date value. | |
| SECOND Function | Returns the second from a time or datetime value. | |
| TIMEPART Function | Returns the time as hours, minutes, and seconds. | |
| TODAY Function | Returns the current date as a numeric SAS date value. | |
| WEEK Function | Returns the week-number value. | |
| WEEKDAY Function | From a SAS date value, returns an integer that corresponds to the day of the week. | |
| YEAR Function | Returns the year from a date or datetime value. | |
| YYQ Function | Returns a SAS date value from year and quarter year values. | |
| Descriptive Statistics | AVG Function | Returns the average of all values in a column. |
| CSS Function | Returns the corrected sum of squares of all values in an expression. | |
| CV Function | Returns the coefficient of variation. | |
| GEOMEAN Function | Returns the geometric mean. | |
| GEOMEANZ Function | Returns the geometric mean, using zero fuzzing. | |
| HARMEAN Function | Returns the harmonic mean. | |
| HARMEANZ Function | Returns the harmonic mean, using zero fuzzing. | |
| IQR Function | Returns the interquartile range. | |
| KURTOSIS Function | Returns the kurtosis of all values in an expression. | |
| LARGEST Function | Returns the kth largest non-null or nonmissing value. | |
| MAD Function | Returns the median absolute deviation from the median. | |
| MAX Function | Returns the maximum value in a column. | |
| MEAN Function | Returns the arithmetic mean (average) of the non-null or nonmissing arguments. | |
| MEDIAN Function | Returns the median value. | |
| MIN Function | Returns the minimum value in an expression. | |
| N Function | Returns the number of non-null or nonmissing numeric values. | |
| ORDINAL Function | Orders a list of values, and returns a value that is based on a position in the list. | |
| PCTL Function | Returns the percentile that corresponds to the percentage. | |
| PROBT Function | Returns the probability from a t distribution of the values in an expression. | |
| RANGE Function | Returns the range between values in an expression. | |
| RMS Function | Returns the root mean square. | |
| SKEWNESS Function | Returns the skewness of all values in an expression. | |
| SMALLEST Function | Returns the kth smallest non-null or nonmissing value. | |
| STD Function | Returns the standard deviation. | |
| STDDEV Function | Returns the statistical standard deviation of all values in an expression. | |
| STDERR Function | Returns the statistical standard error of all values in an expression. | |
| STUDENTS_T Function | Returns the Student's t distribution of the values in an expression. | |
| SUM Function | Returns the sum of all the values in an expression. | |
| USS Function | Returns the uncorrected sum of squares of all the values in an expression. | |
| VAR Function | Returns the variance. | |
| VARIANCE Function | Returns the measure of the dispersion of all values in an expression. | |
| Financial | BLACKCLPRC Function | Calculates call prices for European options on futures, based on the Black model. |
| BLACKPTPRC Function | Calculates put prices for European options on futures, based on the Black model. | |
| BLKSHCLPRC Function | Calculates call prices for European options on stocks, based on the Black-Scholes model. | |
| BLKSHPTPRC Function | Calculates put prices for European options on stocks, based on the Black-Scholes model. | |
| COMPOUND Function | Returns compound interest parameters. | |
| INTRR Function | Returns the internal rate of return as a decimal value. | |
| IRR Function | Returns the internal rate of return as a percentage. | |
| MARGRCLPRC Function | Calculates call prices for European options on stocks, based on the Margrabe model. | |
| MARGRPTPRC Function | Calculates put prices for European options on stocks, based on the Margrabe model. | |
| MORT Function | Returns amortization parameters. | |
| NETPV Function | Returns the net present value as a percent. | |
| NPV Function | Returns the net present value with the rate expressed as a percentage. | |
| SAVINGS Function | Returns the balance of a periodic savings by using variable interest rates. | |
| Mathematical | ABS Function | Returns the absolute value of a numeric value expression. |
| BETA Function | Returns the value of the beta function. | |
| COALESCE Function | Returns the first non-null or nonmissing value from a list of numeric arguments. | |
| DIGAMMA Function | Returns the value of the digamma function. | |
| E Function | Returns the natural logarithm, e. | |
| ERF Function | Returns the value of the (normal) error function. | |
| ERFC Function | Returns the value of the complementary (normal) error function. | |
| EXP Function | Returns the value of the e constant raised to a specified power. | |
| GAMMA Function | Returns the value of the gamma function. | |
| GCD Function | Returns the greatest common divisor for a set of integers. | |
| LCM Function | Returns the least common multiple for a set of integers. | |
| LGAMMA Function | Returns the natural logarithm of the Gamma function. | |
| LOG Function | Returns the natural logarithm (base e) of a numeric value expression. | |
| LOG2 Function | Returns the base-2 logarithm of a numeric value expression. | |
| LOG10 Function | Returns the base-10 logarithm of a numeric value expression. | |
| LOGBETA Function | Returns the logarithm of the beta function. | |
| MOD Function | Returns the remainder from the division of the first argument by the second argument, fuzzed to avoid most unexpected floating-point results. | |
| PI Function | Returns the constant value of PI as a floating-point value. | |
| POWER Function | Returns the value of a numeric value expression raised to a specified power. | |
| SIGN Function | Returns a number that indicates the sign of a numeric value expression. | |
| SQRT Function | Returns the square root of a value. | |
| Probability | POISSON Function | Returns the probability from a Poisson distribution. |
| PROBBETA Function | Returns the probability from a beta distribution. | |
| PROBBNML Function | Returns the probability from a binomial distribution. | |
| PROBBNRM Function | Returns a probability from a bivariate normal distribution. | |
| PROBCHI Function | Returns the probability from a chi-square distribution. | |
| PROBF Function | Returns the probability from an F distribution. | |
| PROBGAM Function | Returns the probability from a gamma distribution. | |
| PROBHYPR Function | Returns the probability from a hypergeometric distribution. | |
| PROBNEGB Function | Returns the probability from a negative binomial distribution. | |
| PROBNORM Function | Returns the probability from the standard normal distribution. | |
| Quantile | BETAINV Function | Returns a quantile from the beta distribution. |
| GAMINV Function | Returns a quantile from the gamma distribution. | |
| PROBIT Function | Returns a quantile from the standard normal distribution. | |
| TINV Function | Returns a quantile from the t distribution. | |
| Scalar | NMISS Function | Returns the number of null values or SAS missing values in an expression. |
| Special | CAST Function | Converts a value from one data type to another. |
| IFNULL Function | Checks the value of the first expression and, if it is null or a SAS missing value, returns the second expression. | |
| PUT Function | Returns a value using a specified format. | |
| Trigonometric | ARCOS Function | Returns the arccosine in radians. |
| ARSIN Function | Returns the arcsine in radians. | |
| ATAN Function | Returns the arctangent in radians. | |
| ATAN2 Function | Returns the arctangent of the x and y coordinates of a right triangle, in radians. | |
| COS Function | Returns the cosine in radians. | |
| COSH Function | Returns the hyperbolic cosine in radians. | |
| COT Function | Returns the tangent in radians. | |
| DEGREES Function | Returns the number of degrees for an angle in radians. | |
| RADIANS Function | Returns the number of radians converted from a numeric degree value. | |
| SIN Function | Returns the trigonometric sine. | |
| SINH Function | Returns the hyperbolic sine. | |
| TAN Function | Returns the tangent. | |
| TANH Function | Returns the hyperbolic tangent. | |
| Truncation | CEIL Function | Returns the smallest integer greater than or equal to a numeric value expression. |
| CEILZ Function | Returns the smallest integer that is greater than or equal to the argument, using zero fuzzing. | |
| FLOOR Function | Returns the largest integer less than or equal to a numeric value expression. | |
| FLOORZ Function | Returns the largest integer that is less than or equal to the argument, using zero fuzzing. | |
| FUZZ Function | Returns the nearest integer if the argument is within 1E-12 of that integer. | |
| ROUND Function | Rounds the first argument to the nearest multiple of the second argument, or to the nearest integer when the second argument is omitted. | |
| TRUNC Function | Truncates a numeric value to a specified length. |