General Functions Listed Alphabetically

A B C D E F G H I J K L M N O P Q R S T U V W Y Z

Name
Syntax and Description
ABS(expression)
Returns the absolute value of a numeric value expression.
Product: Base SAS
Document: SAS DS2 Language Reference
ABS(expression)
Returns the absolute value of a numeric value expression.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
ABS(argument)
Returns the absolute value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
ADDR(variable)
Returns the memory address of a variable on a 32-bit platform.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
ADDRLONG(variable)
Returns the memory address of a variable on 32-bit and 64-bit platforms.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
AIRY(x)
Returns the value of the Airy function.
Product: Base SAS
Document: SAS DS2 Language Reference
AIRY(x)
Returns the value of the Airy function.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
AIRY(x)
Returns the value of a differential equation.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
ALLCOMB(count, k, variable-1, …, variable-n)
Generates all combinations of the values of n variables taken k at a time in a minimal change order.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
ALLPERM(count, variable-1 <,variable-2 ...>)
Generates all permutations of the values of several variables in a minimal change order.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
ANORM420 (string,<modifiers>)
Returns a normalized string from an input string encoded in EBCDIC420.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
ANYALNUM('expression'[, start])
Searches a character string for an alphanumeric character, and returns the first character position at which the character is found.
Product: Base SAS
Document: SAS DS2 Language Reference
ANYALNUM('expression'[, start])
Searches a character string for an alphanumeric character, and returns the first character position at which the character is found.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
ANYALNUM(string <,start>)
Searches a character string for an alphanumeric character, and returns the first position at which the character is found.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
ANYALPHA('expression'[, start])
Searches a character string for an alphabetic character, and returns the first character position at which the character is found.
Product: Base SAS
Document: SAS DS2 Language Reference
ANYALPHA('expression'[, start])
Searches a character string for an alphabetic character, and returns the first character position at which the character is found.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
ANYALPHA(string <,start>)
Searches a character string for an alphabetic character, and returns the first position at which the character is found.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
ANYCNTRL('expression' [, start])
Searches a character string for a control character, and returns the first character position at which that character is found.
Product: Base SAS
Document: SAS DS2 Language Reference
ANYCNTRL(string <,start>)
Searches a character string for a control character, and returns the first position at which that character is found.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
ANYDIGIT('expression'[, start])
Searches a character string for a digit, and returns the first character position at which the digit is found.
Product: Base SAS
Document: SAS DS2 Language Reference
ANYDIGIT('expression'[, start])
Searches a character string for a digit, and returns the first character position at which the digit is found.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
ANYDIGIT(string <,start>)
Searches a character string for a digit, and returns the first position at which the digit is found.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
ANYFIRST('expression'[, start])
Searches a character string for a character that is valid as the first character in a SAS variable name under VALIDVARNAME=V7, and returns the first character position at which that character is found.
Product: Base SAS
Document: SAS DS2 Language Reference
ANYFIRST('expression'[, start])
Searches a character string for a character that is valid as the first character in a SAS variable name under VALIDVARNAME=V7, and returns the first character position at which that character is found.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
ANYFIRST(string <,start>)
Searches a character string for a character that is valid as the first character in a SAS variable name under VALIDVARNAME = V7, and returns the first position at which that character is found.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
ANYGRAPH('string'[, start])
Searches a character string for a graphical character, and returns the first character position at which that character is found.
Product: Base SAS
Document: SAS DS2 Language Reference
ANYGRAPH(string <,start>)
Searches a character string for a graphical character, and returns the first position at which that character is found.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
ANYLOWER('expression'[, start])
Searches a character string for a lowercase letter, and returns the first character position at which the letter is found.
Product: Base SAS
Document: SAS DS2 Language Reference
ANYLOWER('expression'[, start])
Searches a character string for a lowercase letter, and returns the first character position at which the letter is found.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
ANYLOWER(string <,start>)
Searches a character string for a lowercase letter, and returns the first position at which the letter is found.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
ANYNAME('expression'[,start])
Searches a character string for a character that is valid in a SAS variable name under VALIDVARNAME=V7, and returns the first character position at which that character is found.
Product: Base SAS
Document: SAS DS2 Language Reference
ANYNAME('expression'[,start])
Searches a character string for a character that is valid in a SAS variable name under VALIDVARNAME=V7, and returns the first character position at which that character is found.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
ANYNAME(string <,start>)
Searches a character string for a character that is valid in a SAS variable name under VALIDVARNAME = V7, and returns the first position at which that character is found.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
ANYPRINT('expression'[, start])
Searches a character string for a printable character, and returns the first character position at which that character is found.
Product: Base SAS
Document: SAS DS2 Language Reference
ANYPRINT(string <,start>)
Searches a character string for a printable character, and returns the first position at which that character is found.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
ANYPUNCT('expression'[, start])
Searches a character string for a punctuation character, and returns the first character position at which that character is found.
Product: Base SAS
Document: SAS DS2 Language Reference
ANYPUNCT('expression'[, start])
Searches a character string for a punctuation character, and returns the first character position at which that character is found.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
ANYPUNCT(string <,start>)
Searches a character string for a punctuation character, and returns the first position at which that character is found.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
ANYPUNCT(string <,start> )
Searches a string for a punctuation character and returns the first position at which that character is found.
Product: Base SAS
Document: SAS Companion for z/OS
ANYSPACE('expression'[, start])
Searches a character string for a whitespace character (blank, horizontal and vertical tab, carriage return, line feed, and form feed), and returns the first character position at which that character is found.
Product: Base SAS
Document: SAS DS2 Language Reference
ANYSPACE('expression'[, start])
Searches a character string for a whitespace character (blank, horizontal and vertical tab, carriage return, line feed, and form feed), and returns the first character position at which that character is found.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
ANYSPACE(string <,start>)
Searches a character string for a whitespace character (blank, horizontal or vertical tab, carriage return, line feed, and form feed), and returns the first position at which that character is found.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
ANYUPPER('expression'[, start])
Searches a character string for an uppercase letter, and returns the first character position at which the letter is found.
Product: Base SAS
Document: SAS DS2 Language Reference
ANYUPPER('expression'[, start])
Searches a character string for an uppercase letter, and returns the first character position at which the letter is found.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
ANYUPPER(string <,start>)
Searches a character string for an uppercase letter, and returns the first position at which the letter is found.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
ANYXDIGIT('expression'[,start])
Searches a character string for a hexadecimal character that represents a digit, and returns the first character position at which that character is found.
Product: Base SAS
Document: SAS DS2 Language Reference
ANYXDIGIT('expression'[,start])
Searches a character string for a hexadecimal character that represents a digit, and returns the first character position at which that character is found.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
ANYXDIGIT(string <,start>)
Searches a character string for a hexadecimal character that represents a digit, and returns the first position at which that character is found.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CLAUSE = APPSRV_AUTHCLS(type)
Reads the AUTHLIB data set and returns a WHERE clause.
Product: SAS/IntrNet
Document: SAS/IntrNet: Application Dispatcher
RC = APPSRV_AUTHDS(data-set)
Enables the user to change the AUTHLIB data set name.
Product: SAS/IntrNet
Document: SAS/IntrNet: Application Dispatcher
RC = APPSRV_AUTHLIB(<libref><, member-name><, member-type><, entry-name>
<, entry-type>)
Determines whether the Application Server program is authorized to access a specified data source.
Product: SAS/IntrNet
Document: SAS/IntrNet: Application Dispatcher
OLD-HEADER = APPSRV_HEADER(header-name,header-value);
The DATA step function used to add or modify a header.
Product: SAS/IntrNet
Document: SAS/IntrNet: Application Dispatcher
RC = APPSRV_SESSION('command'<, time-out>)
Creates or deletes a session.
Product: SAS/IntrNet
Document: SAS/IntrNet: Application Dispatcher
VALUE = APPSRV_UNSAFE(value-code)
Returns the character value of a PROC APPSRV parameter setting.
Product: SAS/IntrNet
Document: SAS/IntrNet: Application Dispatcher
VALUE=APPSRVGETC(value-code)
Returns the character value of a PROC APPSRV parameter setting.
Product: SAS/IntrNet
Document: SAS/IntrNet: Application Dispatcher
VALUE=APPSRVGETN(value-code)
Returns the numeric value of a PROC APPSRV parameter setting.
Product: SAS/IntrNet
Document: SAS/IntrNet: Application Dispatcher
RC=APPSRVSET(value-code,new-value)
Returns the numeric value of a PROC APPSRV parameter setting.
Product: SAS/IntrNet
Document: SAS/IntrNet: Application Dispatcher
ARCOS(expression)
Returns the arccosine in radians.
Product: Base SAS
Document: SAS DS2 Language Reference
ARCOS(expression)
Returns the arccosine in radians.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
ARCOS(argument)
Returns the arccosine.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
ARCOSH(expression)
Returns the inverse hyperbolic cosine.
Product: Base SAS
Document: SAS DS2 Language Reference
ARCOSH(expression)
Returns the inverse hyperbolic cosine.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
ARCOSH(x)
Returns the inverse hyperbolic cosine.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
ARSIN(expression)
Returns the arcsine in radians.
Product: Base SAS
Document: SAS DS2 Language Reference
ARSIN(expression)
Returns the arcsine in radians.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
ARSIN(argument)
Returns the arcsine.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
ARSINH(expression)
Returns the inverse hyperbolic sine.
Product: Base SAS
Document: SAS DS2 Language Reference
ARSINH(expression)
Returns the inverse hyperbolic sine.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
ARSINH(x)
Returns the inverse hyperbolic sine.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
ARTANH(expression)
Returns the inverse hyperbolic tangent.
Product: Base SAS
Document: SAS DS2 Language Reference
ARTANH(expression)
Returns the inverse hyperbolic tangent.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
ARTANH(x)
Returns the inverse hyperbolic tangent.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
ATAN(expression)
Returns the arctangent in radians.
Product: Base SAS
Document: SAS DS2 Language Reference
ATAN(expression)
Returns the arctangent in radians.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
ATAN(argument)
Returns the arc tangent.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
ATAN2 (expression-1, expression-2)
Returns the arctangent of the x and y coordinates of a right triangle, in radians.
Product: Base SAS
Document: SAS DS2 Language Reference
ATAN2(expression-1, expression-2 )
Returns the arctangent of the x and y coordinates of a right triangle, in radians.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
ATAN2(argument-1, argument-2)
Returns the arc tangent of the x and y coordinates of a right triangle, in radians.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
ATTRC(data-set-id, attribute-name)
Returns the value of a character attribute for a SAS data set.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
ATTRN(data-set-id, attribute-name)
Returns the value of a numeric attribute for a SAS data set.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
AVG([DISTINCT] expression)
Returns the average of all values in a column.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
BAND(expression-1, expression-2)
Returns the bitwise logical AND of two arguments.
Product: Base SAS
Document: SAS DS2 Language Reference
BAND(expression-1, expression-2)
Returns the bitwise logical AND of two arguments.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
BAND(argument-1, argument-2)
Returns the bitwise logical AND of two arguments.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
STR=BASECHAR(<instr>(,<Unicode type>))
Converts characters to base characters.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
BETA(a, b)
Returns the value of the beta function.
Product: Base SAS
Document: SAS DS2 Language Reference
BETA(a, b)
Returns the value of the beta function.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
BETA(a, b)
Returns the value of the beta function.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
BETAINV(p, a, b)
Returns a quantile from the beta distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
BETAINV(p, a, b)
Returns a quantile from the beta distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
BETAINV(p, a, b)
Returns a quantile from the beta distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
BLACKCLPRC(E, t, F, r, sigma)
Calculates call prices for European options on futures, based on the Black model.
Product: Base SAS
Document: SAS DS2 Language Reference
BLACKCLPRC(E, t, F, r, sigma)
Calculates call prices for European options on futures, based on the Black model.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
BLACKCLPRC(E, t, F, r, sigma)
Calculates call prices for European options on futures, based on the Black model.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
BLACKPTPRC(E, t, F, r, sigma)
Calculates put prices for European options on futures, based on the Black model.
Product: Base SAS
Document: SAS DS2 Language Reference
BLACKPTPRC(E, t, F, r, sigma)
Calculates put prices for European options on futures, based on the Black model.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
BLACKPTPRC(E, t, F, r, sigma)
Calculates put prices for European options on futures, based on the Black model.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
BLKSHCLPRC(E, t, S, r, sigma)
Calculates call prices for European options on stocks, based on the Black-Scholes model.
Product: Base SAS
Document: SAS DS2 Language Reference
BLKSHCLPRC(E, t, S, r, sigma)
Calculates call prices for European options on stocks, based on the Black-Scholes model.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
BLKSHCLPRC(E, t, S, r, sigma)
Calculates call prices for European options on stocks, based on the Black-Scholes model.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
BLKSHPTPRC(E, t, S, r, sigma)
Calculates put prices for European options on stocks, based on the Black-Scholes model.
Product: Base SAS
Document: SAS DS2 Language Reference
BLKSHPTPRC(E, t, S, r, sigma)
Calculates put prices for European options on stocks, based on the Black-Scholes model.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
BLKSHPTPRC(E, t, S, r, sigma)
Calculates put prices for European options on stocks, based on the Black-Scholes model.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
BLSHIFT(expression-1, expression-2)
Returns the bitwise logical left shift of two arguments.
Product: Base SAS
Document: SAS DS2 Language Reference
BLSHIFT(expression-1, expression-2)
Returns the bitwise logical left shift of two arguments.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
BLSHIFT(argument-1, argument-2)
Returns the bitwise logical left shift of two arguments.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
BNOT(expression)
Returns the bitwise logical NOT of an argument.
Product: Base SAS
Document: SAS DS2 Language Reference
BNOT(expression)
Returns the bitwise logical NOT of an argument.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
BNOT(argument)
Returns the bitwise logical NOT of an argument.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
BOR(expression-1, expression-2)
Returns the bitwise logical OR of two arguments.
Product: Base SAS
Document: SAS DS2 Language Reference
BOR(expression-1, expression-2)
Returns the bitwise logical OR of two arguments.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
BOR(argument-1, argument-2)
Returns the bitwise logical OR of two arguments.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
BRSHIFT(expression-1, expression-2)
Returns the bitwise logical right shift of two arguments.
Product: Base SAS
Document: SAS DS2 Language Reference
BRSHIFT(expression-1, expression-2)
Returns the bitwise logical right shift of two arguments.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
BRSHIFT(argument-1, argument-2)
Returns the bitwise logical right shift of two arguments.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
BTRIM(<<btrim-specification> <'btrim-character' FROM>> sql-expression)
Removes blanks or specified characters from the beginning, the end, or both the beginning and end of a character string.
Product: Base SAS
Document: SAS SQL Procedure User’s Guide
BXOR(expression-1, expression-2)
Returns the bitwise logical EXCLUSIVE OR of two arguments.
Product: Base SAS
Document: SAS DS2 Language Reference
BXOR(expression-1, expression-2)
Returns the bitwise logical EXCLUSIVE OR of two arguments.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
BXOR(argument-1, argument-2)
Returns the bitwise logical EXCLUSIVE OR of two arguments.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
BYTE(n)
Returns one character in the ASCII or the EBCDIC collating sequence.
Product: Base SAS
Document: SAS DS2 Language Reference
BYTE(n)
Returns one character in the ASCII or the EBCDIC collating sequence.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
BYTE (n)
Returns one character in the ASCII or EBCDIC collating sequence.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
BYTE(n)
Returns one character in the ASCII collating sequence.
Product: Base SAS
Document: SAS Companion for UNIX Environments
BYTE(n)
Returns one character in the ASCII collating sequence.
Product: Base SAS
Document: SAS Companion for Windows
CAST(expression AS data-type [(length)] )
Converts a value from one data type to another.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CAT(item-1[, ...item-n])
Does not remove leading or trailing blanks, and returns a concatenated character string.
Product: Base SAS
Document: SAS DS2 Language Reference
CAT(item-1 <, …, item-n>)
Does not remove leading or trailing blanks and returns a concatenated character string.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CATQ(modifiers [, delimiter], item-1 [, …, item-n])
Concatenates character or numeric values by using a delimiter to separate items and by adding quotation marks to strings that contain the delimiter.
Product: Base SAS
Document: SAS DS2 Language Reference
CATQ(modifiers <, delimiter>, item-1 <, …, item-n>)
Concatenates character and numeric values by using a delimiter to separate items and by adding quotation marks to strings that contain the delimiter.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CATS(item[, ...item])
Removes leading and trailing blanks, and returns a concatenated character string.
Product: Base SAS
Document: SAS DS2 Language Reference
CATS(item-1 <, …, item-n>)
Removes leading and trailing blanks, and returns a concatenated character string.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CATT(item[, ...item])
Removes trailing blanks, and returns a concatenated character string.
Product: Base SAS
Document: SAS DS2 Language Reference
CATT(item-1 <, … item-n>)
Removes trailing blanks, and returns a concatenated character string.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CATX(delimiter, item-1[, ...item-n])
Removes leading and trailing blanks, inserts delimiters, and returns a concatenated character string.
Product: Base SAS
Document: SAS DS2 Language Reference
CATX(delimiter, item-1 <, ... item-n>)
Removes leading and trailing blanks, inserts delimiters, and returns a concatenated character string.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CDF('BERNOULLI', x, p)
Returns a value from the Bernoulli cumulative probability distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
CDF('BERNOULLI', x, p)
Returns a value from the Bernoulli cumulative probability distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CDF('BERNOULLI', x, p)
Returns a value from the Bernoulli cumulative probability distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CDF('BETA', x, a, b [, l, r])
Returns a value from the beta cumulative probability distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
CDF('BETA', x, a, b [, l, r])
Returns a value from the beta cumulative probability distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CDF('BETA', x, a, b <, l, r>)
Returns a value from the beta cumulative probability distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CDF('BINOMIAL', m, p, n)
Returns a value from the binomial cumulative probability distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
CDF('BINOMIAL', m, p, n)
Returns a value from the binomial cumulative probability distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CDF('BINOMIAL', m, p, n)
Returns a value from the binomial cumulative probability distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CDF('CAUCHY', x [,θ] [, λ])
Returns a value from the Cauchy cumulative probability distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
CDF('CAUCHY', x [,θ] [, λ])
Returns a value from the Cauchy cumulative probability distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CDF('CAUCHY', x <,θ> <, λ>)
Returns a value from the Cauchy cumulative probability distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CDF('CHISQUARE', x, df <, nc>)
Returns a value from the Chi-square cumulative probability distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CDF('CHISQUARE', x, df [, nc])
Returns a value from the chi-square cumulative probability distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
CDF('CHISQUARE', x, df [, nc])
Returns a value from the chi-square cumulative probability distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CDF('CONMAXPOI', y, λ,ν)
Returns a value from the Conway-Maxwell-Poisson cumulative probability distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
CDF('CONMAXPOI', y, λ,ν)
Returns a value from the Conway-Maxwell-Poisson cumulative probability distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CDF('CONMAXPOI', y, λ,ν)
Returns a value from the Conway-Maxwell-Poisson cumulative probability distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CDF('EXPONENTIAL', x [,λ])
Returns a value from the exponential cumulative probability distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
CDF('EXPONENTIAL', x [,λ])
Returns a value from the exponential cumulative probability distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CDF('EXPONENTIAL', x <,λ>)
Returns a value from the Exponential probability distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CDF('F', x, ndf, ddf [, nc])
Returns a value from the F cumulative probability distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
CDF('F', x, ndf, ddf [, nc])
Returns a value from the F cumulative probability distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CDF('F', x, ndf, ddf <, nc>)
Returns a value from the F distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CDF('distribution', quantile [, parameter-1, …, parameter-k])
Computes the left cumulative distribution function from various continuous and discrete probability distributions.
Product: Base SAS
Document: SAS DS2 Language Reference
CDF('distribution', quantile [, parameter-1, …, parameter-k])
Computes the left cumulative distribution function from various continuous and discrete probability distributions.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CDF(distribution, quantile <, parameter-1, …, parameter-k>)
Returns a value from a cumulative probability distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CDF('GAMMA', x, a [, λ])
Returns a value from the gamma cumulative probability distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
CDF('GAMMA', x, a [, λ])
Returns a value from the gamma cumulative probability distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CDF('GAMMA', x, a <, λ>)
Returns a value from the gamma distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CDF(‘GENPOISSON’, x, θ, η)
Returns a value from the generalized Poisson cumulative probability distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
CDF(‘GENPOISSON’, x, θ, η)
Returns a value from the generalized Poisson cumulative probability distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CDF(‘GENPOISSON’, x, θ, η)
Returns information about the generalized Poisson distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CDF('GEOMETRIC', m, p)
Returns a value from the geometric cumulative probability distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
CDF('GEOMETRIC', m, p)
Returns a value from the geometric cumulative probability distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CDF('GEOMETRIC', m, p)
Returns information from the geometric distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CDF('HYPER', x, N, R, n [, o])
Returns a value from the hypergeometric cumulative probability distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
CDF('HYPER', x, N, R, n [, o])
Returns a value from the hypergeometric cumulative probability distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CDF('HYPER', x, N, R, n <, o>)
Returns information about the hypergeometric distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CDF('LAPLACE', x [,θ, λ])
Returns a value from the Laplace cumulative probability distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
CDF('LAPLACE', x [,θ, λ])
Returns a value from the Laplace cumulative probability distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CDF('LAPLACE', x <,θ, λ>)
Returns information about the Laplace distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CDF('LOGISTIC', x [, θ, λ])
Returns a value from the logistic cumulative probability distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
CDF('LOGISTIC', x [, θ, λ])
Returns a value from the logistic cumulative probability distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CDF('LOGISTIC', x <, θ, λ>)
Returns information about the logistic distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CDF('LOGNORMAL', x [, θ, λ])
Returns a value from the lognormal cumulative probability distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
CDF('LOGNORMAL', x [, θ, λ])
Returns a value from the lognormal cumulative probability distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CDF('LOGNORMAL', x <, θ, λ>)
Returns information about the lognormal distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CDF('NEGBINOMIAL', m, p, n)
Returns information about the negative binomial distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CDF('NEGBINOMIAL', m, p, n)
Returns a value from the negative binomial cumulative probability distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
CDF('NEGBINOMIAL', m, p, n)
Returns a value from the negative binomial cumulative probability distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CDF('NORMAL', x [, θ, λ])
Returns a value from the normal cumulative probability distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
CDF('NORMAL', x [, θ, λ])
Returns a value from the normal cumulative probability distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CDF('NORMAL', x <, θ, λ>)
Returns information about the normal distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CDF('NORMALMIX', x, n, p, m, s)
Returns information about the normal mixture distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CDF('NORMALMIX', x, n, p, m, s)
Returns a value from the normal mixture cumulative probability distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
CDF('NORMALMIX', x, n, p, m, s)
Returns a value from the normal mixture cumulative probability distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CDF('PARETO', x, a [, k])
Returns a value from the Pareto cumulative probability distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
CDF('PARETO', x, a [, k])
Returns a value from the Pareto cumulative probability distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CDF('PARETO', x, a <, k>)
Returns information about the Pareto distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CDF('POISSON', n, m)
Returns a value from the Poisson cumulative probability distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
CDF('POISSON', n, m)
Returns a value from the Poisson cumulative probability distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CDF('POISSON', n, m)
Returns information from the Poisson distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CDF('T', t, df [, nc])
Returns a value from the T cumulative probability distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
CDF('T', t, df [, nc])
Returns a value from the T cumulative probability distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CDF('T', t, df <, nc>)
Returns information about the CDF t distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CDF (‘TWEEDIE’, y, p [, µ, φ])
Returns a value from the Tweedie cumulative probability distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
CDF (‘TWEEDIE’, y, p [, µ, φ])
Returns a value from the Tweedie cumulative probability distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CDF (‘TWEEDIE’, y, p <, µ, φ>)
Returns information about the Tweedie distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CDF('UNIFORM', x [, l, r])
Returns a value from the uniform cumulative probability distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
CDF('UNIFORM', x [, l, r])
Returns a value from the uniform cumulative probability distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CDF('UNIFORM', x <, l, r>)
Returns information about the uniform distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CDF('WALD', x, λ [, µ])
CDF('IGAUSS', x, λ [, µ])
Returns a value from the Wald (also known as the inverse Gaussian) cumulative probability distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
CDF('WALD', x, λ [, µ])
CDF('IGAUSS', x, λ [, µ])
Returns a value from the Wald (also known as the inverse Gaussian) cumulative probability distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CDF('WALD', x, λ <, µ>)
CDF('IGAUSS', x, λ <, µ>)
Returns information about the Wald distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CDF('WEIBULL', x, a [, λ])
Returns a value from the Weibull cumulative probability distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
CDF('WEIBULL', x, a [, λ])
Returns a value from the Weibull cumulative probability distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CDF('WEIBULL', x, a <, λ>)
Returns information about the Weibull distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CEIL(expression)
Returns the smallest integer greater than or equal to a numeric value expression.
Product: Base SAS
Document: SAS DS2 Language Reference
CEIL(expression)
Returns the smallest integer greater than or equal to a numeric value expression.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CEIL(argument)
Returns the smallest integer that is greater than or equal to the argument, fuzzed to avoid unexpected floating-point results.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CEILZ(expression)
Returns the smallest integer that is greater than or equal to the argument, using zero fuzzing.
Product: Base SAS
Document: SAS DS2 Language Reference
CEILZ(expression)
Returns the smallest integer that is greater than or equal to the argument, using zero fuzzing.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CEILZ(argument)
Returns the smallest integer that is greater than or equal to the argument, using zero fuzzing.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CEXIST(entry<, 'U'>)
Verifies the existence of a SAS catalog or SAS catalog entry.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CHAR(string, position)
Returns a single character from a specified position in a character string.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CHARACTER_LENGTH(expression)
Returns the number of characters in a string of any data type.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CHOOSEC(index-expression, selection-1[, ...selection-n])
Returns a character value that represents the results of choosing from a list of arguments.
Product: Base SAS
Document: SAS DS2 Language Reference
CHOOSEC(index-expression, selection-1 <, …selection-n>)
Returns a character value that represents the results of choosing from a list of arguments.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CHOOSEN(index-expression, selection-1[, ...selection-n])
Returns a numeric value that represents the results of choosing from a list of arguments.
Product: Base SAS
Document: SAS DS2 Language Reference
CHOOSEN(index-expression, selection-1 <, …selection-n>)
Returns a numeric value that represents the results of choosing from a list of arguments.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CINV(p, df<, nc>)
Returns a quantile from the chi-square distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CLIBEXIST(session name,caslib name)
CLIBEXIST(uuid,caslib name)
Returns 0 when the specified caslib name is not found and 1 when the caslib is found.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
CLOSE(data-set-id)
Closes a SAS data set.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CMISS(argument [, ...argument,])
Counts the number of missing arguments.
Product: Base SAS
Document: SAS DS2 Language Reference
CMISS(argument-1 <, argument-2,…>)
Counts the number of missing arguments.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CMP (string-1, string-2)
Compares two character strings including trailing blanks.
Product: Base SAS
Document: SAS DS2 Language Reference
CMPT (string-1, string-2)
Compares two character strings excluding trailing blanks.
Product: Base SAS
Document: SAS DS2 Language Reference
CNONCT(x, df, probability)
Returns the noncentrality parameter from a chi-square distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
CNONCT(x, df, probability)
Returns the noncentrality parameter from a chi-square distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CNONCT(x, df, probability)
Returns the noncentrality parameter from a chi-square distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
COALESCE(expression[, ...expression])
Returns the first non-null or nonmissing value from a list of numeric arguments.
Product: Base SAS
Document: SAS DS2 Language Reference
COALESCE(expression[, ...expression])
Returns the first non-null or nonmissing value from a list of numeric arguments.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
COALESCE(argument-1<..., argument-n>)
Returns the first nonmissing value from a list of numeric arguments.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
COALESCE (column-name-1 <, column-name-2, ...>)
Returns the first nonmissing value from a list of columns.
Product: Base SAS
Document: SAS SQL Procedure User’s Guide
COALESCEC(expression[, ...expression])
Returns the first non-null or nonmissing value from a list of character arguments.
Product: Base SAS
Document: SAS DS2 Language Reference
COALESCEC(expression[, ...expression])
Returns the first non-null or nonmissing value from a list of character arguments.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
COALESCEC(argument-1 < ..., argument-n>)
Returns the first nonmissing value from a list of character arguments.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
COLLATE(start-position <, end-position>) | (start-position <, , length>)
Returns a character string in the ASCII or EBCDIC collating sequence.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
COLLATE(start-position <, end-position>) | (start-position <, , length>)
Returns a character string in an ASCII collating sequence.
Product: Base SAS
Document: SAS Companion for UNIX Environments
COLLATE (start-position< ,end-position > )|(start-position< ,,length > )
Returns an ASCII collating sequence character string.
Product: Base SAS
Document: SAS Companion for Windows
cval=COMAMID();
Returns a string that contains all of the communications access methods that are valid for the operating environment that the SCL code executes under.
Product: SAS/CONNECT
Document: SAS/CONNECT User’s Guide
COMB(n, r)
Computes the number of combinations of n elements taken r at a time.
Product: Base SAS
Document: SAS DS2 Language Reference
COMB(n, r)
Computes the number of combinations of n elements taken r at a time.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
COMB(n, r)
Computes the number of combinations of n elements taken r at a time.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
COMPARE(string-1, string-2[, modifiers])
Returns the position of the leftmost character by which two strings differ, or returns 0 if there is no difference.
Product: Base SAS
Document: SAS DS2 Language Reference
COMPARE(string-1, string-2[, modifiers])
Returns the position of the leftmost character by which two strings differ, or returns 0 if there is no difference.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
COMPARE(string-1, string-2 <, modifier(s)>)
Returns the position of the leftmost character by which two strings differ, or returns 0 if there is no difference.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
COMPBL(character-expression)
Removes multiple blanks from a character string.
Product: Base SAS
Document: SAS DS2 Language Reference
COMPBL(character-expression)
Removes multiple blanks from a character string.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
COMPBL(source)
Removes multiple blanks from a character string.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
COMPCOST(operation-1, value-1 [..., operation-n, value-n]);
Sets the costs of operations for later use by the COMPGED function.
Product: Base SAS
Document: SAS DS2 Language Reference
COMPFUZZ(expression-1, expression-2[, fuzz[, scale]])
Performs a fuzzy comparison of two numeric values.
Product: Base SAS
Document: SAS DS2 Language Reference
COMPFUZZ(value-1, value-2 <, fuzz <, scale>>)
Performs a fuzzy comparison of two numeric values.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
COMPGED(string-1, string-2 [, cutoff] [, modifier(s)])
Returns the generalized edit distance between two strings.
Product: Base SAS
Document: SAS DS2 Language Reference
COMPGED(string-1, string-2 <, cutoff> <, modifier(s)>)
Returns the generalized edit distance between two strings.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
COMPLEV(string-1, string-2 [, cutoff] [, modifier(s)])
Returns the Levenshtein edit distance between two strings.
Product: Base SAS
Document: SAS DS2 Language Reference
COMPLEV(string-1, string-2 <, cutoff> <, modifier(s)>)
Returns the Levenshtein edit distance between two strings.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
COMPOUND(a, f, r, n)
Returns compound interest parameters.
Product: Base SAS
Document: SAS DS2 Language Reference
COMPOUND(a, f, r, n)
Returns compound interest parameters.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
COMPOUND(a, f, r, n)
Returns compound interest parameters.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
COMPRESS(character-expression[, character-list-expression] [, modifier(s)])
Returns a character string with specified characters removed from the original string.
Product: Base SAS
Document: SAS DS2 Language Reference
COMPRESS(character-expression[, character-list-expression] [, modifier(s)])
Returns a character string with specified characters removed from the original string.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
COMPRESS(source ,< characters> ,< modifier(s)>)
Returns a character string with specified characters removed from the original string.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
variable-name=COMPSRV_OVAL(macro-variable-name);
Returns the original, possibly unsafe, value of an input parameter or global macro variable that is passed into the Compute server.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
%SYSCALL STPSRV_UNQUOTE2(macro-variable-name)
Unmasks matched pairs of quotation marks in an input parameter or global macro variable.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CONSTANT(constant[, parameter])
Computes machine and mathematical constants.
Product: Base SAS
Document: SAS DS2 Language Reference
CONSTANT(constant[, parameter])
Computes machine and mathematical constants.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CONSTANT(constant <, parameter>)
Computes machine and mathematical constants.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CONVX(y, f, c(1), ..., c(k))
Returns the convexity for an enumerated cash flow.
Product: Base SAS
Document: SAS DS2 Language Reference
CONVX(y, f, c(1), ..., c(k))
Returns the convexity for an enumerated cash flow.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CONVX(y, f, c(1), ..., c(k))
Returns the convexity for an enumerated cash flow.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CONVXP(A, c, n, K, k0, y)
Returns the convexity for a periodic cash flow stream, such as a bond.
Product: Base SAS
Document: SAS DS2 Language Reference
CONVXP(A, c, n, K, k0, y)
Returns the convexity for a periodic cash flow stream, such as a bond.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CONVXP(A, c, n, K, k0, y)
Returns the convexity for a periodic cash flow stream such as a bond.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
COS(expression)
Returns the cosine in radians.
Product: Base SAS
Document: SAS DS2 Language Reference
COS(expression)
Returns the cosine in radians.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
COS(argument)
Returns the cosine.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
COSH(expression)
Returns the hyperbolic cosine in radians.
Product: Base SAS
Document: SAS DS2 Language Reference
COSH(expression)
Returns the hyperbolic cosine in radians.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
COSH(argument)
Returns the hyperbolic cosine.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
COT(argument)
Returns the cotangent.
Product: Base SAS
Document: SAS DS2 Language Reference
COT(expression)
Returns the tangent in radians.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
COT(argument)
Returns the cotangent.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
COUNT(string, substring[, modifiers])
Counts the number of times that a specified substring appears within a character string.
Product: Base SAS
Document: SAS DS2 Language Reference
COUNT(expression)
COUNT(*)
COUNT([DISTINCT] expression)
Returns the number of rows retrieved by a SELECT statement for a specified table.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
COUNT(string, substring <, modifier(s)>)
Counts the number of times that a specified substring appears within a character string.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
COUNTC(string, charlist[, modifiers])
Counts the number of characters in a string that appear or do not appear in a list of characters.
Product: Base SAS
Document: SAS DS2 Language Reference
COUNTC(string, charlist[, modifiers])
Counts the number of characters in a string that appear or do not appear in a list of characters.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
COUNTC(string, character-list <, modifier(s)>)
Counts the number of characters that appear or do not appear in a list of characters.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
COUNTW(string[, chars[, modifiers]])
Counts the number of words in a character string.
Product: Base SAS
Document: SAS DS2 Language Reference
COUNTW(string[, chars[, modifiers]])
Counts the number of words in a character string.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
COUNTW(string <, <character(s)> <, <modifier(s)>>>)
Counts the number of words in a character string.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CSC(argument)
Returns the cosecant.
Product: Base SAS
Document: SAS DS2 Language Reference
CSC(argument)
Returns the cosecant.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CSC(argument)
Returns the cosecant.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CSS(expression[, ...expression])
Returns the corrected sum of squares.
Product: Base SAS
Document: SAS DS2 Language Reference
CSS([DISTINCT] expression)
Returns the corrected sum of squares of all values in an expression.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CSS(argument-1<,...argument-n>)
Returns the corrected sum of squares.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CUMIPMT(rate, number-of-periods, principal-amount[, start-period][, end-period ][, type])
Returns the cumulative interest paid on a loan between the start and end period.
Product: Base SAS
Document: SAS DS2 Language Reference
CUMIPMT(rate, number-of-periods, principal-amount[, start-period][, end-period ][, type])
Returns the cumulative interest paid on a loan between the start and end period.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CUMIPMT(rate, number-of-periods, principal-amount, <start-period>, <end-period>, <type>)
Returns the cumulative interest paid on a loan between the start and end periods.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CUMPRINC(rate, number-of-periods, principal-amount[, start-period]
[, end-period][, type])
Returns the cumulative principal paid on a loan between the start and end period.
Product: Base SAS
Document: SAS DS2 Language Reference
CUMPRINC(rate, number-of-periods, principal-amount[, start-period]
[, end-period][, type])
Returns the cumulative principal paid on a loan between the start and end period.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CUMPRINC(rate, number-of-periods, principal-amount, <start-period>, <end-period>, <type>)
Returns the cumulative principal paid on a loan between the start and end periods.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CUROBS(data-set-id)
Returns the observation number of the current observation.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CURRENT_DATE
Returns the current date for the time zone.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CURRENT_LOCALE()
Returns the five character name of the current locale.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CURRENT_TIME
Returns the current time for your time zone.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CURRENT_TIME_GMT()
Returns the current GMT time.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CURRENT_TIMESTAMP
Returns the date and time for your time zone.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CURRENT_TIMESTAMP_GMT()
Returns the current GMT date and time.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CV(expression-1, expression-2 [, ...expression-n])
Returns the coefficient of variation.
Product: Base SAS
Document: SAS DS2 Language Reference
CV(expression-1, expression-2 [, ...expression-n])
Returns the coefficient of variation.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
CV(argument-1,argument-2 <, ...argument-n>)
Returns the coefficient of variation.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
DACCDB(p, v, y, r)
Returns the accumulated declining balance depreciation.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
DACCDBSL(p, v, y, r)
Returns the accumulated declining balance with conversion to a straight-line depreciation.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
DACCSL(p, v, y)
Returns the accumulated straight-line depreciation.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
DACCSYD(p, v, y)
Returns the accumulated sum-of-years-digits depreciation.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
DACCTAB(p, v, t1, ..., tn)
Returns the accumulated depreciation from specified tables.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
DAIRY(x)
Returns the derivative of the AIRY function.
Product: Base SAS
Document: SAS DS2 Language Reference
DAIRY(x)
Returns the derivative of the AIRY function.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
DAIRY(x)
Returns the derivative of the AIRY function.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
DATDIF(sdate, edate, basis)
Returns the number of days between two dates after computing the difference between the dates according to specified day count conventions.
Product: Base SAS
Document: SAS DS2 Language Reference
DATDIF(sdate, edate, basis)
Returns the number of days between two dates after computing the difference between the dates according to specified day count conventions.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
DATDIF(start-date, end-date, basis)
Returns the number of days between two dates after computing the difference between the dates according to specified day count conventions.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
DATE( )
Returns the current date as a SAS date value.
Product: Base SAS
Document: SAS DS2 Language Reference
DATE( )
Returns the current date as a SAS date value.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
DATE()
Returns the current date as a SAS date value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
DATEJUL(julian-date)
Converts a Julian date to a SAS date value.
Product: Base SAS
Document: SAS DS2 Language Reference
DATEJUL(julian-date)
Converts a Julian date to a SAS date value.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
DATEJUL(julian-date)
Converts a Julian date to a SAS date value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
DATEPART(datetime)
Extracts the date from a SAS datetime value.
Product: Base SAS
Document: SAS DS2 Language Reference
DATEPART(ts)
Returns the date as year, month, and day.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
DATEPART(datetime)
Extracts the date from a SAS datetime value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
DATETIME( )
Returns the current date and time of day as a SAS datetime value.
Product: Base SAS
Document: SAS DS2 Language Reference
DATETIME( )
Returns the current date and time of day as a SAS datetime value.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
DATETIME()
Returns the current date and time of day as a SAS datetime value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
DAY(date)
Returns the day of the month from a SAS date value.
Product: Base SAS
Document: SAS DS2 Language Reference
DAY(date | datetime)
Returns the numeric day of the month from a date or datetime value.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
DAY(date)
Returns the day of the month from a SAS date value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
DCLOSE(directory-id)
Closes a directory that was opened by the DOPEN function.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
DCREATE(directory-name <, parent-directory>)
Returns the complete pathname of a new, external directory.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
DEGREES(expression)
Returns the number of degrees for an angle in radians.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
DEPDB(p, v, y, r)
Returns the declining balance depreciation.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
DEPDBSL(p, v, y, r)
Returns the declining balance with conversion to a straight-line depreciation.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
DEPSL(p, v, y)
Returns the straight-line depreciation.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
DEPSYD(p, v, y)
Returns the sum-of-years-digits depreciation.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
DEPTAB(p, v, t1, ..., tn)
Returns the depreciation from specified tables.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
DEQUOTE(expression)
Removes matching single quotation marks from a character string that begins with a single quotation mark, and deletes all characters to the right of the closing quotation mark.
Product: Base SAS
Document: SAS DS2 Language Reference
DEQUOTE(expression)
Removes matching single quotation marks from a character string that begins with a single quotation mark, and deletes all characters to the right of the closing quotation mark.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
DEQUOTE(string)
Removes matching quotation marks from a character string that begins with a quotation mark, and deletes all characters to the right of the closing quotation mark.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
DEVIANCE(distribution, variable, shape-parameter(s)[, ε])
Returns the deviance based on a probability distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
DEVIANCE(distribution, variable, shape-parameter(s)[, ε])
Returns the deviance based on a probability distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
DEVIANCE(distribution, variable, shape-parameters <, ε>)
Returns the deviance based on a probability distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
DHMS(date, hour, minute, second)
Returns a SAS datetime value from date, hour, minute, and second values.
Product: Base SAS
Document: SAS DS2 Language Reference
DHMS(date, hour, minute, second)
Returns a SAS datetime value from date, hour, minute, and second values.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
DHMS(date, hour, minute, second)
Returns a SAS datetime value from date, hour, minute, and second values.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
DIF[n] (expression)
Returns differences between an argument and its nth lag.
Product: Base SAS
Document: SAS DS2 Language Reference
DIF<n> (argument)
Returns differences between an argument and its nth lag.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
DIGAMMA(expression)
Returns the value of the digamma function.
Product: Base SAS
Document: SAS DS2 Language Reference
DIGAMMA(expression)
Returns the value of the digamma function.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
DIGAMMA(argument)
Returns the value of the digamma function.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
DIM(array-name[, bound-n])
Returns the number of elements in an array.
Product: Base SAS
Document: SAS DS2 Language Reference
DIM<n> (array-name)
DIM(array-name, bound-n)
Returns the number of elements in an array.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
DINFO(directory-id, information-item)
Returns information about a directory.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
DINFO(directory-id, information-item)
Returns information about a directory.
Product: Base SAS
Document: SAS Companion for UNIX Environments
DINFO(directory-id, info-item)
Returns information about a directory.
Product: Base SAS
Document: SAS Companion for Windows
DINFO(directory-id, info-item)
Returns information about a directory.
Product: Base SAS
Document: SAS Companion for z/OS
DIVIDE(x, y)
Returns the result of a division that handles special missing values for ODS output.
Product: Base SAS
Document: SAS DS2 Language Reference
DIVIDE(x, y)
Returns the result of a division that handles special missing values for ODS output.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
DLGCDIR(<working_directory>)
Sets the working directory.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
DMSRVBATCHJOB(job-name, host, port <,parameter-list>)
Runs a DataFlux data or process job on a DataFlux Data Management Server and returns a job identifier.
Product: SAS Data Quality Server
Document: SAS Data Quality and SAS Data Quality Server: Language Reference
DMSRVCOPYLOG(job-ID, host, port, filename)
Copies a job's log file from a DataFlux Data Management Server to a local host.
Product: SAS Data Quality Server
Document: SAS Data Quality and SAS Data Quality Server: Language Reference
DMSRVDELETELOG(job-ID, host, port)
Deletes a job's log file from a DataFlux Data Management Server.
Product: SAS Data Quality Server
Document: SAS Data Quality and SAS Data Quality Server: Language Reference
DMSRVJOBSTATUS(job-ID, host, port, time-out, interval)
Returns the status of a job that was submitted to a DataFlux Data Management Server.
Product: SAS Data Quality Server
Document: SAS Data Quality and SAS Data Quality Server: Language Reference
DMSRVKILLJOB(job-ID, host, port)
Terminates a job that is running on a DataFlux Data Management Server.
Product: SAS Data Quality Server
Document: SAS Data Quality and SAS Data Quality Server: Language Reference
DMSRVPROFILEJOB(job-name, host, port, append-flag <,description-character>)
Generates a profile from a Data Management server repository.
Product: SAS Data Quality Server
Document: SAS Data Quality and SAS Data Quality Server: Language Reference
DMSRVUSER(user-ID, password)
Registers a user on a DataFlux Data Management Server.
Product: SAS Data Quality Server
Document: SAS Data Quality and SAS Data Quality Server: Language Reference
DMSRVVER(host, port)
Returns the version of the DataFlux Data Management Server.
Product: SAS Data Quality Server
Document: SAS Data Quality and SAS Data Quality Server: Language Reference
DNUM(directory-id)
Returns the number of members in a directory.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
DOPEN(fileref)
Opens a directory, and returns a directory identifier value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
DOPEN(fileref)
Opens a directory, and returns a directory identifier value.
Product: Base SAS
Document: SAS Companion for UNIX Environments
DOPEN("fileref")
Opens a directory and returns a directory identifier value.
Product: Base SAS
Document: SAS Companion for Windows
DOPEN(fileref)
Opens a directory and returns a directory identifier value.
Product: Base SAS
Document: SAS Companion for z/OS
DOPTNAME(directory-id, nval)
Returns directory attribute information.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
DOPTNAME(directory-id, nval)
Returns directory attribute information.
Product: Base SAS
Document: SAS Companion for UNIX Environments
DOPTNAME(directory-id, nval )
Returns the name of a directory information item.
Product: Base SAS
Document: SAS Companion for Windows
DOPTNAME(directory-id,nval)
Returns the name of a directory information item.
Product: Base SAS
Document: SAS Companion for z/OS
DOPTNUM(directory-id)
Returns the number of information items that are available for a directory.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
DOPTNUM(directory-id)
Returns the number of information items that are available for a directory.
Product: Base SAS
Document: SAS Companion for UNIX Environments
DOPTNUM(directory-id)
Returns the number of information items that are available for a directory.
Product: Base SAS
Document: SAS Companion for Windows
DOPTNUM(directory-id)
Returns the number of information items that are available for a directory.
Product: Base SAS
Document: SAS Companion for z/OS
DOSUBL(x)
Enables the immediate execution of SAS code after a text string is passed.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
DQCASE(character-value, 'case-definition' <, 'locale'>)
Returns a character value with standardized capitalization.
Product: SAS Data Quality Server
Document: SAS Data Quality and SAS Data Quality Server: Language Reference
DQEXTINFOGET('extraction-definition' <,'locale'>)
Returns the names of the tokens that are supported by an extraction definition.
Product: SAS Data Quality Server
Document: SAS Data Quality and SAS Data Quality Server: Language Reference
DQEXTRACT('character-value', 'extraction-definition' <,'locale'>)
Returns a delimited string of extraction token values from an input character value.
Product: SAS Data Quality Server
Document: SAS Data Quality and SAS Data Quality Server: Language Reference
DQEXTTOKENGET(delimited-string, 'token', 'extraction-definition' <,'locale'>)
Returns an extraction token value from a delimited string of extraction token values.
Product: SAS Data Quality Server
Document: SAS Data Quality and SAS Data Quality Server: Language Reference
DQEXTTOKENPUT('delimited-string', 'token-value', 'token-name',
'extraction-definition'
<,'locale'>)
Inserts an extraction token value into a delimited string of extraction token values and returns the updated delimited string.
Product: SAS Data Quality Server
Document: SAS Data Quality and SAS Data Quality Server: Language Reference
DQGENDER(character-value, 'gender-analysis-definition' <,'locale'>)
Returns a gender determination from the name of an individual.
Product: SAS Data Quality Server
Document: SAS Data Quality and SAS Data Quality Server: Language Reference
DQGENDERINFOGET('gender-analysis-definition' <,'locale'>)
Returns the name of the parse definition that is associated with the specified gender definition.
Product: SAS Data Quality Server
Document: SAS Data Quality and SAS Data Quality Server: Language Reference
DQGENDERPARSED(delimited-string, 'gender-analysis-definition' <,'locale'>)
Returns the gender of an individual from a delimited string of parse token values.
Product: SAS Data Quality Server
Document: SAS Data Quality and SAS Data Quality Server: Language Reference
DQIDENTIFY(character-value, 'identification-analysis-definition' <,'locale'>)
Returns the highest-scoring identity for a character value.
Product: SAS Data Quality Server
Document: SAS Data Quality and SAS Data Quality Server: Language Reference
DQIDENTIFYIDGET(delimited-string, 'identity-name', 'identification-analysis-definition' <,'locale'>)
Returns an identification analysis score for a given identity from a delimited string of identification analysis scores.
Product: SAS Data Quality Server
Document: SAS Data Quality and SAS Data Quality Server: Language Reference
DQIDENTIFYINFOGET('identification-analysis-definition' <,'locale'>)
Returns the names of the identities that are supported by a given identification analysis definition.
Product: SAS Data Quality Server
Document: SAS Data Quality and SAS Data Quality Server: Language Reference
DQIDENTIFYMULTI(character-value, 'identification-analysis-definition', <'locale'>)
Returns all of the identification analysis scores of a character value.
Product: SAS Data Quality Server
Document: SAS Data Quality and SAS Data Quality Server: Language Reference
DQLOCALEGUESS(character-value, 'locale-guess-definition')
Returns the ISO code of the highest-scoring locale for a character value.
Product: SAS Data Quality Server
Document: SAS Data Quality and SAS Data Quality Server: Language Reference
DQLOCALEINFOGET(<'info-type'>)
Returns a list of the locales that are loaded into memory.
Product: SAS Data Quality Server
Document: SAS Data Quality and SAS Data Quality Server: Language Reference
DQLOCALEINFOLIST('definition-type', 'locale')
Returns a count of definitions and displays the names of definitions for a type of definition in a locale.
Product: SAS Data Quality Server
Document: SAS Data Quality and SAS Data Quality Server: Language Reference
DQLOCALESCORE('character-value', 'locale-guess-definition', 'locale')
Returns a locale confidence score for an input character value.
Product: SAS Data Quality Server
Document: SAS Data Quality and SAS Data Quality Server: Language Reference
DQMATCH(character-value, 'match-definition' <,'sensitivity'> <,'locale'>)
Returns a matchcode from a character value.
Product: SAS Data Quality Server
Document: SAS Data Quality and SAS Data Quality Server: Language Reference
DQMATCHINFOGET('match-definition' <,'locale'>)
Returns the name of the parse definition that is associated with a match definition.
Product: SAS Data Quality Server
Document: SAS Data Quality and SAS Data Quality Server: Language Reference
DQMATCHPARSED(delimited-string, 'match-definition' <,sensitivity> <,'locale'>)
Returns a matchcode from a delimited string of parse token values.
Product: SAS Data Quality Server
Document: SAS Data Quality and SAS Data Quality Server: Language Reference
DQOPTSURFACE('surface-flag')
Reveals or hides non-surfaced definitions.
Product: SAS Data Quality Server
Document: SAS Data Quality and SAS Data Quality Server: Language Reference
DQPARSE('character-value', 'parse-definition' <,'locale'>)
Returns a delimited string of parse token values.
Product: SAS Data Quality Server
Document: SAS Data Quality and SAS Data Quality Server: Language Reference
DQPARSEINFOGET('parse-definition' <,'locale'>)
Returns the names of the tokens that are supported by a parse definition.
Product: SAS Data Quality Server
Document: SAS Data Quality and SAS Data Quality Server: Language Reference
DQPARSEINPUTLEN('input-length')
Overrides the default expected length of parsed input and returns a string indicating its previous value.
Product: SAS Data Quality Server
Document: SAS Data Quality and SAS Data Quality Server: Language Reference
DQPARSERESLIMIT('resource-limit')
Overrides the default expected limit on resources consumed during parsing.
Product: SAS Data Quality Server
Document: SAS Data Quality and SAS Data Quality Server: Language Reference
DQPARSESCORDEPTH(level)
Overrides the default value that determines how deeply to search for the best parsing score.
Product: SAS Data Quality Server
Document: SAS Data Quality and SAS Data Quality Server: Language Reference
DQPARSETOKENGET(delimited-string, 'token', 'parse-definition', <,'locale'>)
Returns a parse token value from a delimited string of parse token values.
Product: SAS Data Quality Server
Document: SAS Data Quality and SAS Data Quality Server: Language Reference
DQPARSETOKENPUT('delimited-string', 'token-value', 'token-name', 'parse-definition'
<,'locale'>)
Inserts a parse token value into a delimited string of parse token values and returns the updated delimited string.
Product: SAS Data Quality Server
Document: SAS Data Quality and SAS Data Quality Server: Language Reference
DQPATTERN('character-value' , 'pattern-analysis-definition' <,'locale'>)
Returns a pattern analysis from a character value.
Product: SAS Data Quality Server
Document: SAS Data Quality and SAS Data Quality Server: Language Reference
DQSCHEMEAPPLY('character-value', 'scheme', 'scheme-format' <,'mode'> <,'scheme-lookup-method'>
<,'match-definition'> <,'sensitivity'> <,'locale'>)
Applies a scheme and returns a transformed character value.
Product: SAS Data Quality Server
Document: SAS Data Quality and SAS Data Quality Server: Language Reference
DQSTANDARDIZE('character-value', ' standardization-definition' <,' locale'>)
Standardizes the casing, spacing, and format of certain words and abbreviations and returns an updated character value.
Product: SAS Data Quality Server
Document: SAS Data Quality and SAS Data Quality Server: Language Reference
DQTOKEN('character-value', 'token' , 'parse-definition' <,' locale'>)
Returns the value of a token from an input character value.
Product: SAS Data Quality Server
Document: SAS Data Quality and SAS Data Quality Server: Language Reference
DQVER()
Returns the version of the SAS Data Quality engine.
Product: SAS Data Quality Server
Document: SAS Data Quality and SAS Data Quality Server: Language Reference
DQVERQKB ()
Returns the version of the currently loaded QKB.
Product: SAS Data Quality Server
Document: SAS Data Quality and SAS Data Quality Server: Language Reference
DREAD(directory-id, nval)
Returns the name of a directory member.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
DROPNOTE(data-set-id | file-id, note-id)
Deletes a note marker from a SAS data set or an external file.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
DSNAME(data-set-id)
Returns the SAS data set name that is associated with a data set identifier.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
DSNCATLGD(filename)
Verifies the existence of an external file in the z/OS system catalog by its physical name.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
DSNCATLGD(filename)
Verifies the existence of an external file in the z/OS system catalog by its physical name.
Product: Base SAS
Document: SAS Companion for z/OS
DUR(y, f, c(1), ..., c(k))
Returns the modified duration for an enumerated cash flow.
Product: Base SAS
Document: SAS DS2 Language Reference
DUR(y, f, c(1), ..., c(k))
Returns the modified duration for an enumerated cash flow.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
DUR(y, f, c(1), ..., c(k))
Returns the modified duration for an enumerated cash flow.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
DURP(A, c, n, K, k0, y)
Returns the modified duration for a periodic cash flow stream, such as a bond.
Product: Base SAS
Document: SAS DS2 Language Reference
DURP(A, c, n, K, k0, y)
Returns the modified duration for a periodic cash flow stream, such as a bond.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
DURP(A, c, n, K, k0, y)
Returns the modified duration for a periodic cash flow stream, such as a bond.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
E()
Returns the natural logarithm, e.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
EFFRATE(compounding-interval, rate)
Returns the effective annual interest rate.
Product: Base SAS
Document: SAS DS2 Language Reference
EFFRATE(compounding-interval, rate)
Returns the effective annual interest rate.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
EFFRATE(compounding-interval, rate)
Returns the effective annual interest rate.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
ENCODCOMPAT(source1,<source2>)
Verifies the transcoding compatibility between two encodings.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
ENCODISVALID(source)
Verifies a valid encoding name.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
ENVLEN(argument)
Returns the length of an environment variable.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
ERF(expression)
Returns the value of the (normal) error function.
Product: Base SAS
Document: SAS DS2 Language Reference
ERF(expression)
Returns the value of the (normal) error function.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
ERF(argument)
Returns the value of the (normal) error function.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
ERFC(expression)
Returns the value of the complementary (normal) error function.
Product: Base SAS
Document: SAS DS2 Language Reference
ERFC(expression)
Returns the value of the complementary (normal) error function.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
ERFC(argument)
Returns the value of the complementary (normal) error function.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
EUCLID(value-1 <, value-2 ...>)
Returns the Euclidean norm of the nonmissing arguments.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
EUROCURR(from-currency-amount, from-currency-code, to-currency-code)
Converts one European currency to another.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
EXIST('member-name' <, member-type <, generation>>)
Verifies the existence of a SAS library member within a currently assigned SAS data library.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
EXP(expression)
Returns the value of the e constant raised to a specified power.
Product: Base SAS
Document: SAS DS2 Language Reference
EXP(expression)
Returns the value of the e constant raised to a specified power.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
EXP(argument)
Returns the value of the exponential function.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FACT(expression)
Computes a factorial.
Product: Base SAS
Document: SAS DS2 Language Reference
FACT(expression)
Computes a factorial.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FACT(n)
Computes a factorial.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FAPPEND(file-id <, cc>)
Appends the current record to the end of an external file.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FCLOSE(file-id)
Closes an external file, directory, or directory member.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FCLOSE(file-id)
Closes an external file, a directory, or a directory member.
Product: Base SAS
Document: SAS Companion for z/OS
FCOL(file-id)
Returns the current column position in the File Data Buffer (FDB).
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FCOPY('fileref-1', 'fileref-2')
Copies records from one fileref to another fileref, and returns a value that indicates whether the records were successfully copied.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FDELETE(fileref | directory)
Deletes an external file or an empty directory.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FDELETE(<">fileref<">)
Deletes an external file or an empty directory.
Product: Base SAS
Document: SAS Companion for UNIX Environments
FDELETE("fileref")
Deletes an external file or an empty directory.
Product: Base SAS
Document: SAS Companion for Windows
FDELETE (fileref)
Deletes an external file or an empty directory.
Product: Base SAS
Document: SAS Companion for z/OS
FETCH(data-set-id <, 'NOSET'>)
Reads the next non-deleted observation from a SAS data set into the Data Set Data Vector (DDV).
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FETCHOBS(data-set-id, observation-number <, options>)
Reads a specified observation from a SAS data set into the Data Set Data Vector (DDV).
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FEXIST(fileref)
Verifies the existence of an external file that is associated with a fileref.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FEXIST(<">fileref<">)
Verifies the existence of an external file that is associated with a fileref.
Product: Base SAS
Document: SAS Companion for UNIX Environments
FEXIST("fileref")
Verifies the existence of an external file by its fileref.
Product: Base SAS
Document: SAS Companion for Windows
FEXIST(fileref)
Verifies the existence of an external file associated with a fileref.
Product: Base SAS
Document: SAS Companion for z/OS
FGET(file-id, variable <, length>)
Copies data from the File Data Buffer (FDB) into a variable.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FILEEXIST(file-name)
Verifies the existence of an external file by its physical name.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FILEEXIST(<">filename<">)
Verifies the existence of an external file by its physical filename.
Product: Base SAS
Document: SAS Companion for UNIX Environments
FILEEXIST("filename")
Verifies the existence of an external file by its physical name.
Product: Base SAS
Document: SAS Companion for Windows
FILEEXIST(filename)
Verifies the existence of an external file by its physical name.
Product: Base SAS
Document: SAS Companion for z/OS
FILENAME(fileref, filename <,device-type> <, 'host-options'>
<, directory-reference>); [Windows, Unix]
FILENAME(fileref,< filename> <device-type> <host-options>; [z/OS]
Assigns or deassigns a fileref to an external file, directory, or output device.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FILENAME(<">fileref<">, <">filename<"> <, device-type <, "host-options" <, directory-reference>>>)
Assigns or deassigns a fileref for an external file, directory, or output device.
Product: Base SAS
Document: SAS Companion for UNIX Environments
FILENAME ("fileref", "filename" <,device-type<,host-options<,dir-ref>>>)
Assigns or deassigns a fileref for an external file, directory, or output device.
Product: Base SAS
Document: SAS Companion for Windows
FILENAME(fileref,filename<,device <,host-options> >)
Assigns or deassigns a fileref for an external file, a directory, or an output device.
Product: Base SAS
Document: SAS Companion for z/OS
FILEREF(fileref)
Verifies whether a fileref has been assigned for the current SAS session.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FILEREF(<">fileref<">)
Verifies whether a fileref has been assigned for the current SAS session.
Product: Base SAS
Document: SAS Companion for UNIX Environments
FILEREF("fileref")
Verifies that a fileref has been assigned for the current SAS session.
Product: Base SAS
Document: SAS Companion for Windows
FILEREF(fileref)
Verifies that a fileref has been assigned for the current SAS session.
Product: Base SAS
Document: SAS Companion for z/OS
FINANCE('ACCRINT', issue, first-interest, settlement, rate, par-value, frequency, [basis]);
Computes the accrued interest for a security that pays periodic interest.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('ACCRINT', issue, first-interest, settlement, rate, par-value, frequency, [basis]);
Computes the accrued interest for a security that pays periodic interest.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('ACCRINT', issue, first-interest, settlement, rate, par-value, frequency, <basis>);
Computes the accrued interest for a security that pays periodic interest.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('ACCRINTM', issue, settlement, rate, par-value, [basis]);
Computes the accrued interest for a security that pays interest at maturity.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('ACCRINTM', issue, settlement, rate, par-value, [basis]);
Computes the accrued interest for a security that pays interest at maturity.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('ACCRINTM', issue, settlement, rate, par-value, <basis>);
Computes the accrued interest for a security that pays interest at maturity.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('AMORDEGRC', cost, date-purchased, first-period, salvage, period, rate, [basis]);
Computes the depreciation for each accounting period by using a depreciation coefficient.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('AMORDEGRC', cost, date-purchased, first-period, salvage, period, rate, [basis]);
Computes the depreciation for each accounting period by using a depreciation coefficient.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('AMORDEGRC', cost, date-purchased, first-period, salvage, period, rate, <basis>);
Computes financial calculations such as depreciation, maturation, accrued interest, net present value, periodic savings, and internal rates of return.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('AMORLINC', cost, date-purchased, first-period, salvage, period, rate, [basis]);
Computes the depreciation for each accounting period.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('AMORLINC', cost, date-purchased, first-period, salvage, period, rate, [basis]);
Computes the depreciation for each accounting period.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('AMORLINC', cost, date-purchased, first-period, salvage, period, rate, <basis>);
Computes the depreciation for each accounting period.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('COUPDAYBS', settlement, maturity, frequency, [basis]);
Computes the number of days from the beginning of the coupon period to the settlement date.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('COUPDAYBS', settlement, maturity, frequency, [basis]);
Computes the number of days from the beginning of the coupon period to the settlement date.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('COUPDAYBS', settlement, maturity, frequency, <basis>);
Computes the number of days from the beginning of the coupon period to the settlement date.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('COUPDAYS', settlement, maturity, frequency, [basis]);
Computes the number of days in the coupon period that contains the settlement date.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('COUPDAYS', settlement, maturity, frequency, [basis]);
Computes the number of days in the coupon period that contains the settlement date.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('COUPDAYS', settlement, maturity, frequency, <basis>);
Computes the number of days in the coupon period that contains the settlement date.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('COUPDAYSNC', settlement, maturity, frequency, [basis]);
Computes the number of days from the settlement date to the next coupon date.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('COUPDAYSNC', settlement, maturity, frequency, [basis]);
Computes the number of days from the settlement date to the next coupon date.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('COUPDAYSNC', settlement, maturity, frequency, <basis>);
Computes the number of days from the settlement date to the next coupon date.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('COUPNCD', settlement, maturity, frequency, [basis]);
Computes the next coupon date after the settlement date.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('COUPNCD', settlement, maturity, frequency, [basis]);
Computes the next coupon date after the settlement date.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('COUPNCD', settlement, maturity, frequency, <basis>);
Computes the next coupon date after the settlement date.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('COUPNUM', settlement, maturity, frequency, [basis]);
Computes the number of coupons that are payable between the settlement date and the maturity date.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('COUPNUM', settlement, maturity, frequency, [basis]);
Computes the number of coupons that are payable between the settlement date and the maturity date.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('COUPNUM', settlement, maturity, frequency, <basis>);
Computes the number of coupons that are payable between the settlement date and the maturity date.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('COUPPCD', settlement, maturity, frequency, [basis]);
Computes the previous coupon date before the settlement date.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('COUPPCD', settlement, maturity, frequency, [basis]);
Computes the previous coupon date before the settlement date.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('COUPPCD', settlement, maturity, frequency, <basis>);
Computes the previous coupon date before the settlement date.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('CUMIPMT', rate, nper, pv, start-period, end-period, [type]);
Computes the cumulative interest paid between two periods.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('CUMIPMT', rate, nper, pv, start-period, end-period, [type]);
Computes the cumulative interest paid between two periods.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('CUMIPMT', rate, nper, pv, start-period, end-period, <type>);
Computes the cumulative interest paid between two periods.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('CUMPRINC', rate, nper, pv, start-period, end-period, [type]);
Computes the cumulative principal that is paid on a loan between two periods.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('CUMPRINC', rate, nper, pv, start-period, end-period, [type]);
Computes the cumulative principal that is paid on a loan between two periods.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('CUMPRINC', rate, nper, pv, start-period, end-period, <type>);
Computes the cumulative principal that is paid on a loan between two periods.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('DB', cost, salvage, life, period, [month]);
Computes the depreciation of an asset for a specified period by using the fixed-declining balance method.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('DB', cost, salvage, life, period, [month]);
Computes the depreciation of an asset for a specified period by using the fixed-declining balance method.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('DB', cost, salvage, life, period, <month>);
Computes the depreciation of an asset for a specified period by using the fixed-declining balance method.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('DDB', cost, salvage, life, period, [factor]);
Computes the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('DDB', cost, salvage, life, period, [factor]);
Computes the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('DDB', cost, salvage, life, period, <factor>);
Computes the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('DISC', settlement, maturity, price, redemption, [basis]);
Computes the discount rate for a security.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('DISC', settlement, maturity, price, redemption, [basis]);
Computes the discount rate for a security.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('DISC', settlement, maturity, price, redemption, <basis>);
Computes the discount rate for a security.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('DOLLARDE', fractional-dollar, fraction);
Converts a dollar price, expressed as a fraction, to a dollar price, expressed as a decimal number.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('DOLLARDE', fractional-dollar, fraction);
Converts a dollar price, expressed as a fraction, to a dollar price, expressed as a decimal number.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('DOLLARDE', fractional-dollar, fraction);
Converts a dollar price, expressed as a fraction, to a dollar price, expressed as a decimal number.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('DOLLARFR', decimal-dollar, fraction);
Converts a dollar price, expressed as a decimal number, to a dollar price, expressed as a fraction.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('DOLLARFR', decimal-dollar, fraction);
Converts a dollar price, expressed as a decimal number, to a dollar price, expressed as a fraction.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('DOLLARFR', decimal-dollar, fraction);
Converts a dollar price, expressed as a fraction, to a dollar price, expressed as a decimal number.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('DURATION', settlement, maturity, coupon, yield, frequency, [basis]);
Computes the annual duration of a security with periodic interest payments.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('DURATION', settlement, maturity, coupon, yield, frequency, [basis]);
Computes the annual duration of a security with periodic interest payments.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('DURATION', settlement, maturity, coupon, yield, frequency, <basis>);
Computes the annual duration of a security with periodic interest payments.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('EFFECT', nominal-rate, npery);
Computes the effective annual interest rate.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('EFFECT', nominal-rate, npery);
Computes the effective annual interest rate.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('EFFECT', nominal-rate, npery);
Computes the effective annual interest rate.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE(string-identifier, parameter–1, parameter–2, …)
Computes financial calculations such as depreciation, maturation, accrued interest, net present value, periodic savings, and internal rates of return.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE(string-identifier, parameter–1, parameter–2, …)
Computes financial calculations such as depreciation, maturation, accrued interest, net present value, periodic savings, and internal rates of return.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE(string-identifier, parameter–1, parameter–2, …)
Computes financial calculations such as depreciation, maturation, accrued interest, net present value, periodic savings, and internal rates of return.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('FV', rate, nper, [payment], [present-value], [type]);
Computes the future value of an investment.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('FV', rate, nper, [payment], [present-value], [type]);
Computes the future value of an investment.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('FV', rate, nper, <payment>, <present-value>, <type>);
Computes the future value of an investment.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('FVSCHEDULE', principal, schedule-1, schedule-2 ...);
Computes the future value of the initial principal after applying a series of compound interest rates.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('FVSCHEDULE', principal, schedule-1, schedule-2 ...);
Computes the future value of the initial principal after applying a series of compound interest rates.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('FVSCHEDULE', principal, schedule-1, schedule-2 ...);
Computes the future value of the initial principal after applying a series of compound interest rates.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('INTRATE', settlement, maturity, investment, redemption, [basis]);
Computes the interest rate for a fully invested security.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('INTRATE', settlement, maturity, investment, redemption, [basis]);
Computes the interest rate for a fully invested security.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('INTRATE', settlement, maturity, investment, redemption, <basis>);
Computes the interest rate for a fully invested security.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('IPMT', rate, period, nper, pv, [fv], [type]);
Computes the interest payment for an investment for a specified period.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('IPMT', rate, period, nper, pv, [fv], [type]);
Computes the interest payment for an investment for a specified period.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('IPMT', rate, period, nper, pv, <fv>, <type>);
Computes the interest payment for an investment for a specified period.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('IRR', value-1, value-2, …, value-n);
Computes the internal rate of return for a series of cash flows.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('IRR', value-1, value-2, …, value-n);
Computes the internal rate of return for a series of cash flows.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('IRR', value-1, value-2, …, value-n);
Computes the internal rate of return for a series of cash flows.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('ISPMT', interest-rate, period, number-payments, pv);
Calculates the interest paid during a specific period of an investment.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('ISPMT', interest-rate, period, number-payments, pv);
Calculates the interest paid during a specific period of an investment.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('ISPMT', interest-rate, period, number-payments, pv);
Calculates the interest paid during a specific period of an investment.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('MDURATION', settlement, maturity, coupon, yield, frequency, [basis]);
Computes the Macaulay modified duration for a security with an assumed face value of $100.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('MDURATION', settlement, maturity, coupon, yield, frequency, [basis]);
Computes the Macaulay modified duration for a security with an assumed face value of $100.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('MDURATION', settlement, maturity, coupon, yield, frequency, <basis>);
Computes the Macaulay modified duration for a security with an assumed face value of $100.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('MIRR', value-1, …, value-n, finance-rate, reinvest-rate);
Computes the internal rate of return where positive and negative cash flows are financed at different rates.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('MIRR', value-1, …, value-n, finance-rate, reinvest-rate);
Computes the internal rate of return where positive and negative cash flows are financed at different rates.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('MIRR', value-1, …, value-n,finance-rate, reinvest-rate);
Computes the internal rate of return where positive and negative cash flows are financed at different rates.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('NOMINAL', effective-rate, npery);
Computes the annual nominal interest rates.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('NOMINAL', effective-rate, npery);
Computes the annual nominal interest rates.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('NOMINAL', effective-rate, npery);
Computes the annual nominal interest rates.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('NPER', rate, payment, pv, [fv], [type]);
Computes the number of periods for an investment.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('NPER', rate, payment, pv, [fv], [type]);
Computes the number of periods for an investment.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('NPER', rate, payment, pv, <fv>, <type>);
Computes the number of periods for an investment.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('NPV', rate, value-1, [, ... value-n]);
Computes the net present value of an investment based on a series of periodic cash flows and a discount rate.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('NPV', rate, value-1, [, ... value-n]);
Computes the net present value of an investment based on a series of periodic cash flows and a discount rate.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('NPV', rate, value-1, <, …, value-n>);
Computes the net present value of an investment based on a series of periodic cash flows and a discount rate.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('ODDFPRICE', settlement, maturity, issue, first-coupon, rate, yield,
redemption, frequency, [basis]);
Computes the price of a security per $100 face value with an odd first period.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('ODDFPRICE', settlement, maturity, issue, first-coupon, rate, yield,
redemption, frequency, [basis]);
Computes the price of a security per $100 face value with an odd first period.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('ODDFPRICE', settlement, maturity, issue, first-coupon, rate, yield,
redemption,frequency, <basis>);
Computes the price of a security per $100 face value with an odd first period.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('ODDFYIELD', settlement, maturity, issue, first-coupon, rate, price,
redemption, frequency, [basis]);
Computes the yield of a security with an odd first period.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('ODDFYIELD', settlement, maturity, issue, first-coupon, rate, price,
redemption, frequency, [basis]);
Computes the yield of a security with an odd first period.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('ODDFYIELD', settlement, maturity, issue, first-coupon, rate, price,
redemption,frequency, <basis>);
Computes the yield of a security with an odd first period.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('ODDLPRICE', settlement, maturity, last-interest, rate, yield,
redemption, frequency, [basis]);
Computes the price of a security per $100 face value with an odd last period.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('ODDLPRICE', settlement, maturity, last-interest, rate, yield,
redemption, frequency, [basis]);
Computes the price of a security per $100 face value with an odd last period.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('ODDLPRICE', settlement, maturity, last-interest, rate, yield,
redemption,frequency, <basis>);
Computes the price of a security per $100 face value with an odd last period.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('ODDLYIELD', settlement, maturity, last-interest, rate, price,
redemption, frequency, [basis]);
Computes the yield of a security with an odd last period.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('ODDLYIELD', settlement, maturity, last-interest, rate, price,
redemption, frequency, [basis]);
Computes the yield of a security with an odd last period.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('ODDLYIELD', settlement, maturity, last-interest, rate, price,
redemption,frequency, <basis>);
Computes the yield of a security with an odd last period.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('PMT', rate, nper, pv, [fv], [type]);
Computes the periodic payment of an annuity.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('PMT', rate, nper, pv, [fv], [type]);
Computes the periodic payment of an annuity.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('PMT', rate, nper, pv, <fv>, <type>);
Computes the periodic payment of an annuity.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('PPMT', rate, period, nper, pv, [fv], [type]);
Computes the payment on the principal for an investment for a specified period.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('PPMT', rate, period, nper, pv, [fv], [type]);
Computes the payment on the principal for an investment for a specified period.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('PPMT', rate, period, nper, pv, <fv>, <type>);
Computes the payment on the principal for an investment for a specified period.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('PRICE', settlement, maturity, rate, yield, redemption, frequency, [basis]);
Computes the price of a security per $100 face value that pays periodic interest.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('PRICE', settlement, maturity, rate, yield, redemption, frequency, [basis]);
Computes the price of a security per $100 face value that pays periodic interest.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('PRICE', settlement, maturity, rate, yield,
redemption,frequency, <basis>);
Computes the price of a security per $100 face value that pays periodic interest.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('PRICEDISC', settlement, maturity, discount, redemption, [basis]);
Computes the price of a discounted security per $100 face value.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('PRICEDISC', settlement, maturity, discount, redemption, [basis]);
Computes the price of a discounted security per $100 face value.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('PRICEDISC', settlement, maturity, discount, redemption, <basis>);
Computes the price of a discounted security per $100 face value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('PRICEMAT', settlement, maturity, issue, rate, yield, [basis]);
Computes the price of a security per $100 face value that pays interest at maturity.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('PRICEMAT', settlement, maturity, issue, rate, yield, [basis]);
Computes the price of a security per $100 face value that pays interest at maturity.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('PRICEMAT', settlement, maturity, issue, rate,
yield,<basis>);
Computes the price of a security per $100 face value that pays interest at maturity.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('PV', rate, nper, payment, [fv], [type]);
Computes the present value of an investment.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('PV', rate, nper, payment, [fv], [type]);
Computes the present value of an investment.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('PV', rate, nper, payment, <fv>, <type>);
Computes the present value of an investment.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('RATE', nper, payment, pv, [fv], [type]);
Computes the interest rate per period of an annuity.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('RATE', nper, payment, pv, [fv], [type]);
Computes the interest rate per period of an annuity.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('RATE', nper, payment, pv, <fv>, <type>);
Computes the interest rate per period of an annuity.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('RECEIVED', settlement, maturity, investment, discount, [basis]);
Computes the amount that is received at maturity for a fully invested security.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('RECEIVED', settlement, maturity, investment, discount, [basis]);
Computes the amount that is received at maturity for a fully invested security.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('RECEIVED', settlement, maturity, investment, discount, <basis>);
Computes the amount that is received at maturity for a fully invested security.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('SLN', cost, salvage, life);
Computes the straight-line depreciation of an asset for one period.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('SLN', cost, salvage, life);
Computes the straight-line depreciation of an asset for one period.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('SLN', cost, salvage, life);
Computes the straight-line depreciation of an asset for one period.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('SYD', cost, salvage, life, period);
Computes the sum-of-years digits depreciation of an asset for a specified period.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('SYD', cost, salvage, life, period);
Computes the sum-of-years digits depreciation of an asset for a specified period.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('SYD', cost, salvage, life, period);
Computes the sum-of-years digits depreciation of an asset for a specified period.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('TBILLEQ', settlement, maturity, discount);
Computes the bond-equivalent yield for a treasury bill.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('TBILLEQ', settlement, maturity, discount);
Computes the bond-equivalent yield for a treasury bill.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('TBILLEQ', settlement, maturity, discount);
Computes the bond-equivalent yield for a treasury bill.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('TBILLPRICE', settlement, maturity, discount);
Computes the price of a treasury bill per $100 face value.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('TBILLPRICE', settlement, maturity, discount);
Computes the price of a treasury bill per $100 face value.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('TBILLPRICE', settlement, maturity, discount);
Computes the price of a treasury bill per $100 face value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('TBILLYIELD', settlement, maturity, price);
Computes the yield for a treasury bill.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('TBILLYIELD', settlement, maturity, price);
Computes the yield for a treasury bill.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('TBILLYIELD', settlement, maturity, price);
Computes the yield for a treasury bill.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('VDB', cost, salvage, life, start-period, end-period, [factor], [noswitch]);
Computes the depreciation of an asset for a specified or partial period by using a declining balance method.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('VDB', cost, salvage, life, start-period, end-period, [factor], [noswitch]);
Computes the depreciation of an asset for a specified or partial period by using a declining balance method.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('VDB', cost, salvage, life, start-period, end-period, <factor>, <noswitch>);
Computes the depreciation of an asset for a specified or partial period by using a declining balance method.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('XIRR', values, dates, [guess]);
Computes the internal rate of return for a schedule of cash flows that is not necessarily periodic.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('XIRR', values, dates, [guess]);
Computes the internal rate of return for a schedule of cash flows that is not necessarily periodic.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('XIRR', values, dates, <guess>);
Computes the internal rate of return for a schedule of cash flows that is not necessarily periodic.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('XNPV', rate, values, dates);
Computes the net present value for a schedule of cash flows that is not necessarily periodic.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('XNPV', rate, values, dates);
Computes the net present value for a schedule of cash flows that is not necessarily periodic.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('XNPV', rate, values, dates);
Computes the net present value for a schedule of cash flows that is not necessarily periodic.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('YIELD', settlement, maturity, rate, price, redemption, frequency, [basis]);
Computes the yield on a security that pays periodic interest.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('YIELD', settlement, maturity, rate, price, redemption, frequency, [basis]);
Computes the yield on a security that pays periodic interest.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('YIELD', settlement, maturity, rate, price,
redemption,frequency, <basis>);
Computes the yield on a security that pays periodic interest.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('YIELDDISC', settlement, maturity, price, redemption, [basis]);
Computes the annual yield for a discounted security (for example, a treasury bill).
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('YIELDDISC', settlement, maturity, price, redemption, [basis]);
Computes the annual yield for a discounted security (for example, a treasury bill).
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('YIELDDISC', settlement, maturity, price,
redemption, <basis>);
Computes the annual yield for a discounted security (for example, a treasury bill).
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINANCE('YIELDMAT', settlement, maturity, issue, rate, price, [basis]);
Computes the annual yield of a security that pays interest at maturity.
Product: Base SAS
Document: SAS DS2 Language Reference
FINANCE('YIELDMAT', settlement, maturity, issue, rate, price, [basis]);
Computes the annual yield of a security that pays interest at maturity.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FINANCE('YIELDMAT', settlement, maturity, issue, rate, price, <basis>);
Computes the annual yield of a security that pays interest at maturity.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FIND(string, substring[, modifier(s)][, startpos])
FIND(string, substring[, startpos][, modifier(s)])
Searches for a specific substring of characters within a character string.
Product: Base SAS
Document: SAS DS2 Language Reference
FIND(string, substring <, modifier(s)> <, start-position>)
FIND(string, substring <, start-position> <, modifier(s)>)
Searches for a specific substring of characters within a character string.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINDC(string[, charlist])
FINDC(string, charlist[, modifier])
FINDC(string, charlist, modifier[, startpos])
FINDC(string, charlist[, startpos][, modifier])
Searches a string for any character in a list of characters.
Product: Base SAS
Document: SAS DS2 Language Reference
FINDC(string <, character-list>)
FINDC(string, character-list <, modifier(s)>)
FINDC(string, character-list, modifier(s) <, start-position>)
FINDC(string, character-list, <start-position>, <modifier(s)>)
Searches a string for any character in a list of characters.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINDW(string, word[, chars])
FINDW(string, word, chars, modifier(s)[, startpos])
FINDW(string, word, chars, startpos[, modifier(s)])
FINDW(string, word, startpos[, chars[, modifier(s)]])
Returns the character position of a word in a string, or returns the number of the word in a string.
Product: Base SAS
Document: SAS DS2 Language Reference
FINDW(string, word <, character(s)>)
FINDW(string, word, character(s), modifier(s) <, start-position>)
FINDW(string, word, character(s), start-position <, modifier(s)>)
FINDW(string, word, start-position <, character(s) <, modifier(s)>>)
Returns the character position of a word in a string, or returns the number of the word in a string.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINFO(file-id, information-item)
Returns the value of a file information item.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FINFO(file-id, <">information-item<">)
Returns the value of a file information item for an external file.
Product: Base SAS
Document: SAS Companion for UNIX Environments
FINFO(file-id, info-item)
Returns the value of an information item for an external file.
Product: Base SAS
Document: SAS Companion for Windows
FINFO(file-id,info-item)
Returns the value of a file information item for an external file.
Product: Base SAS
Document: SAS Companion for z/OS
FINV (p, ndf, ddf <, nc>)
Returns a quantile from the F distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FIPNAME(expression)
Converts two-digit FIPS codes to uppercase state names.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FIPNAMEL(expression)
Converts two-digit FIPS codes to mixed case state names.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FIPSTATE(expression)
Converts two-digit FIPS codes to two-character state postal codes.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FIRST(string)
Returns the first character in a character string.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FLOOR(expression)
Returns the largest integer less than or equal to a numeric value expression.
Product: Base SAS
Document: SAS DS2 Language Reference
FLOOR(expression)
Returns the largest integer less than or equal to a numeric value expression.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FLOOR(argument)
Returns the largest integer that is less than or equal to the argument, fuzzed to avoid unexpected floating-point results.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FLOORZ(expression)
Returns the largest integer that is less than or equal to the argument, using zero fuzzing.
Product: Base SAS
Document: SAS DS2 Language Reference
FLOORZ(expression)
Returns the largest integer that is less than or equal to the argument, using zero fuzzing.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FLOORZ(argument)
Returns the largest integer that is less than or equal to the argument, using zero fuzzing.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FMTINFO('format-name', 'information-type');
Returns information about a SAS format or informat.
Product: Base SAS
Document: SAS DS2 Language Reference
FMTINFO('format-name', 'information-type');
Returns information about a SAS format or informat.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FMTINFO(fmtname, info)
Retrieves information about a format or informat.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FNONCT(x, ndf, ddf, probability)
Returns the value of the noncentrality parameter of an F distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
FNONCT(x, ndf, ddf, probability)
Returns the value of the noncentrality parameter of an F distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FNONCT(x, ndf, ddf, probability)
Returns the value of the noncentrality parameter of an F distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FNOTE(file-id)
Identifies the last record that was read, and returns a value that the FPOINT function can use.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FOPEN(fileref <, open-mode <, record-length <, record-format>>>)
Opens an external file and returns a file identifier value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FOPEN(fileref<,open-mode <,record-length <,record-format> > >)
Opens an external file and returns a file identifier value.
Product: Base SAS
Document: SAS Companion for z/OS
FOPTNAME(file-id, nval)
Returns the name of an item of information about an external file.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FOPTNAME(file-id, nval)
Returns the name of an item of information about an external file.
Product: Base SAS
Document: SAS Companion for UNIX Environments
FOPTNAME(file-id, nval)
Returns the name of an information item for an external file.
Product: Base SAS
Document: SAS Companion for Windows
FOPTNAME(file-id,nval)
Returns the name of an information item for an external file.
Product: Base SAS
Document: SAS Companion for z/OS
FOPTNUM(file-id)
Returns the number of information items, such as filename or record length, that are available for an external file.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FOPTNUM(file-id)
Returns the number of information items that are available for an external file.
Product: Base SAS
Document: SAS Companion for UNIX Environments
FOPTNUM(file-id)
Returns the number of information items that are available for a file.
Product: Base SAS
Document: SAS Companion for Windows
FOPTNUM(file-id)
Returns the number of information items that are available for an external file.
Product: Base SAS
Document: SAS Companion for z/OS
FPOINT(file-id, note-id)
Positions the read pointer on the next record to be read.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FPOS(file-id, nval)
Sets the position of the column pointer in the File Data Buffer (FDB).
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FPUT(file-id, cval)
Moves data to the File Data Buffer (FDB) of an external file, starting at the FDB's current column position.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FREAD(file-id)
Reads a record from an external file into the File Data Buffer (FDB).
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FREWIND(file-id)
Positions the file pointer to the start of the file.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FRLEN(file-id)
Returns the size of the last record that was read, or, if the file is opened for output, returns the current record size.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FSEP(file-id, character(s) <, 'x' | 'X'>)
Sets the token delimiters for the FGET function.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FUZZ(expression)
Returns the nearest whole number if the argument is within 1E-12 of that number.
Product: Base SAS
Document: SAS DS2 Language Reference
FUZZ(expression)
Returns the nearest whole number if the argument is within 1E-12 of that number.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
FUZZ(argument)
Returns the nearest integer if the argument is within 1E−12 of that integer.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
FWRITE(file-id <, cc>)
Writes a record to an external file.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GAMINV(p, a)
Returns a quantile from the gamma distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
GAMINV(p, a)
Returns a quantile from the gamma distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
GAMINV(p, a)
Returns a quantile from the gamma distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GAMMA(expression)
Returns the value of the gamma function.
Product: Base SAS
Document: SAS DS2 Language Reference
GAMMA(expression)
Returns the value of the gamma function.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
GAMMA(argument)
Returns the value of the gamma function.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GARKHCLPRC(E, t, S, Rd, Rf, sigma)
Calculates call prices for European options on stocks, based on the Garman-Kohlhagen model.
Product: Base SAS
Document: SAS DS2 Language Reference
GARKHCLPRC(E, t, S, Rd, Rf, sigma)
Calculates call prices for European options on stocks, based on the Garman-Kohlhagen model.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
GARKHCLPRC(E, t, S, Rd, Rf, sigma)
Calculates call prices for European options on stocks, based on the Garman-Kohlhagen model.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GARKHPTPRC(E, t, S, Rd, Rf, sigma)
Calculates put prices for European options on stocks, based on the Garman-Kohlhagen model.
Product: Base SAS
Document: SAS DS2 Language Reference
GARKHPTPRC(E, t, S, Rd, Rf, sigma)
Calculates put prices for European options on stocks, based on the Garman-Kohlhagen model.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
GARKHPTPRC(E, t, S, Rd, Rf, sigma)
Calculates put prices for European options on stocks, based on the Garman-Kohlhagen model.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GCD(expression-1, expression-2 [, ...expression-n])
Returns the greatest common divisor for a set of integers.
Product: Base SAS
Document: SAS DS2 Language Reference
GCD(expression-1, expression-2 [, ...expression-n])
Returns the greatest common divisor for a set of integers.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
GCD(x1, x2, x3, …, xn)
Returns the greatest common divisor for one or more integers.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GEODIST(latitude-1, longitude-1, latitude-2, longitude-2 [,options])
Returns the geodetic distance between two latitude and longitude coordinates.
Product: Base SAS
Document: SAS DS2 Language Reference
GEODIST(latitude-1, longitude-1, latitude-2, longitude-2 <, options>)
Returns the geodetic distance between two latitude and longitude coordinates.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GEOMEAN(expression [, ...expression])
Returns the geometric mean.
Product: Base SAS
Document: SAS DS2 Language Reference
GEOMEAN(expression [, ...expression])
Returns the geometric mean.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
GEOMEAN(argument <, argument, ...>)
Returns the geometric mean.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GEOMEANZ(expression [, ...expression])
Returns the geometric mean, using zero fuzzing.
Product: Base SAS
Document: SAS DS2 Language Reference
GEOMEANZ(expression [, ...expression])
Returns the geometric mean, using zero fuzzing.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
GEOMEANZ(argument <, argument, ...>)
Returns the geometric mean, using zero fuzzing.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GETCASURL(<session>)
Returns the value for a URL for connecting to the CAS Server Monitor.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
GETLCASLIB(libref)
Returns the caslib that was bound to a CAS LIBNAME engine libref using the CASLIB= option when it was assigned.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
GETLOCENV( )
Returns the current locale/language environment.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
GETLSESSREF (libref)
Returns the session reference that is associated with a CAS LIBNAME engine libref.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
GETLTAG(libref)
Returns the tag that was associated with a CAS LIBNAME engine libref in the TAG= option when it is assigned.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
GETOPTION(option-name <, return-value-option> <return-value-formatting-options>)
Returns the value of a SAS system or graphics option.
Product: Base SAS
Document: SAS System Options: Reference
GETPXLANGUAGE()
Returns the current two-letter language code.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
GETPXLOCALE(<source>)
Returns the POSIX locale value for a SAS locale.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
GETPXREGION()
Returns the current two-letter region code.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
GETSESSOPT(session-name, session-option-name)
GETSESSOPT(uuid, session-option-name)
Returns the value for a SAS Cloud Analytic Services session option.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
GETVARC(data-set-id, variable-number)
Returns the value of a SAS data set character variable.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GETVARN(data-set-id, variable-number)
Returns the value of a SAS data set numeric variable.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GIT_BRANCH_CHKOUT( 'directory', 'branch')
Check out a branch in a Git repository.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GIT_BRANCH_DELETE( 'directory', 'branch-name'<, remote>)
Deletes a Git branch in the repository.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GIT_BRANCH_MERGE( 'directory', 'branch-name', 'author-name', 'author-email'<, remote>)
Merges a Git branch into the currently checked-out branch.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GIT_BRANCH_NEW( 'directory', 'commit-ID', 'branch-name', force)
Creates a Git branch.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GIT_CLONE ('uri', 'directory'<, 'user', 'password | personal access token'> <, '', '', 'SSL-CA-certificate-path'>)
GIT_CLONE ('uri', 'directory','user', 'password', 'ssh-public-key-path', 'ssh-private-key-path')
GIT_CLONE('uri', 'directory', '', '''SSL-CA-certificate-path' | '', kerberos)
Clones a Git repository into a directory on the SAS server.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GIT_COMMIT( 'directory', 'update-reference', 'author-name', 'author-email', 'commit-message')
Commits staged files to the local repository.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GIT_COMMIT_FREE( 'directory')
Clears the commit record object that was created by GIT_COMMIT_LOG for the specified repository.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GIT_COMMIT_GET( n, 'directory', 'attribute', attribute-out)
Returns the specified attribute of the nth commit object that is associated with the local repository.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GIT_COMMIT_LOG( 'directory')
Returns the number of commit objects that are associated with the local repository.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GIT_DELETE_REPO('directory')
Deletes a local Git repository and all content within the repository.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GIT_DIFF( 'directory', 'older-commit-ID', 'newer-commit-ID')
Returns the number of diffs between two commits in the local repository and creates a diff record object for the local repository.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GIT_DIFF_FILE_IDX( 'directory', 'file-name', diff-content<, staged, 'output-file-path'>)
Returns the diff for a file in the index.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GIT_DIFF_FREE( 'directory', 'older-commit', 'newer-commit')
Clears the diff record object associated with a local repository.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GIT_DIFF_GET( n, 'directory', 'older-commit-ID', 'newer-commit-ID' 'attribute', 'attribute-out')
Returns the specified attribute of the nth diff object in the local repository.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GIT_DIFF_TO_FILE(n, 'directory', 'older-commit-ID', 'newer-commit-ID', 'file-reference')
Writes the diff content to a file reference.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GIT_FETCH( 'directory', 'user', 'password', 'ssh-public-key-path', 'ssh-private-key-path'<, 'target-branch', 'SSL-certificate-path' | '' kerberos>)
Fetches updates from the remote repository.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GIT_INDEX_ADD( 'directory', 'file-1', 'status-1' < , ... ,'file-n', 'status-n' >)
Stages 1 to n number of files to commit to the local repository.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GIT_INDEX_REMOVE( 'directory', 'file-1' < , ..., 'file-n' >)
Unstages 1 to n number of files to commit to the local repository.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GIT_INIT_REPO('directory'<, 'remote-URL'>)
Initializes a new local Git repository.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GIT_PULL( 'directory')
GIT_PULL( 'directory', 'user', 'password' <, '', '', 'SSL-certificate-path'>)
GIT_PULL( 'directory', 'ssh-user', 'ssh-password', 'ssh-public-key', 'ssh-private-key')
GIT_PULL('directory', '', '', '', '', 'SSL-certificate-path' | '', kerberos)
Pulls changes from the remote repository into the local repository.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GIT_PUSH( 'directory')
GIT_PUSH( 'directory', 'user', 'password' <, '', '', 'SSL-certificate-path'>)
GIT_PUSH( 'directory', 'ssh-user', 'ssh-password', 'ssh-public-key', 'ssh-private-key')
GIT_PUSH('directory', '', '', '', '', 'SSL-certificate-path' | '', kerberos)
Pushes the committed files in the local repository to the remote repository.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GIT_REBASE( 'directory', 'current-branch-commit-ID', 'rebase-commit-ID', 'name', 'email')
Rebases your current branch to a specified commit ID.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GIT_REBASE_OP( 'directory', 'operation', 'branch-name', 'name', 'email')
Used to execute rebase operations when a conflict occurs.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GIT_RESET( 'directory', 'commit-ID', 'reset_type')
Resets the local repository to a specified commit.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GIT_RESET_FILE( 'directory', 'file-name')
Resets a file in the index to the local repository version.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GIT_SET_URL( 'directory', 'URL')
Sets the remote repository URL for a local repository.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GIT_STASH('directory', 'name', 'email');
Stashes file changes that have not been committed.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GIT_STASH_APPLY('directory'<, stash-index>)
Applies file changes that are stored in a stash to the local repository.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GIT_STASH_DROP('directory'<, stash-index>)
Drops the contents of the stash stack at the specified index.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GIT_STASH_POP('directory')
Applies the changes that are stored in the stash, and then drops the contents of the stash.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GIT_STATUS("directory")
Returns the status objects for files in the local repository and creates a status record.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GIT_STATUS_FREE ("directory" )
Clears the status record object that was created by GIT_STATUS for the specified repository.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GIT_STATUS_GET(n, 'directory', 'attribute', attribute-store)
Returns the specified attribute of the nth status object returned from GITFN_STATUS() in the local repository.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GIT_VERSION()
Specifies whether libgit2 is available and if available, specifies the version that is being used.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GITFN_CLONE ("uri", "directory")
GITFN_CLONE ("uri", "directory", <"user", "password", "ssh-public-key", "ssh-private-key")>
Clones a Git repository into a directory on the SAS server.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GITFN_CO_BRANCH( "directory", "branch")
Check out a branch in a Git repository.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GITFN_COMMIT( "directory", "update-ref", "author-name", "author-email", "commit-message")
Commits staged files to the local repository.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GITFN_COMMIT_GET( n, "directory", "attribute", attribute-out)
Returns the specified attribute of the nth commit object that is associated with the local repository.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GITFN_COMMIT_LOG( "directory")
Returns the number of commit objects that are associated with the local repository.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GITFN_COMMITFREE( "directory")
Clears the commit record object that was created by GITFN_COMMIT_LOG for the specified repository.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GITFN_DEL_BRANCH( "directory", "branch-name")
Deletes a Git branch in the repository.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GITFN_DEL_REPO( "directory")
Deletes a local Git repository and its contents.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GITFN_DIFF( "directory", "older-commit-ID", "newer-commit-ID")
Returns the number of diffs between two commits in the local repository and creates a diff record object for the local repository.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GITFN_DIFF_FREE( "directory", "older-commit", "newer-commit")
Clears the diff record object associated with a local repository.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GITFN_DIFF_GET( n, "directory", "attribute", "attribute-out")
Returns the specified attribute of the nth diff object in the local repository.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GITFN_DIFF_IDX_F( "directory", "file-name", diff-content)
Returns the changes for a file in the index.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GITFN_IDX_ADD( "directory", "file-1", "status-1" <, ... ,"file-n", "status-n">)
Stages 1 to n number of files to commit to the local repository.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GITFN_IDX_REMOVE( "directory", "file-1" <, ..., "file-n">)
Unstages 1 to n number of files to commit to the local repository.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GITFN_MRG_BRANCH( "directory", "branch-name", "author-name", "author-email")
Merges a Git branch into the currently checked-out branch.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GITFN_NEW_BRANCH( "directory", "commit-ID", "branch-name", force)
Creates a Git branch.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GITFN_PULL( "directory")
GITFN_PULL( "directory", "user", "password")
GITFN_PULL( "directory", "ssh-user", "ssh-password", "ssh-public-key", "ssh-private-key")
Pulls changes from the remote repository into the local repository.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GITFN_PUSH( "directory")
GITFN_PUSH( "directory", "user", "password")
GITFN_PUSH( "directory", "ssh-user", "ssh-password", "ssh-public-key", "ssh-private-key")
Pushes the committed files in the local repository to the remote repository.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GITFN_RESET( "directory", "commit-ID", "reset_type")
Resets the local repository to a specified commit.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GITFN_RESET_FILE( "directory", "file-name")
Resets a file in the index to the local repository version.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GITFN_STATUS("directory")
Returns the status objects for files in the local repository and creates a status record.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GITFN_STATUS_GET(n, "directory", "attribute", attribute-store)
Returns the specified attribute of the nth status object returned from GITFN_STATUS() in the local repository.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GITFN_STATUSFREE ( directory )
Clears the status record object that was created by GITFN_STATUS for the specified repository.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GITFN_VERSION()
Specifies whether libgit2 is available and if available, specifies the version that is being used.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
GRAYCODE(k, numeric-variable-1, ..., numeric-variable-n)
GRAYCODE(k, character-variable <, n <, in-out>>)
Generates all subsets of n items in a minimal change order.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
grdsvc_enable(identifier <,option-1; ... option-n> )
grdsvc_enable(identifier,"" | " )
Enables or disables one or all SAS sessions on a grid.
Product: SAS Grid Computing
Document: Grid Computing in SAS
grdsvc_getaddr(identifier)
Reports the IP address of the grid node on which the SAS session was chosen to execute.
Product: SAS Grid Computing
Document: Grid Computing in SAS
grdsvc_getinfo(identifier)
Reports information about the grid environment.
Product: SAS Grid Computing
Document: Grid Computing in SAS
grdsvc_getname(identifier)
Reports the name of the grid node on which the SAS grid server session was chosen to execute.
Product: SAS Grid Computing
Document: Grid Computing in SAS
grdsvc_hostlist(‘SERVER=SAS-application-server;
HOSTLIST=grid_host_machine,[grid_host_machine] |
WORKLOAD=workload-value ||
CLIENTAPP=”client_application” |
GRIDOPTSET=”grid_options_set_name”;’)
Returns a list of hosts that are available to run grid jobs. The list is ordered according to the priority set by the grid provider.
Product: SAS Grid Computing
Document: Grid Computing in SAS
grdsvc_nnodes(argument;option)
Reports the total number of job slots that are available for use on a grid.
Product: SAS Grid Computing
Document: Grid Computing in SAS
grdsvc_optsets(“SERVER=SAS-application-server;CLIENTAPP=’SAS-client-application’;
USER=’user-ID’;”)
Returns a list of valid options sets for a specified combination of SAS Application Server, SAS client application, and user. If the user is not specified, the function returns a list of all valid grid options sets that apply to the specified SAS client application.
Product: SAS Grid Computing
Document: Grid Computing in SAS
HARMEAN(expression [, ...expression])
Returns the harmonic mean.
Product: Base SAS
Document: SAS DS2 Language Reference
HARMEAN(expression [, ...expression])
Returns the harmonic mean.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
HARMEAN(argument <, argument, ...>)
Returns the harmonic mean.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
HARMEANZ(expression [, ...expression])
Returns the harmonic mean, using zero fuzzing.
Product: Base SAS
Document: SAS DS2 Language Reference
HARMEANZ(expression [, ...expression])
Returns the harmonic mean, using zero fuzzing.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
HARMEANZ(argument <, argument, ...>)
Returns the harmonic mean, using zero fuzzing.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
HASHING(method, message, <flag>);
Returns a message digest as a hexadecimal string for a message consisting of a character string, using different methods.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
HASHING_FILE(method, file, <flag>);
Returns a message digest as a hexadecimal string for a message consisting of an entire file, using different hashing methods.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
HASHING_HMAC(method, key, message, <flag>);
Returns a message digest as a hexadecimal string for a character HMAC key value and a message consisting of a character string, using different methods.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
HASHING_HMAC_FILE(method, key, file, <flag>);
Returns a message digest as a hexadecimal string for an HMAC key value consisting of a character string and a message consisting of an entire file, using different methods.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
handle=HASHING_HMAC_INIT(method, key, <flag>);
Initializes a running HMAC hash and returns a numeric handle for use with HASHING_PART and HASHING_TERM.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
handle=HASHING_INIT(method);
Initializes a running hash and returns a numeric handle for use with HASHING_PART and HASHING_TERM.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
HASHING_PART(handle, message_part, <flag>);
Provides part of a message for a running hash and returns a numeric value of 1 for a valid handle.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
HASHING_TERM(handle);
Returns the final digest in hexadecimal representation for the running hash.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
HBOUND(array-name[, bound-n])
Returns the upper bound of an array.
Product: Base SAS
Document: SAS DS2 Language Reference
HBOUND<n> (array-name)
HBOUND(array-name, bound-n)
Returns the upper bound of an array.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
HMS(hour, minute, second)
Returns a SAS time value from hour, minute, and second values.
Product: Base SAS
Document: SAS DS2 Language Reference
HMS(hour, minute, second)
Returns a SAS time value from hour, minute, and second values.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
HMS(hour, minute, second)
Returns a SAS time value from hour, minute, and second values.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
HOLIDAY('holiday', year)
Returns a SAS date value of a specified holiday for a specified year.
Product: Base SAS
Document: SAS DS2 Language Reference
HOLIDAY('holiday', year)
Returns a SAS date value of a specified holiday for a specified year.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
HOLIDAY('holiday', year)
Returns a SAS date value of a specified holiday for a specified year.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
HOLIDAYCK('holiday',date1, date2 <,'locale'>)
Returns the number of occurrences of the holiday value between date1 and date2.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
HOLIDAYCOUNT(date<,'locale'>)
Returns the number of holidays defined for a SAS date value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
HOLIDAYNAME(date<,n<,'locale'>>)
Returns the name of the holiday that corresponds to the SAS date or a blank string if a holiday is not defined for the SAS date.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
HOLIDAYNX('holiday',date<,n<,'locale'>>)
Returns the nth occurrence of the holiday relative to the date argument.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
HOLIDAYNY('holiday',year<,n<,'locale'>>)
Returns the nth occurrence of the holiday for the year.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
HOLIDAYTEST('holiday',date<,'locale'>)
Returns 1 if the holiday occurs on the SAS date value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
HOUR(time | datetime)
Returns the hour from a SAS time or datetime value.
Product: Base SAS
Document: SAS DS2 Language Reference
HOUR(time | datetime)
Returns the hour from a time or datetime value.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
HOUR(time | datetime)
Returns the hour from a SAS time or datetime value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
HTMLDECODE(expression)
Decodes a string that contains HTML numeric character references or HTML character entity references, and returns the decoded string.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
HTMLENCODE(expression, <options>)
Encodes characters using HTML character entity references, and returns the encoded string.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
IBESSEL(nu, x, kode)
Returns the value of the modified Bessel function.
Product: Base SAS
Document: SAS DS2 Language Reference
IBESSEL(nu, x, kode)
Returns the value of the modified Bessel function.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
IBESSEL(nu, x, kode)
Returns the value of the modified Bessel function.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
IFC(logical-expression, value-returned-when-true, value-returned-when-false
<, value-returned-when-missing>)
Returns a character value based on whether an expression is true, false, or missing.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
IFN(logical-expression, value-returned-when-true, value-returned-when-false
<, value-returned-when-missing>)
Returns a numeric value based on whether an expression is true, false, or missing.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
IFNULL(expression-1, expression-2)
Checks the value of the first expression and, if it is null or a SAS missing value, returns the second expression.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
INDEX(target-expression, search-expression)
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.
Product: Base SAS
Document: SAS DS2 Language Reference
INDEX(target-expression, search-expression)
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.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
INDEX(source, excerpt)
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.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
INDEXC(target-expression, search-expression[, ...search-expression])
Searches a character expression for specified characters and returns the position of the first occurrence of any of the characters.
Product: Base SAS
Document: SAS DS2 Language Reference
INDEXC(target-expression, search-expression[, ...search-expression])
Searches a character expression for specified characters and returns the position of the first occurrence of any of the characters.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
INDEXC(source, excerpt-1 <, …excerpt-n>)
Searches a character expression for any of the specified characters, and returns the position of that character.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
INDEXW(target-expression, search-expression [, delimiter])
Searches a character expression for a string that is specified as a word, and returns the position of the first character in the word.
Product: Base SAS
Document: SAS DS2 Language Reference
INDEXW(source, excerpt <, delimiters>)
Searches a character expression for a string that is specified as a word, and returns the position of the first character in the word.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
INPUT(source, <? | ??> informat.)
Returns the value that is produced when SAS converts an expression by using the specified informat.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
INPUTC(source, informat[, w])
Enables you to specify a character informat at run time.
Product: Base SAS
Document: SAS DS2 Language Reference
INPUTC(source, informat[, w])
Enables you to specify a character informat at run time.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
INPUTC(source, informat <, w>)
Enables you to specify a character informat at run time.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
INPUTN(source, informat[, w[, d]])
Enables you to specify a numeric informat at run time.
Product: Base SAS
Document: SAS DS2 Language Reference
INPUTN(source, informat[, w[, d]])
Enables you to specify a numeric informat at run time.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
INPUTN(source, informat <, w<, d>>)
Enables you to specify a numeric informat at run time.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
INT(expression)
Returns the whole number, fuzzed to avoid unexpected floating-point results.
Product: Base SAS
Document: SAS DS2 Language Reference
INT(expression)
Returns the whole number, fuzzed to avoid unexpected floating-point results.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
INT(argument)
Returns the integer value, fuzzed to avoid unexpected floating-point results.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
INTCINDEX({interval[multiple][.shift-index]}, date-time-value)
Returns the cycle index when a date, time, or timestamp interval and value are specified.
Product: Base SAS
Document: SAS DS2 Language Reference
INTCINDEX({interval[multiple][.shift-index]}, date-time-value)
Returns the cycle index when a date, time, or timestamp interval and value are specified.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
INTCINDEX(interval <<multiple.<shift-index>>>, date-time-value)
Returns the cycle index when a date, time, or datetime interval and value are specified.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
INTCK({interval[multiple][.shift-index]}, start-date, end-date[, 'method'])
INTCK(start-date, end-date[, 'method'])
Returns the number of interval boundaries of a given kind that lie between two SAS dates, times, or timestamp values encoded as DOUBLE.
Product: Base SAS
Document: SAS DS2 Language Reference
INTCK({interval[multiple][.shift-index]}, start-date, end-date[, 'method'])
INTCK(start-date, end-date[, 'method'])
Returns the number of interval boundaries of a given kind that lie between two SAS dates, times, or timestamp values encoded as DOUBLE.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
INTCK(interval <multiple> <.shift-index>, start-date, end-date, <'method'>)
INTCK(custom-interval, start-date, end-date, <'method'>)
Returns the number of interval boundaries of a given kind that lie between two dates, times, or datetime values.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
INTCYCLE({interval[multiple][.shift-index]}[, seasonality])
Returns the date, time, or datetime interval at the next higher seasonal cycle when a date, time, or datetime interval is specified.
Product: Base SAS
Document: SAS DS2 Language Reference
INTCYCLE({interval[multiple][.shift-index]}[, seasonality])
Returns the date, time, or datetime interval at the next higher seasonal cycle when a date, time, or datetime interval is specified.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
INTCYCLE(interval <<multiple.<shift-index>>>, <seasonality>)
Returns the date, time, or datetime interval at the next higher seasonal cycle when a date, time, or datetime interval is specified.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
INTDT(expression, increment)
Specifies the number of days to add to a DATE value.
Product: Base SAS
Document: SAS DS2 Language Reference
INTFIT(expresssion-1, expression-2, 'type')
Returns a time interval that is aligned between two dates.
Product: Base SAS
Document: SAS DS2 Language Reference
INTFIT(expresssion-1, expression-2, 'type')
Returns a time interval that is aligned between two dates.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
INTFIT(argument-1, argument-2, 'type')
Returns a time interval that is aligned between two dates.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
INTFMT(interval <<multiple.<.shift-index>>>, 'size')
Returns a recommended SAS format when a date, time, or datetime interval is specified.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
INTGET(date-1, date-2, date-3)
Returns a time interval based on three date or datetime values.
Product: Base SAS
Document: SAS DS2 Language Reference
INTGET(date-1, date-2, date-3)
Returns a time interval based on three date or datetime values.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
INTGET(date-1, date-2, date-3)
Returns a time interval based on three date or datetime values.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
INTINDEX({interval[multiple][.shift-index]}, date-value[, seasonality])
Returns the seasonal index when a date, time, or timestamp interval and value are specified.
Product: Base SAS
Document: SAS DS2 Language Reference
INTINDEX({interval[multiple][.shift-index]}, date-value[, seasonality])
Returns the seasonal index when a date, time, or timestamp interval and value are specified.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
INTINDEX(interval <<multiple.<shift-index>>>, date-value, <seasonality>)
Returns the seasonal index when a date, time, or datetime interval and value are specified.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
INTNEST(interval1, interval2)
Calculates the number of whole periods of the smaller interval that will fit into the period of the larger interval.
Product: Base SAS
Document: SAS DS2 Language Reference
INTNEST(interval1, interval2)
Calculates the number of whole periods of the smaller interval that will fit into the period of the larger interval.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
INTNX({interval[multiple][.shift-index]}, start-from, increment[, 'alignment'])
INTNX(start-from, increment[, 'alignment'])
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.
Product: Base SAS
Document: SAS DS2 Language Reference
INTNX({interval[multiple][.shift-index]}, start-from, increment[, 'alignment'])
INTNX(start-from, increment[, 'alignment'])
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.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
INTNX(interval <multiple><.shift-index>, start-from, increment <, 'alignment'>)
INTNX(custom-interval, start-from, increment <, 'alignment'>)
Increments a date, time, or datetime value by a given time interval, and returns a date, time, or datetime value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
INTRR(freq, c0, c1[..., cn])
Returns the internal rate of return as a decimal value.
Product: Base SAS
Document: SAS DS2 Language Reference
INTRR(freq, c0, c1[..., cn])
Returns the internal rate of return as a decimal value.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
INTRR(frequency, c0, c1, ..., cn)
Returns the internal rate of return as a fraction.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
INTSEAS({interval[multiple][.shift-index]}[, seasonality])
Returns the length of the seasonal cycle when a date, time, or datetime interval is specified.
Product: Base SAS
Document: SAS DS2 Language Reference
INTSEAS({interval[multiple][.shift-index]}[, seasonality])
Returns the length of the seasonal cycle when a date, time, or datetime interval is specified.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
INTSEAS(interval <<multiple.<shift-index>>> <seasonality>)
Returns the length of the seasonal cycle when a date, time, or datetime interval is specified.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
INTSHIFT(interval[multiple][.shift-index])
Returns the shift interval that corresponds to the base interval.
Product: Base SAS
Document: SAS DS2 Language Reference
INTSHIFT(interval[multiple][.shift-index])
Returns the shift interval that corresponds to the base interval.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
INTSHIFT(interval <<multiple.<shift-index>>>)
Returns the shift interval that corresponds to the base interval.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
INTTEST(interval[multiple][.shift-index])
Returns 1 if a time interval is valid, and returns 0 if a time interval is invalid.
Product: Base SAS
Document: SAS DS2 Language Reference
INTTEST(interval[multiple][.shift-index])
Returns 1 if a time interval is valid, and returns 0 if a time interval is invalid.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
INTTEST(interval <<multiple.<shift-index>>>)
Returns 1 if a time interval is valid, and returns 0 if a time interval is invalid.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
INTTS(expression, increment)
Specifies the number of seconds to add to a TIMESTAMP value.
Product: Base SAS
Document: SAS DS2 Language Reference
INTZ(expression)
Returns the whole number portion of the argument, using zero fuzzing.
Product: Base SAS
Document: SAS DS2 Language Reference
INTZ(expression)
Returns the whole number portion of the argument, using zero fuzzing.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
INTZ(argument)
Returns the integer portion of the argument, using zero fuzzing.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
quantile=INVCDF('CDF-function-name', options-array, cumulative-probability,
parameter-1 <, parameter-2, ...>);
Computes the quantile from any distribution for which you have defined a cumulative distribution function (CDF).
Product: Base SAS
Document: Base SAS Procedures Guide
IORCMSG()
Returns a formatted error message for _IORC_.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
IPMT(rate, period, number-of-periods, principal-amount[, future-amount][, type])
Returns the interest payment for a given period for a constant payment loan or the periodic savings for a future balance.
Product: Base SAS
Document: SAS DS2 Language Reference
IPMT(rate, period, number-of-periods, principal-amount[, future-amount][, type])
Returns the interest payment for a given period for a constant payment loan or the periodic savings for a future balance.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
IPMT(rate, period, number-of-periods, principal-amount, <future-amount>, <type>)
Returns the interest payment for a given period for a constant payment loan or the periodic savings for a future balance.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
IQR(expression [, ...expression])
Returns the interquartile range.
Product: Base SAS
Document: SAS DS2 Language Reference
IQR(expression [, ...expression])
Returns the interquartile range.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
IQR(value-1 <, value-2...>)
Returns the interquartile range.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
IRR(freq, c1, c2 [..., cn])
Returns the internal rate of return as a percentage.
Product: Base SAS
Document: SAS DS2 Language Reference
IRR(freq, c1, c2 [..., cn])
Returns the internal rate of return as a percentage.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
IRR(frequency , c1, c2<, ... , cn>)
Returns the internal rate of return as a percentage.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
numeric-variable = ISNULL (pointer-element);
Determines whether a pointer element of a structure is null.
Product: Base SAS
Document: Base SAS Procedures Guide
JBESSEL(nu, x)
Returns the value of the Bessel function.
Product: Base SAS
Document: SAS DS2 Language Reference
JBESSEL(nu, x)
Returns the value of the Bessel function.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
JBESSEL(nu, x)
Returns the value of the Bessel function.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
JSONPP(‘input file’,’output file’)
Creates a readable copy of JSON input.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
JULDATE(date)
Returns the Julian date from a SAS date value.
Product: Base SAS
Document: SAS DS2 Language Reference
JULDATE(date)
Returns the Julian date from a SAS date value.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
JULDATE(date)
Returns the Julian date from a SAS date value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
JULDATE7(date)
Returns a seven-digit Julian date from a SAS date value.
Product: Base SAS
Document: SAS DS2 Language Reference
JULDATE7(date)
Returns a seven-digit Julian date from a SAS date value.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
JULDATE7(date)
Returns a seven-digit Julian date from a SAS date value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
KCHARLIST(modifier)
Returns the character list according to the modifier.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
KCOMPARE(source,<pos, count, > findstr,<modifiers>)
Returns the result of a comparison of character expressions.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
KCOMPRESS(source,<characters-to-remove>, <modifier(s)>)
Removes specified characters from a character expression.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
KCOUNT(source)
Returns the number of double-byte characters in an expression.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
KCOUNTC(string,character-list,<modifier(s)>);
counts individual characters in a character string.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
KCOUNTW(<string>,<character-list>,<modifier(s)>);
Counts the number of words in a character string.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
KCOUNTX(string,substring,<modifier(s)>);
Counts the number of times that a specified substring appears within a character string.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
KCVT(text, intype, outtype, <options> )
Converts data from one type of encoding data to another type of encoding data.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
KFIND(string,substring,<start-position>,<modifier(s)>)
KFIND(string,substring,<modifier(s)>,<start-position>)
Searches for a specific substring of characters within a character string.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
KFINDC(string,<character-list>)
KFINDC(string,character-list,<modifier(s)>)
KFINDC(string,character-list,modifier(s),<start-position>)
KFINDC(string,character-list,<start-position>,<modifier(s)>)
Searches a string for any character in a list of characters.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
KFINDW(string,word,<character-list>)
KFINDW(string,word,character-list,modifier(s),<start-position>)
KFINDW(string,word,character-list,start-position,<modifier(s)>)
KFINDW(string,word,start-position,<character-list,modifier(s)>)
Returns the character position of a word in a string or the number of the word in a string.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
KINDEX(source, excerpt)
Searches a character expression for a string of characters.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
KINDEXB(source, excerpt)
Searches a character expression for specified characters and returns byte-based values.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
KINDEXC(source, excerpt-1, …excerpt-n)
Searches a character expression for specified characters and returns character-based values.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
KINDEXCB(source, excerpt-1, …, excerpt-n)
Searches a character expression for specified characters and returns byte-based values.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
KLEFT(argument)
Left-aligns a character expression by removing unnecessary leading DBCS blanks and SO/SI.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
KLENGTH(argument)
Returns the length, in characters, of an argument.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
KLOWCASE(argument)
Converts the uppercase alphabetic letters to lowercase letters.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
str=KPROPCASE(<instr> , (<options> ))
Converts Chinese, Japanese, Korean, Taiwanese (CJKT) characters.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
str=KPROPCHAR(<instr> )
Converts Unicode to the corresponding characters enclosed in parenthesis.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
str=KPROPDATA(<instr> (<options>, <input encode name>, <output encode name>))
Removes or converts unprintable characters.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
KREVERSE(argument)
Reverses a character expression.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
KRIGHT(argument)
Right-aligns a character expression by trimming trailing DBCS blanks and SO/SI.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
KSCAN(argument,n<, delimiters> )
Selects a specified word from a character expression.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
KSCANX(string,count,<character-list>,<modifier>)
Selects a specified word from a character expression using a modifier to process the function’s action.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
KSTRCAT(argument-1, argument-2<, … argument-n> )
Concatenates two or more character expressions.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
KSTRIP(string)
Removes leading and trailing blanks from a character string.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
KSUBSTR(argument, position<,n> )
Extracts a substring from an argument.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
KSUBSTRB(argument, position<,n> )
Extracts a substring from an argument according to the byte position of the substring in the argument.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
KSUBSTRN(string,position,<length>)
Returns a substring, allowing a result with a length of zero.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
KTRANSLATE(source,to-1,from-1<,…to-n,from-n> )
Replaces specified characters in a character expression.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
KTRANSLATE(source, to-1, from-1<to-2, from-2 ...>)
Replaces specific characters in a character expression.
Product: Base SAS
Document: SAS Companion for z/OS
KTRIM(argument)
Removes trailing DBCS blanks and SO/SI from character expressions.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
KTRUNCATE(argument, number, length)
Truncates a string to a specified length in byte unit without breaking multibyte characters.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
KUPCASE(argument)
Converts the lowercase alphabetic letters to uppercase letters.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
KUPDATE(argument,position,n<, characters-to-replace> )
KUPDATE(argument, position<,n> , characters-to-replace)
Replaces character value contents.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
KUPDATEB(argument, position, n<,characters-to-replace> )
KUPDATEB(argument, position <, n> , characters-to-replace)
Replaces the contents of the character value according to the byte position of the character value in the argument.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
KUPDATES(argument,position,n<, characters-to-replace> )
KUPDATES(argument,position<,n> , characters-to-replace)
Replaces character value contents.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
KURTOSIS(expression-1, expression-2, expression-3, expression-4 [, ...expression-n])
Returns the kurtosis.
Product: Base SAS
Document: SAS DS2 Language Reference
KURTOSIS([DISTINCT] expression)
Returns the kurtosis of all values in an expression.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
KURTOSIS(argument-1, argument-2, argument-3, argument-4 <, …, argument-n>)
Returns the kurtosis.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
KVERIFY(source, excerpt-1, ...excerpt-n)
Returns the position of the first character (character-based value) that is unique to an expression.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
KVERIFYB(source, excerpt-1,<excerpt-n>)
Returns the position of the first character (byte-based value) that is unique to an expression.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
LAG [n] (expression)
Returns values from a queue.
Product: Base SAS
Document: SAS DS2 Language Reference
LAG <n> (argument)
Returns values from a queue.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
LARGEST(k, expression [, ...expression])
Returns the kth largest non-null or nonmissing value.
Product: Base SAS
Document: SAS DS2 Language Reference
LARGEST(k, expression [, ...expression])
Returns the kth largest non-null or nonmissing value.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
LARGEST(k, value-1 <, value-2 ...>)
Returns the kth largest nonmissing value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
LBOUND(array-name[, bound-n])
Returns the lower bound of an array.
Product: Base SAS
Document: SAS DS2 Language Reference
LBOUND <n> (array-name)
LBOUND(array-name, bound-n)
Returns the lower bound of an array.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
LCM(expression-1, expression-2 [, ...expression-n])
Returns the least common multiple for a set of whole numbers.
Product: Base SAS
Document: SAS DS2 Language Reference
LCM(expression-1, expression-2 [, ...expression-n])
Returns the least common multiple for a set of whole numbers.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
LCM(x1, x2, x3, …, xn)
Returns the least common multiple.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
LCOMB(n, r)
Computes the logarithm of the COMB function, which is the logarithm of the number of combinations of n objects taken r at a time.
Product: Base SAS
Document: SAS DS2 Language Reference
LCOMB(n, r)
Computes the logarithm of the COMB function, which is the logarithm of the number of combinations of n objects taken r at a time.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
LCOMB(n, r)
Computes the logarithm of the COMB function, which is the logarithm of the number of combinations of n objects taken r at a time.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
LEFT(expression)
Left aligns a character expression.
Product: Base SAS
Document: SAS DS2 Language Reference
LEFT(expression)
Left aligns a character expression.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
LEFT(argument)
Left-aligns a character string.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
LENGTH(expression)
Returns the length of a character string, excluding trailing blanks, in characters.
Product: Base SAS
Document: SAS DS2 Language Reference
LENGTH(string)
Returns the length of a non-blank character string, excluding trailing blanks, and returns 1 for a blank character string.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
LENGTHC(expression)
Returns the length of a character string, including trailing blanks, in characters.
Product: Base SAS
Document: SAS DS2 Language Reference
LENGTHC(string)
Returns the length of a character string, including trailing blanks.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
LENGTHM(variable)
Returns the amount of memory, in bytes, that could or might be allocated for a character string.
Product: Base SAS
Document: SAS DS2 Language Reference
LENGTHM(string)
Returns the amount of memory (in bytes) that is allocated for a character string.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
LENGTHN(string)
Returns the length of a character string, excluding trailing blanks.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
LEXCOMB(count, k, variable-1, …, variable-n)
Generates all distinct combinations of the nonmissing values of n variables taken k at a time in lexicographic order.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
LEXCOMBI(n, k, index-1, …, k)
Generates all combinations of the indices of n objects taken k at a time in lexicographic order.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
LEXPERK(count, k, variable-1, …, variable-n)
Generates all distinct permutations of the nonmissing values of n variables taken k at a time in lexicographic order.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
LEXPERM(count, variable-1 <, …, variable-N>)
Generates all distinct permutations of the nonmissing values of several variables in lexicographic order.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
LFACT(n)
Computes the logarithm of the FACT (factorial) function.
Product: Base SAS
Document: SAS DS2 Language Reference
LFACT(n)
Computes the logarithm of the FACT (factorial) function.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
LFACT(n)
Computes the logarithm of the FACT (factorial) function.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
LGAMMA(expression)
Returns the natural logarithm of the Gamma function.
Product: Base SAS
Document: SAS DS2 Language Reference
LGAMMA(expression)
Returns the natural logarithm of the Gamma function.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
LGAMMA(argument)
Returns the natural logarithm of the Gamma function.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
LIBNAME(libref <, SAS-library <, engine <, options>>>)
Assigns or clears a libref for a SAS library.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
LIBNAME(libref<,SAS-data-library<,engine<,options>>>)
Assigns or clears a libref for a SAS library.
Product: Base SAS
Document: SAS Companion for Windows
LIBREF(libref)
Verifies that a libref has been assigned.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
imom=LIMMOMENT('CDF-function-name', options-array, order, limit,
parameter-1 <, parameter-2, ...>);
Computes the limited moment of any distribution for which you have defined a cumulative distribution function (CDF).
Product: Base SAS
Document: Base SAS Procedures Guide
LOG(expression)
Returns the natural logarithm (base e) of a numeric value expression.
Product: Base SAS
Document: SAS DS2 Language Reference
LOG(expression)
Returns the natural logarithm (base e) of a numeric value expression.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
LOG(argument)
Returns the natural (base e) logarithm.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
LOG10(expression)
Returns the base-10 logarithm of a numeric value expression.
Product: Base SAS
Document: SAS DS2 Language Reference
LOG10(expression)
Returns the base-10 logarithm of a numeric value expression.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
LOG10(argument)
Returns the logarithm to the base 10.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
LOG1PX(x)
Returns the log of 1 plus the argument.
Product: Base SAS
Document: SAS DS2 Language Reference
LOG1PX(x)
Returns the log of 1 plus the argument.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
LOG1PX(x)
Returns the log of 1 plus the argument.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
LOG2(expression)
Returns the base 2 logarithm of a numeric value expression.
Product: Base SAS
Document: SAS DS2 Language Reference
LOG2(expression)
Returns the base-2 logarithm of a numeric value expression.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
LOG2(argument)
Returns the logarithm to the base 2.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
LOG4SAS_APPENDER("name", "FileRefAppender" , <'options'>)
Creates a fileref appender that can be referenced by a logger.
Product: Base SAS
Document: SAS Logging: Configuration and Programming Reference
LOG4SAS_LOGEVENT("name", "level", "message")
Logs a message by using a specific logger.
Product: Base SAS
Document: SAS Logging: Configuration and Programming Reference
LOG4SAS_LOGGER("name", <"options"> )
Creates a logger.
Product: Base SAS
Document: SAS Logging: Configuration and Programming Reference
LOGBETA(a, b)
Returns the logarithm of the beta function.
Product: Base SAS
Document: SAS DS2 Language Reference
LOGBETA(a, b)
Returns the logarithm of the beta function.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
LOGBETA(a, b)
Returns the logarithm of the beta function.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
LOGCDF('distribution', quantile [, parameter-1, ..., parameter-k])
Returns the logarithm of a left cumulative distribution function.
Product: Base SAS
Document: SAS DS2 Language Reference
LOGCDF('distribution', quantile [, parameter-1, ..., parameter-k])
Returns the logarithm of a left cumulative distribution function.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
LOGCDF('distribution', quantile <, parameter-1, ..., parameter-k>)
Returns the logarithm of a left cumulative distribution function.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
LOGISTIC(argument)
Returns the logistic transformation of the argument.
Product: Base SAS
Document: SAS DS2 Language Reference
LOGISTIC(argument)
Returns the logistic transformation of the argument.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
LOGISTIC(argument)
Returns the logistic transformation of the argument.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
LOGPDF('distribution', quantile, parameter-1, ..., parameter-k)
Computes the logarithm of the probability density (mass) function from various continuous and discrete distributions.
Product: Base SAS
Document: SAS DS2 Language Reference
LOGPDF('distribution', quantile, parameter-1, ..., parameter-k)
Computes the logarithm of the probability density (mass) function from various continuous and discrete distributions.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
LOGPDF('distribution', quantile, parameter-1, ..., parameter-k)
Returns the logarithm of a probability density (mass) function.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
LOGSDF('distribution', quantile, parameter-1, ..., parameter-k)
Returns the logarithm of a survival function.
Product: Base SAS
Document: SAS DS2 Language Reference
LOGSDF('distribution', quantile, parameter-1, ..., parameter-k)
Returns the logarithm of a survival function.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
LOGSDF('distribution', quantile, parameter-1, ..., parameter-k)
Returns the logarithm of a survival function.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
LOWCASE(expression)
Converts all letters in a character expression to lowercase.
Product: Base SAS
Document: SAS DS2 Language Reference
LOWCASE(expression)
Converts all letters in a character expression to lowercase.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
LOWCASE(argument)
Converts all uppercase single-width English alphabet letters in an argument to lowercase.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
LOWER (sql-expression)
Converts the case of a character string to lowercase.
Product: Base SAS
Document: SAS SQL Procedure User’s Guide
LPERM(n <, r>)
Computes the logarithm of the PERM function, which is the logarithm of the number of permutations of n objects, with the option of including r number of elements.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
LPNORM(p, value-1 <, value-2 ...>)
Returns the Lp norm of the second argument and subsequent nonmissing arguments.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
MAD(expression-1[, ...expression-n])
Returns the median absolute deviation from the median.
Product: Base SAS
Document: SAS DS2 Language Reference
MAD(expression-1[, ...expression-n])
Returns the median absolute deviation from the median.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
MAD(value-1 <, value-2...>)
Returns the median absolute deviation from the median.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
MAKEDATE(y, m, d)
Returns the date as year, month, and day.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
MAKETIME(h, m, s)
Returns the time as hours, minutes, and seconds.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
MAKETIMESTAMP(d,t)
MAKETIMESTAMP(y,m,d,h,m,s)
Returns the timestamp.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
MARGRCLPRC(X1, t, X2, sigma1, sigma2, rho12)
Calculates call prices for European options on stocks, based on the Margrabe model.
Product: Base SAS
Document: SAS DS2 Language Reference
MARGRCLPRC(X1, t, X2, sigma1, sigma2, rho12)
Calculates call prices for European options on stocks, based on the Margrabe model.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
MARGRCLPRC(X1, t, X2, sigma-1, sigma-2, rho12)
Calculates call prices for European options on stocks, based on the Margrabe model.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
MARGRPTPRC(X1, t, X2, sigma1, sigma2, rho12)
Calculates put prices for European options on stocks, based on the Margrabe model.
Product: Base SAS
Document: SAS DS2 Language Reference
MARGRPTPRC(X1, t, X2, sigma1, sigma2, rho12)
Calculates put prices for European options on stocks, based on the Margrabe model.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
MARGRPTPRC(X1, t, X2, sigma-1, sigma-2, rho12)
Calculates put prices for European options on stocks, based on the Margrabe model.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
MAX(expression-1, expression-2 [, ...expression-n])
Returns the largest value from a list of arguments.
Product: Base SAS
Document: SAS DS2 Language Reference
MAX([DISTINCT] expression)
Returns the maximum value in a column.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
MAX(argument-1 <, argument-2, ...>)
Returns the largest value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
MCIPISLP(number-of-seconds)
Causes SAS to wait for a piece of multimedia equipment to become active.
Product: Base SAS
Document: SAS Companion for Windows
MCIPISTR(MCI-string-command)
Submits an MCI string command to a piece of multimedia equipment.
Product: Base SAS
Document: SAS Companion for Windows
MD5(string)
Returns the result of the message digest of a specified string in binary format.
Product: Base SAS
Document: SAS DS2 Language Reference
MD5(message)
Returns an MD5 message digest as a 16-byte binary string for a message consisting of a character string.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
MDY(month, day, year)
Returns a SAS date value from month, day, and year values.
Product: Base SAS
Document: SAS DS2 Language Reference
MDY(month, day, year)
Returns a SAS date value from month, day, and year values.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
MDY(month, day, year)
Returns a SAS date value from month, day, and year values.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
MEAN(expression-1[, ...expression-n])
Returns the arithmetic mean (average) of the non-null or nonmissing arguments.
Product: Base SAS
Document: SAS DS2 Language Reference
MEAN(expression-1[, ...expression-n])
Returns the arithmetic mean (average) of the non-null or nonmissing arguments.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
MEAN(argument-1 <, ... argument-n>)
Returns the arithmetic mean (average).
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
MEDIAN(expression-1[, ...expression-n ])
Returns the median value.
Product: Base SAS
Document: SAS DS2 Language Reference
MEDIAN(expression-1[, ...expression-n ])
Returns the median value.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
MEDIAN(value–1 <, value–2, ...>)
Returns the median value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
value=METADATA_APPPROP(softwareComponent, property);
value=METADATA_APPPROP(softwareComponent/deployedComponent, property)
Returns the value of the specified property from the specified SoftwareComponent or DeployedComponent object.
Product: Base SAS
Document: SAS Language Interfaces to Metadata
rc=METADATA_DELASSN(uri, assn);
Deletes all objects that make up the specified association.
Product: Base SAS
Document: SAS Language Interfaces to Metadata
rc = METADATA_DELOBJ(uri);
Deletes the first object that matches the specified URI.
Product: Base SAS
Document: SAS Language Interfaces to Metadata
rc = METADATA_GETATTR(uri, attr, value);
Returns the value of the specified attribute for the specified object.
Product: Base SAS
Document: SAS Language Interfaces to Metadata
rc = METADATA_GETNASL(uri, n, asn);
Returns the nth association for the specified object.
Product: Base SAS
Document: SAS Language Interfaces to Metadata
rc = METADATA_GETNASN(uri, asn, n, nuri);
Returns the nth associated object of the specified association.
Product: Base SAS
Document: SAS Language Interfaces to Metadata
rc = METADATA_GETNATR(uri, n, attr, value);
Returns the nth attribute of the specified object.
Product: Base SAS
Document: SAS Language Interfaces to Metadata
rc = METADATA_GETNOBJ(uri, n, nuri);
Returns the nth object that matches the specified URI.
Product: Base SAS
Document: SAS Language Interfaces to Metadata
rc = METADATA_GETNPRP(uri, n, prop, value);
Returns the nth property of the specified object.
Product: Base SAS
Document: SAS Language Interfaces to Metadata
rc = METADATA_GETNTYP(n, type);
Returns the nth object type on the server.
Product: Base SAS
Document: SAS Language Interfaces to Metadata
rc = METADATA_GETPROP(uri, prop, value, propuri);
Returns the value and Uniform Resource Identifier (URI) of the specified property for the specified object.
Product: Base SAS
Document: SAS Language Interfaces to Metadata
rc = METADATA_GETURI("softwareComponent", url, protocol, hostname, port, service);
Returns a URL for the application specified by the SoftwareComponent object.
Product: Base SAS
Document: SAS Language Interfaces to Metadata
rc = METADATA_NEWOBJ(type, uri<, name><, repos><, parent><, asn>);
Creates a new metadata object.
Product: Base SAS
Document: SAS Language Interfaces to Metadata
rc = METADATA_PATHOBJ(proj, path, deftype, type, ID);
Returns the Id and Type attributes of the specified folder object.
Product: Base SAS
Document: SAS Language Interfaces to Metadata
rc = METADATA_PAUSED();
Determines whether the server specified by the METASERVER system option is paused.
Product: Base SAS
Document: SAS Language Interfaces to Metadata
rc = METADATA_PURGE(<uri>);
Purges the specified URI.
Product: Base SAS
Document: SAS Language Interfaces to Metadata
rc = METADATA_RESOLVE(uri, type, ID);
Resolves a URI into an object on the metadata server.
Product: Base SAS
Document: SAS Language Interfaces to Metadata
rc = METADATA_SETASSN(uri, asn, mod, auri-1< , auri-2 ... >);
Modifies an association list for an object.
Product: Base SAS
Document: SAS Language Interfaces to Metadata
rc = METADATA_SETATTR(uri, attr, value);
Sets the specified attribute for the specified object.
Product: Base SAS
Document: SAS Language Interfaces to Metadata
rc = METADATA_SETPROP(uri, prop, value, propuri);
Sets the specified property for the specified object.
Product: Base SAS
Document: SAS Language Interfaces to Metadata
ver = METADATA_VERSION();
Returns the metadata server's model version number.
Product: Base SAS
Document: SAS Language Interfaces to Metadata
rc = METASEC_APPLYACT(tc, uri, act_uri,flags);
Applies an ACT to an object.
Product: Base SAS
Document: SAS Language Interfaces to Metadata
rc = METASEC_BEGTRAN(uri, flags, tc);
Begins the TC.
Product: Base SAS
Document: SAS Language Interfaces to Metadata
rc = METASEC_DELACT(tc, act_uri);
Deletes ACT from the metadata server.
Product: Base SAS
Document: SAS Language Interfaces to Metadata
rc = METASEC_ENDTRAN(uri, tc, flags);
Ends the TC.
Product: Base SAS
Document: SAS Language Interfaces to Metadata
rc = METASEC_GETACTA(tc, act_uri, attr, attr_value);
Returns an ACT attribute.
Product: Base SAS
Document: SAS Language Interfaces to Metadata
rc = METASEC_GETNACT(tc, uri, n, act_uri, name, desc, use<, flags);>
Returns the nth ACT.
Product: Base SAS
Document: SAS Language Interfaces to Metadata
rc = METASEC_GETNACTA(tc, act_uri, n, attr, attr_value);
Returns the nth attribute for an ACT.
Product: Base SAS
Document: SAS Language Interfaces to Metadata
rc=METASEC_GETNAUTH(tc, uri, n, type, name, auth, perm, cond < , flags >< , display >)
Returns the nth authorization for an object.
Product: Base SAS
Document: SAS Language Interfaces to Metadata
rc = METASEC_GETNID(tc, uri, n, type, name, flags<, display, origin);>
Returns the nth identity for an object. Identities can come directly from the object, from the inheritance parents, from the default ACT, and from any ACTs that are directly associated with the object.
Product: Base SAS
Document: SAS Language Interfaces to Metadata
rc = METASEC_NEWACT(tc, repos_uri, attr, attr_value<, attrn, attr_valuen>);
Creates a new ACT.
Product: Base SAS
Document: SAS Language Interfaces to Metadata
rc = METASEC_REMACT(tc, uri, act_uri, flags);
Removes an ACT from an object.
Product: Base SAS
Document: SAS Language Interfaces to Metadata
rc = METASEC_SETACTA(tc, act_uri, attr, attr_value);
Sets an ACT attribute.
Product: Base SAS
Document: SAS Language Interfaces to Metadata
rc = METASEC_SETAUTH(tc, uri, type, name, auth, perm, cond<, flags>);
Sets authorization for an object.
Product: Base SAS
Document: SAS Language Interfaces to Metadata
MIN(expression-1, expression-2 [, …expression-n])
Returns the smallest value.
Product: Base SAS
Document: SAS DS2 Language Reference
MIN([DISTINCT] expression)
Returns the minimum value in an expression.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
MIN(argument-1 <, argument-2, ...>)
Returns the smallest value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
MINUTE(time | datetime)
Returns the minute from a SAS time or datetime value.
Product: Base SAS
Document: SAS DS2 Language Reference
MINUTE(time | datetime)
Returns the minute from a time or datetime value.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
MINUTE(time | datetime)
Returns the minute from a SAS time or datetime value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
MISSING(expression)
Returns a number that indicates whether the argument contains a missing value.
Product: Base SAS
Document: SAS DS2 Language Reference
MISSING(numeric-expression | character-expression)
Returns a numeric result that indicates whether the argument contains a missing value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
MOD(dividend-expression, divisor-expression)
Returns the remainder from the division of the first argument by the second argument, fuzzed to avoid most unexpected floating-point results.
Product: Base SAS
Document: SAS DS2 Language Reference
MOD(dividend-expression, divisor-expression)
Returns the remainder from the division of the first argument by the second argument, fuzzed to avoid most unexpected floating-point results.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
MOD(argument-1, argument-2)
Returns the remainder from the division of the first argument by the second argument, fuzzed to avoid most unexpected floating-point results.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
MODEXIST('product-name' | 'pathname')
Determines whether a software image exists in the version of SAS that you have installed.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
MODEXIST('product-name' | 'pathname')
Determines whether a product image exists in the release of SAS that you have installed.
Product: Base SAS
Document: SAS Companion for UNIX Environments
CALL MODULE(<control string>,module,argument-1, ..., argument-n);
num=MODULEN(<control-string>,module,argument-1, ..., argument-n);
char=MODULEC(<control-string> ,module,argument-1, ..., argument-n);
CALL MODULEI(<control-string> ,moduleargument-1, ..., argument-n);
num=MODULEIN(<control-string> ,module,argument-1, ..., argument-n)
char=MODULEIC(<control-string> ,module,argument-1, ..., argument-n);
Calls a specific routine or module that resides in an external dynamic link library (DLL).
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
CALL MODULE(<control string>,module,argument-1, ..., argument-n);
num=MODULEN(<control-string>,module,argument-1, ..., argument-n);
char=MODULEC(<control-string> ,module,argument-1, ..., argument-n);
CALL MODULEI(<control-string> ,moduleargument-1, ..., argument-n);
num=MODULEIN(<control-string> ,module,argument-1, ..., argument-n)
char=MODULEIC(<control-string> ,module,argument-1, ..., argument-n);
Calls a specific routine or module that resides in an external dynamic link library (DLL).
Product: Base SAS
Document: SAS Companion for Windows
num=MODULEN(<cntl> ,module,arg-1,arg-2…,arg-n);
char=MODULEC(<cntl> ,module,arg-1…,arg-2,arg-n);
num=MODULEIN(<cntl> ,module,arg-1,arg-2...,arg-n)
char=MODULEIC(<cntl> ,module,arg-1,arg-2...,arg-n);
Calls an external routine with a return code.
Product: Base SAS
Document: SAS Companion for z/OS
MODULEC(<cntl-string, > module-name <, argument-1, ..., argument-n>)
Calls an external routine and returns a character value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
MODULEN(<cntl-string, > module-name <, argument-1, ..., argument-n>)
Calls an external routine and returns a numeric value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
MODZ(dividend-expression, divisor-expression)
Returns the remainder from the division of the first argument by the second argument, using zero fuzzing.
Product: Base SAS
Document: SAS DS2 Language Reference
MODZ(dividend-expression, divisor-expression)
Returns the remainder from the division of the first argument by the second argument, using zero fuzzing.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
MODZ(argument-1, argument-2)
Returns the remainder from the division of the first argument by the second argument, using zero fuzzing.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
MONTH(date)
Returns a number that represents the month from a SAS date value.
Product: Base SAS
Document: SAS DS2 Language Reference
MONTH(date | datetime)
Returns the numeric month from a date or datetime value.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
MONTH(date)
Returns the month from a SAS date value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
MOPEN(directory-id, member-name <, open-mode <, record-length <, record-format>>>)
Opens a file by directory ID and member name, and returns either the file identifier or a 0.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
MOPEN(directory-id, member-name <, open-mode <, record-length <, record-format>>>)
Opens a file by directory ID and member name, and returns either the file identifier or a 0.
Product: Base SAS
Document: SAS Companion for UNIX Environments
MOPEN(directory-id,member-name<,open-mode<,record-length<,record-format>>>)
Opens a file by directory ID and by member name, and returns either the file identifier or a 0.
Product: Base SAS
Document: SAS Companion for z/OS
MORT(a, p, r, n)
Returns amortization parameters.
Product: Base SAS
Document: SAS DS2 Language Reference
MORT(a, p, r, n)
Returns amortization parameters.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
MORT(a, p, r, n)
Returns amortization parameters.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
MSPLINT(X, n, X1 <, X2, …, Xn>, Y1 <, Y2, …, Yn> <, D1, Dn>)
Returns the ordinate of a monotonicity-preserving interpolating spline.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
MVALID(libname, string, member-type <, valid-member-name>)
Checks the validity of a character string for use as a SAS member name.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
N(expression [, ...expression])
Returns the number of non-null or nonmissing numeric values.
Product: Base SAS
Document: SAS DS2 Language Reference
N(expression [, ...expression])
Returns the number of non-null or nonmissing numeric values.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
N(argument-1 <, ... argument-n>)
Returns the number of nonmissing numeric values.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
NDIMS(array-name)
Returns the number of dimensions in an array.
Product: Base SAS
Document: SAS DS2 Language Reference
NETPV(r, freq, c0, c1, ..., cn)
Returns the net present value as a percent.
Product: Base SAS
Document: SAS DS2 Language Reference
NETPV(r, freq, c0, c1, ..., cn)
Returns the net present value as a percent.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
NETPV(r, frequency, c0, c1, ..., cn)
Returns the net present value as a percent.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
NLDATE(date,descriptor)
Converts the SAS date value to the date value of the specified locale by using the date format descriptors.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
NLDATM(datetime,descriptor)
Converts the SAS datetime value to the time value of the specified locale by using the datetime-format descriptors.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
NLITERAL(string)
Converts a character string that you specify to a SAS name literal.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
NLTIME(time|datetime,descriptor,startpos)
Converts the SAS time or the datetime value to the time value of the specified locale by using the NLTIME descriptors.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
NMISS(expression [, ...expression])
Returns the number of null and SAS missing numeric values.
Product: Base SAS
Document: SAS DS2 Language Reference
Aggregate:
NMISS([DISTINCT] expression)
Scalar:
NMISS(expression[, ...expression])
Returns the number of null values or SAS missing values in an expression.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
NMISS(argument-1 <,... argument-n>)
Returns the number of missing numeric values.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
NOMRATE(compounding-interval, rate)
Returns the nominal annual interest rate.
Product: Base SAS
Document: SAS DS2 Language Reference
NOMRATE(compounding-interval, rate)
Returns the nominal annual interest rate.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
NOMRATE(compounding-interval, rate)
Returns the nominal annual interest rate.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
Returns a random variate from a normal, or Gaussian, distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
NOTALNUM('expression'[, start])
Searches a character string for a non-alphanumeric character, and returns the first character position at which the character is found.
Product: Base SAS
Document: SAS DS2 Language Reference
NOTALNUM('expression'[, start])
Searches a character string for a non-alphanumeric character, and returns the first character position at which the character is found.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
NOTALNUM(string <, start>)
Searches a character string for a nonalphanumeric character, and returns the first position at which the character is found.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
NOTALPHA('expression'[, start])
Searches a character string for a nonalphabetic character, and returns the first character position at which the character is found.
Product: Base SAS
Document: SAS DS2 Language Reference
NOTALPHA('expression'[, start])
Searches a character string for a nonalphabetic character, and returns the first character position at which the character is found.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
NOTALPHA(string <, start>)
Searches a character string for a nonalphabetic character, and returns the first position at which the character is found.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
NOTCNTRL('expression'[, start])
Searches a character string for a character that is not a control character, and returns the first character position at which that character is found.
Product: Base SAS
Document: SAS DS2 Language Reference
NOTCNTRL(string <, start>)
Searches a character string for a character that is not a control character, and returns the first position at which that character is found.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
NOTDIGIT('expression'[, start])
Searches a character string for any character that is not a digit, and returns the first character position at which that character is found.
Product: Base SAS
Document: SAS DS2 Language Reference
NOTDIGIT('expression'[, start])
Searches a character string for any character that is not a digit, and returns the first character position at which that character is found.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
NOTDIGIT(string <, start>)
Searches a character string for any character that is not a digit, and returns the first position at which that character is found.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
NOTE(data-set-id)
Returns an observation ID for the current observation of a SAS data set.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
NOTFIRST('expression'[, start])
Searches a character string for an invalid first character in a SAS variable name under VALIDVARNAME=V7, and returns the first character position at which that character is found.
Product: Base SAS
Document: SAS DS2 Language Reference
NOTFIRST('expression'[, start])
Searches a character string for an invalid first character in a SAS variable name under VALIDVARNAME=V7, and returns the first character position at which that character is found.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
NOTFIRST(string <, start>)
Searches a character string for an invalid first character in a SAS variable name under VALIDVARNAME=V7, and returns the first position at which that character is found.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
NOTGRAPH('expression'[, start])
Searches a character string for a non-graphical character, and returns the first character position at which that character is found.
Product: Base SAS
Document: SAS DS2 Language Reference
NOTGRAPH(string <, start>)
Searches a character string for a non-graphical character, and returns the first position at which that character is found.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
NOTLOWER('expression'[, start])
Searches a character string for a character that is not a lowercase letter, and returns the first character position at which that character is found.
Product: Base SAS
Document: SAS DS2 Language Reference
NOTLOWER('expression'[, start])
Searches a character string for a character that is not a lowercase letter, and returns the first character position at which that character is found.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
NOTLOWER(string <, start>)
Searches a character string for a character that is not a lowercase letter, and returns the first position at which that character is found.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
NOTNAME('expression'[, start])
Searches a character string for an invalid character in a SAS variable name under VALIDVARNAME=V7, and returns the first character position at which that character is found.
Product: Base SAS
Document: SAS DS2 Language Reference
NOTNAME('expression'[, start])
Searches a character string for an invalid character in a SAS variable name under VALIDVARNAME=V7, and returns the first character position at which that character is found.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
NOTNAME(string <, start>)
Searches a character string for an invalid character in a SAS variable name under VALIDVARNAME=V7, and returns the first position at which that character is found.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
NOTPRINT('expression'[, start])
Searches a character string for a nonprintable character, and returns the first character position at which that character is found.
Product: Base SAS
Document: SAS DS2 Language Reference
NOTPRINT(string <, start>)
Searches a character string for a nonprintable character, and returns the first position at which that character is found.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
NOTPUNCT('expression'[, start])
Searches a character string for a character that is not a punctuation character, and returns the first character position at which that character is found.
Product: Base SAS
Document: SAS DS2 Language Reference
NOTPUNCT('expression'[, start])
Searches a character string for a character that is not a punctuation character, and returns the first character position at which that character is found.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
NOTPUNCT(string <, start>)
Searches a character string for a character that is not a punctuation character, and returns the first position at which that character is found.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
NOTSPACE('expression'[, start])
Searches a character string for a character that is not a whitespace character (blank, horizontal and vertical tab, carriage return, line feed, and form feed), and returns the first character position at which that character is found.
Product: Base SAS
Document: SAS DS2 Language Reference
NOTSPACE('expression'[, start])
Searches a character string for a character that is not a whitespace character (blank, horizontal and vertical tab, carriage return, line feed, and form feed), and returns the first character position at which that character is found.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
NOTSPACE(string <, start>)
Searches a character string for a character that is not a whitespace character (blank, horizontal and vertical tab, carriage return, line feed, and form feed), and returns the first position at which that character is found.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
NOTUPPER('expression'[, start])
Searches a character string for a character that is not an uppercase letter, and returns the first character position at which that character is found.
Product: Base SAS
Document: SAS DS2 Language Reference
NOTUPPER('expression'[, start])
Searches a character string for a character that is not an uppercase letter, and returns the first character position at which that character is found.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
NOTUPPER(string <, start>)
Searches a character string for a character that is not an uppercase letter, and returns the first position at which that character is found.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
NOTXDIGIT('expression'[, start])
Searches a character string for a character that is not a hexadecimal character, and returns the first character position at which that character is found.
Product: Base SAS
Document: SAS DS2 Language Reference
NOTXDIGIT('expression'[, start])
Searches a character string for a character that is not a hexadecimal character, and returns the first character position at which that character is found.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
NOTXDIGIT(string <, start>)
Searches a character string for a character that is not a hexadecimal character, and returns the first position at which that character is found.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
NPV(r, freq, c0, c1, ..., cn)
Returns the net present value with the rate expressed as a percentage.
Product: Base SAS
Document: SAS DS2 Language Reference
NPV(r, freq, c0, c1, ..., cn)
Returns the net present value with the rate expressed as a percentage.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
NPV(r, frequency, c0, c1, ..., cn)
Returns the net present value with the rate expressed as a percentage.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
NULL(expression)
Returns a 1 if the argument is null and a 0 if the argument is not null.
Product: Base SAS
Document: SAS DS2 Language Reference
NVALID(string <, validvarname>)
Checks the validity of a character string for use as a SAS variable name.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
NWKDOM(n, weekday, month, year)
Returns the date for the nth occurrence of a weekday for the specified month and year.
Product: Base SAS
Document: SAS DS2 Language Reference
NWKDOM(n, weekday, month, year)
Returns the date for the nth occurrence of a weekday for the specified month and year.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
NWKDOM(n, weekday, month, year)
Returns the date for the nth occurrence of a weekday for the specified month and year.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
OCTET_LENGTH(expression)
Returns the number of bytes in a string of any data type.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
OPEN(<data-set-name <, mode <, generation-number <, type>>>>)
Opens a SAS data set.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
ORDINAL(position, expression-1, expression-2 [, ...expression-n])
Orders a list of values, and returns a value that is based on a position in the list.
Product: Base SAS
Document: SAS DS2 Language Reference
ORDINAL(position, expression-1, expression-2 [, ...expression-n])
Orders a list of values, and returns a value that is based on a position in the list.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
ORDINAL(k, argument-1, argument-2 <, ...argument-n>)
Returns the kth smallest of the missing and nonmissing values.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
PATHNAME((fileref | libref) <, search-ref>)
Returns the physical name of an external file or a SAS library, or returns a blank.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
PATHNAME((fileref | libref) <, search-reference>)
Returns the physical name of a SAS library or an external file, or returns a blank.
Product: Base SAS
Document: SAS Companion for UNIX Environments
PATHNAME((fileref | libref) <,search-level>)
Returns the physical name of a SAS library or of an external file or returns a blank.
Product: Base SAS
Document: SAS Companion for z/OS
PCTL[n](percentage, expression[, ...expression])
Returns the percentile that corresponds to the percentage.
Product: Base SAS
Document: SAS DS2 Language Reference
PCTL[n](percentage, expression[, ...expression])
Returns the percentile that corresponds to the percentage.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PCTL<n> (percentage, value–1 <, value–2, ...>)
Returns the percentile that corresponds to the percentage.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
PDF ('BERNOULLI', x, p)
Returns a value from the Bernoulli probability density (mass) distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
PDF ('BERNOULLI', x, p)
Returns a value from the Bernoulli probability density (mass) distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PDF ('BETA', x, a, b [, l, r])
Returns a value from the beta probability density (mass) distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
PDF ('BETA', x, a, b [, l, r])
Returns a value from the beta probability density (mass) distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PDF ('BINOMIAL', m, p, n)
Returns a value from the binomial probability density (mass) distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
PDF ('BINOMIAL', m, p, n)
Returns a value from the binomial probability density (mass) distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PDF ('CAUCHY', x [, θ, λ])
Returns a value from the Cauchy probability density (mass) distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
PDF ('CAUCHY', x [, θ, λ])
Returns a value from the Cauchy probability density (mass) distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PDF ('CHISQUARE', x, df [, nc])
Returns a value from the chi-square probability density (mass) distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
PDF ('CHISQUARE', x, df [, nc])
Returns a value from the chi-square probability density (mass) distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PDF('CONMAXPOI',y,λ,ν)
Returns a value from the Conway-Maxwell-Poisson probability density (mass) distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
PDF('CONMAXPOI',y,λ,ν)
Returns a value from the Conway-Maxwell-Poisson probability density (mass) distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PDF ('EXPONENTIAL', x [, λ])
Returns a value from the exponential probability density (mass) distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
PDF ('EXPONENTIAL', x [, λ])
Returns a value from the exponential probability density (mass) distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PDF ('F', x, ndf, ddf [, nc])
Returns a value from the F probability density (mass) distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
PDF ('F', x, ndf, ddf [, nc])
Returns a value from the F probability density (mass) distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PDF('distribution', quantile [, parameter-1, ..., parameter-k])
Returns a value from a probability density (mass) distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
PDF('distribution', quantile [, parameter-1, ..., parameter-k])
Returns a value from a probability density (mass) distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PDF(distribution, quantile <, parameter-1, ... , parameter-k>)
Returns a value from a probability density (mass) distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
PDF ('GAMMA', x, a [, λ])
Returns a value from the gamma probability density (mass) distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
PDF ('GAMMA', x, a [, λ])
Returns a value from the gamma probability density (mass) distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PDF ('GENPOISSON', x, θ, η)
Returns a value from the generalized Poisson probability density (mass) distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
PDF ('GENPOISSON', x, θ, η)
Returns a value from the generalized Poisson probability density (mass) distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PDF ('GEOMETRIC', m, p)
Returns a value from the geometric probability density (mass) distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
PDF ('GEOMETRIC', m, p)
Returns a value from the geometric probability density (mass) distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PDF ('HYPER', x, N, R, n [, o])
Returns a value from a hypergeometric probability density (mass) distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
PDF ('HYPER', x, N, R, n [, o])
Returns a value from a hypergeometric probability density (mass) distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PDF ('LAPLACE', x [, θ, λ])
Returns a value from the Laplace probability density (mass) distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
PDF ('LAPLACE', x [, θ, λ])
Returns a value from the Laplace probability density (mass) distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PDF ('LOGISTIC', x [, θ, λ])
Returns a value from the logistic probability density (mass) distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
PDF ('LOGISTIC', x [, θ, λ])
Returns a value from the logistic probability density (mass) distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PDF ('LOGNORMAL', x [, θ, λ])
Returns a value from the lognormal probability density (mass) distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
PDF ('LOGNORMAL', x [, θ, λ])
Returns a value from the lognormal probability density (mass) distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PDF ('NEGBINOMIAL', m, p, n)
Returns the value from the negative binomial probability density (mass) distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
PDF ('NEGBINOMIAL', m, p, n)
Returns the value from the negative binomial probability density (mass) distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PDF ('NORMAL', x [, θ, λ])
Returns a value from the normal probability density (mass) distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
PDF ('NORMAL', x [, θ, λ])
Returns a value from the normal probability density (mass) distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PDF ('NORMALMIX', x, n, p1, p2, ... pn, m1, m2, ... mn, s1, s2, ... sn)
Returns a value from the normal mixture probability density (mass) distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
PDF ('NORMALMIX', x, n, p1, p2, ... pn, m1, m2, ... mn, s1, s2, ... sn)
Returns a value from the normal mixture probability density (mass) distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PDF ('PARETO', x, a [, k])
Returns a value from the Pareto probability density (mass) distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
PDF ('PARETO', x, a [, k])
Returns a value from the Pareto probability density (mass) distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PDF ('POISSON', n, m)
Returns a value from the Poisson probability density (mass) distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
PDF ('POISSON', n, m)
Returns a value from the Poisson probability density (mass) distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PDF ('T', t, df [, nc])
Returns a value from the T probability density (mass) distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
PDF ('T', t, df [, nc])
Returns a value from the T probability density (mass) distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PDF ('TWEEDIE', y, p [, µ, φ])
Returns a value from the Tweedie probability density (mass) distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
PDF ('TWEEDIE', y, p [, µ, φ])
Returns a value from the Tweedie probability density (mass) distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PDF ('UNIFORM', x [, l, r])
Returns a value from the uniform probability density (mass) distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
PDF ('UNIFORM', x [, l, r])
Returns a value from the uniform probability density (mass) distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PDF ('WALD', x, λ [, µ])
PDF ('IGAUSS', x, λ [, µ])
Returns a value from the Wald (also known as the inverse Gaussian) probability density (mass) distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
PDF ('WALD', x, λ [, µ])
PDF ('IGAUSS', x, λ [, µ])
Returns a value from the Wald (also known as the inverse Gaussian) probability density (mass) distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PDF('WEIBULL', x, a [, λ])
Returns a value from the Weibull probability density (mass) distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
PDF('WEIBULL', x, a [, λ])
Returns a value from the Weibull probability density (mass) distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PEEK(address <, length>)
Stores the contents of a memory address in a numeric variable on a 32-bit platform.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
PEEKC(address <, length>)
Stores the contents of a memory address in a character variable on a 32-bit platform.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
PEEKCLONG(address <, length>)
Stores the contents of a memory address in a character variable on 32-bit and 64-bit platforms.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
PEEKCLONG(address<,length>)
Stores the contents of a memory address in a character variable.
Product: Base SAS
Document: SAS Companion for z/OS
PEEKLONG(address <, length>)
Stores the contents of a memory address in a numeric variable on 32-bit and 64-bit platforms.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
PEEKCLONG(address, length)
PEEKLONG(address, length)
Stores the contents of a memory address in a numeric variable on 32-bit and 64-bit platforms.
Product: Base SAS
Document: SAS Companion for UNIX Environments
PEEKLONG(address< ,length) >
Stores the contents of a memory address in a numeric variable on 32-bit and 64-bit platforms.
Product: Base SAS
Document: SAS Companion for Windows
PEEKLONG(address<,length>)
Stores the contents of a memory address in a numeric variable.
Product: Base SAS
Document: SAS Companion for z/OS
PERM(n[, r])
Computes the number of permutations of n items that are taken r at a time.
Product: Base SAS
Document: SAS DS2 Language Reference
PERM(n[, r])
Computes the number of permutations of n items that are taken r at a time.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PERM(n <, r>)
Computes the number of permutations of n items that are taken r at a time.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
PI()
Returns the constant value of PI as a floating-point value.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PMT(rate, number-of-periods, principal-amount[, future-amount][, type])
Returns the periodic payment for a constant payment loan or the periodic savings for a future balance.
Product: Base SAS
Document: SAS DS2 Language Reference
PMT(rate, number-of-periods, principal-amount[, future-amount][, type])
Returns the periodic payment for a constant payment loan or the periodic savings for a future balance.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PMT(rate, number-of-periods, principal-amount, <future-amount>, <type>)
Returns the periodic payment for a constant payment loan or the periodic savings for a future balance.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
POINT(data-set-id, note-id)
Locates an observation that is identified by the NOTE function.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
POISSON(m, n)
Returns the probability from a Poisson distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
POISSON(m, n)
Returns the probability from a Poisson distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
POISSON(m, n)
Returns the probability from a Poisson distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
POWER(numeric-expression, whole-number-expression)
Returns the value of a numeric value expression raised to a specified power.
Product: Base SAS
Document: SAS DS2 Language Reference
POWER(numeric-expression, power-numeric-expression)
Returns the value of a numeric value expression raised to a specified power.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PPMT(rate, period, number-of-periods, principal-amount[, future-amount][, type])
Returns the principal payment for a given period for a constant payment loan or the periodic savings for a future balance.
Product: Base SAS
Document: SAS DS2 Language Reference
PPMT(rate, period, number-of-periods, principal-amount, <future-amount>, <type>)
Returns the principal payment for a given period for a constant payment loan or the periodic savings for a future balance.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
PROBBETA(x, a, b)
Returns the probability from a beta distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
PROBBETA(x, a, b)
Returns the probability from a beta distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PROBBETA(x, a, b)
Returns the probability from a beta distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
PROBBNML(p, n, m)
Returns the probability from a binomial distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
PROBBNML(p, n, m)
Returns the probability from a binomial distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PROBBNML(p, n, m)
Returns the probability from a binomial distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
PROBBNRM(x, y, r)
Returns a probability from a bivariate normal distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
PROBBNRM(x, y, r)
Returns a probability from a bivariate normal distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PROBBNRM(x, y, r)
Returns a probability from a bivariate normal distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
PROBCHI(x, df[, nc])
Returns the probability from a chi-square distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
PROBCHI(x, df[, nc])
Returns the probability from a chi-square distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PROBCHI(x, df <, nc>)
Returns the probability from a chi-square distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
PROBDF(x, n[, d[, type]])
Calculates significance probabilities for Dickey-Fuller tests for unit roots in time series.
Product: Base SAS
Document: SAS DS2 Language Reference
PROBF(x, ndf, ddf[, nc])
Returns the probability from an F distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
PROBF(x, ndf, ddf[, nc])
Returns the probability from an F distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PROBF(x, ndf, ddf <, nc>)
Returns the probability from an F distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
PROBGAM(x, a)
Returns the probability from a gamma distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
PROBGAM(x, a)
Returns the probability from a gamma distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PROBGAM(x, a)
Returns the probability from a gamma distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
PROBHYPR(N, K, n, x[, r])
Returns the probability from a hypergeometric distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
PROBHYPR(N, K, n, x[, r])
Returns the probability from a hypergeometric distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PROBHYPR(N, K, n, x <, r>)
Returns the probability from a hypergeometric distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
PROBIT(p)
Returns a quantile from the standard normal distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
PROBIT(p)
Returns a quantile from the standard normal distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PROBIT(p)
Returns a quantile from the standard normal distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
PROBMC(distribution, q, prob, df, nparms[, parameters])
Returns a probability or a quantile from various distributions for multiple comparisons of means.
Product: Base SAS
Document: SAS DS2 Language Reference
PROBMC(distribution, q, prob, df, nparms[, parameters])
Returns a probability or a quantile from various distributions for multiple comparisons of means.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PROBMC(distribution, q, prob, df, nparms <, parameters>)
Returns a probability or a quantile from various distributions for multiple comparisons of means.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
PROBMED(n, x)
Computes cumulative probabilities for the sample median.
Product: Base SAS
Document: SAS DS2 Language Reference
PROBMED(n, x)
Computes cumulative probabilities for the sample median.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PROBMED(n, x)
Computes cumulative probabilities for the sample median.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
PROBNEGB(p, n, m)
Returns the probability from a negative binomial distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
PROBNEGB(p, n, m)
Returns the probability from a negative binomial distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PROBNEGB(p, n, m)
Returns the probability from a negative binomial distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
PROBNORM(x)
Returns the probability from the standard normal distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
PROBNORM(x)
Returns the probability from the standard normal distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PROBNORM(x)
Returns the probability from the standard normal distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
PROBT(x, df[, nc])
Returns the probability from a t distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
PROBT([DISTINCT] expression)
Returns the probability from a t distribution of the values in an expression.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PROBT(x, df <, nc>)
Returns the probability from a t distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
PROPCASE(argument <, delimiters>)
Converts all words in an argument to proper case.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
PRXCHANGE(perl-regular-expression | regular-expression-id, times, source)
Performs a pattern-matching replacement.
Product: Base SAS
Document: SAS DS2 Language Reference
PRXCHANGE(perl-regular-expression | regular-expression-id, times, source)
Performs a pattern-matching replacement.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
PRXMATCH(perl-regular-expression, source)
Searches for a pattern match and returns the position at which the pattern is found.
Product: Base SAS
Document: SAS DS2 Language Reference
PRXMATCH(regular-expression-id | perl-regular-expression, source)
Searches for a pattern match and returns the position at which the pattern is found.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
PRXPAREN(regular-expression-id)
Returns the last bracket match for which there is a match in a pattern.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
regular-expression-id=PRXPARSE(perl-regular-expression)
Compiles a Perl regular expression (PRX) that can be used for pattern matching of a character value.
Product: Base SAS
Document: SAS DS2 Language Reference
regular-expression-id=PRXPARSE(perl-regular-expression)
Compiles a Perl regular expression (PRX) that can be used for pattern matching of a character value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
PRXPOSN(regular-expression-id, capture-buffer, source)
Returns a character string that contains the value for a capture buffer.
Product: Base SAS
Document: SAS DS2 Language Reference
PRXPOSN(regular-expression-id, capture-buffer, source)
Returns a character string that contains the value for a capture buffer.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
PTRLONGADD(pointer<, amount>)
Returns the pointer address as a character variable on 32-bit and 64-bit platforms.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
PUT(expression, format)
Returns a value using a specified format.
Product: Base SAS
Document: SAS DS2 Language Reference
PUT(source, format.)
Returns a value using a specified format.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PUT(source, format.)
Returns a value using a specified format.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
PUTC(value, format-specification <, w>)
Enables you to specify a character format at run time.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
PUTN(value, format-specification <, w <, d>>)
Enables you to specify a numeric format at run time.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
PVP(A, c, n, K, k0, y)
Returns the present value for a periodic cash flow stream (such as a bond), with repayment of principal at maturity.
Product: Base SAS
Document: SAS DS2 Language Reference
PVP(A, c, n, K, k0, y)
Returns the present value for a periodic cash flow stream (such as a bond), with repayment of principal at maturity.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
PVP(A, c, n, K, k0, y)
Returns the present value for a periodic cash flow stream (such as a bond), with repayment of principal at maturity.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
QTR(date)
Returns the quarter of the year from a SAS date value.
Product: Base SAS
Document: SAS DS2 Language Reference
QTR(date)
Returns the quarter of the year from a SAS date value.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
QTR(date)
Returns the quarter of the year from a SAS date value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
QUANTILE('distribution', probability, parameter-1, …, parameter-k)
Returns the quantile from a distribution when you specify the left probability (CDF).
Product: Base SAS
Document: SAS DS2 Language Reference
QUANTILE('distribution', probability, parameter-1, …, parameter-k)
Returns the quantile from a distribution when you specify the left probability (CDF).
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
QUANTILE(distribution, probability, parameter-1, …, parameter-k)
Returns the quantile from a distribution when you specify the left probability (CDF).
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
QUOTE(expression)
Adds double quotation marks to a character value.
Product: Base SAS
Document: SAS DS2 Language Reference
QUOTE(expression)
Adds double quotation marks to a character value.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
QUOTE(argument-1, argument-2)
Adds double quotation marks to a character value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
RADIANS(expression)
Returns the number of radians converted from a numeric degree value.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
Returns a random variate from a binomial distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
RANBIN(seed, n, p)
Returns a random variate from a binomial distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
Returns a random variate from a Cauchy distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
RANCAU(seed)
Returns a random variate from a Cauchy distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
RAND('distribution', parameter-1, ...parameter-k)
Generates random numbers from a distribution that you specify.
Product: Base SAS
Document: SAS DS2 Language Reference
RAND(distribution, parameter-1, …, parameter-k)
Generates random numbers from a distribution that you specify.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
Returns a random variate from an exponential distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
RANEXP(seed)
Returns a random variate from an exponential distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
Returns a random variate from a gamma distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
RANGAM(seed, a)
Returns a random variate from a gamma distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
RANGE(expression [, ...expression])
Returns the difference between the largest and the smallest values.
Product: Base SAS
Document: SAS DS2 Language Reference
RANGE([DISTINCT] expression)
Returns the range between values in an expression.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
RANGE(argument-1 <, ...argument-n>)
Returns the range of the nonmissing values.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
RANK(expression)
Returns the position of a character in the ASCII collating sequence.
Product: Base SAS
Document: SAS DS2 Language Reference
RANK(expression)
Returns the position of a character in the ASCII collating sequence.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
RANK(x)
Returns the position of a character in the ASCII collating sequence.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
RANK(x)
Returns the position of a character in the ASCII collating sequence.
Product: Base SAS
Document: SAS Companion for UNIX Environments
RANK(x)
Returns the position of a character in the ASCII collating sequence.
Product: Base SAS
Document: SAS Companion for Windows
Returns a random variate from a normal distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
RANNOR(seed)
Returns a random variate from a normal distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
Returns a random variate from a Poisson distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
RANPOI(seed, m)
Returns a random variate from a Poisson distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
Returns a random variate from a tabled probability distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
RANTBL(seed, p1...pi..., pn)
Returns a random variate from a tabled probability distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
Returns a random variate from a triangular distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
RANTRI(seed, h)
Returns a random variate from a triangular distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
Returns a random variate from a uniform distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
RANUNI(seed)
Returns a random variate from a uniform distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
rc = READ_ARRAY(data_set_name, array_variable <, 'column_name_1', 'column_name_2' , ... >);
Reads data from a SAS data set into a PROC FCMP array variable.
Product: Base SAS
Document: Base SAS Procedures Guide
RENAME(old-name, new-name <, type <, description <, password <, generation>>>>)
Renames a member of a SAS library, an entry in a SAS catalog, an external file, or a directory.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
REPEAT(expression, n)
Repeats a character expression.
Product: Base SAS
Document: SAS DS2 Language Reference
REPEAT(expression, n)
Repeats a character expression.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
REPEAT(argument, n)
Returns a character value that consists of the first argument repeated n+1 times.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
RESOLVE(argument)
Returns the resolved value of the argument after the argument has been processed by the macro facility.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
REVERSE(expression)
Reverses a character expression.
Product: Base SAS
Document: SAS DS2 Language Reference
REVERSE(expression)
Reverses a character expression.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
REVERSE(argument)
Reverses a character string.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
REWIND(data-set-id)
Positions the data set pointer at the beginning of a SAS data set.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
RIGHT(expression)
Right aligns a character expression.
Product: Base SAS
Document: SAS DS2 Language Reference
RIGHT(argument)
Right aligns a character expression.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
rc=RLINK('server-ID');
Verifies whether a connection was established between a SAS/CONNECT client and a server session.
Product: SAS/CONNECT
Document: SAS/CONNECT User’s Guide
RMS(expression [, ...expression])
Returns the root mean square.
Product: Base SAS
Document: SAS DS2 Language Reference
RMS(expression [, ...expression])
Returns the root mean square.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
RMS(argument <, argument, ...>)
Returns the root mean square of the nonmissing arguments.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
ROUND(expression [, rounding-unit])
Rounds the first argument to the nearest multiple of the second argument, or to the nearest integer when the second argument is omitted.
Product: Base SAS
Document: SAS DS2 Language Reference
ROUND(expression [, rounding-unit])
Rounds the first argument to the nearest multiple of the second argument, or to the nearest integer when the second argument is omitted.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
ROUND(argument <, rounding-unit>)
Rounds the first argument to the nearest multiple of the second argument, or to the nearest integer when the second argument is omitted.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
ROUNDE(expression [, rounding-unit])
Rounds the first argument to the nearest multiple of the second argument, and returns an even multiple when the first argument is halfway between the two nearest multiples.
Product: Base SAS
Document: SAS DS2 Language Reference
ROUNDE(argument <, rounding-unit>)
Rounds the first argument to the nearest multiple of the second argument, and returns an even multiple when the first argument is halfway between the two nearest multiples.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
ROUNDZ(expression [, rounding-unit])
Rounds the first argument to the nearest multiple of the second argument, using zero fuzzing.
Product: Base SAS
Document: SAS DS2 Language Reference
ROUNDZ(expression [, rounding-unit])
Rounds the first argument to the nearest multiple of the second argument, using zero fuzzing.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
ROUNDZ(argument <, rounding-unit>)
Rounds the first argument to the nearest multiple of the second argument, using zero fuzzing.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
cval=RSESSION(n);
Returns the name, description, and SAS version of a SAS/CONNECT server session.
Product: SAS/CONNECT
Document: SAS/CONNECT User’s Guide
sysrc=RSTITLE(session-ID, description);
Defines a description for an existing connection to a SAS/CONNECT server session.
Product: SAS/CONNECT
Document: SAS/CONNECT User’s Guide
rc = RUN_MACRO ('macro_name' <, variable_1, variable_2, ...>);
Executes a predefined SAS macro.
Product: Base SAS
Document: Base SAS Procedures Guide
rc = RUN_SASFILE ('fileref_name' <, variable-1, variable-2, ...>);
Executes SAS code in a fileref that you specify.
Product: Base SAS
Document: Base SAS Procedures Guide
SASMSG (BASENAME", "KEY", <<"QUOTE"|"DQUOTE"|"NOQUOTE">
<, "substitution 1", ..., "substitution 7">>)
Specifies a message from a data set. The returned message is based on the current locale and a specified key.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
SASMSGL("BASENAME", "KEY", "LOCALE", (, , , <<"Q"|"D"|"N">
<, "substitution 1", ..., "substitution 6">>)
Specifies a message from a data set. The message is based on a specified locale value and a specified key value.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
SAVING(f, p, r, n)
Returns the future value of a periodic saving.
Product: Base SAS
Document: SAS DS2 Language Reference
SAVING(f, p, r, n)
Returns the future value of a periodic saving.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
SAVING(f, p, r, n)
Returns the future value of a periodic saving.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
SAVINGS(base-date, initial-deposit-date, deposit-amount, deposit-number,
deposit-interval, compounding-interval, date-1, rate-1[, ...date-n, rate-n])
Returns the balance of a periodic savings by using variable interest rates.
Product: Base SAS
Document: SAS DS2 Language Reference
SAVINGS(base-date, initial-deposit-date, deposit-amount, deposit-number,
deposit-interval, compounding-interval, date-1, rate-1[, ...date-n, rate-n])
Returns the balance of a periodic savings by using variable interest rates.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
SAVINGS(base-date, initial-deposit-date, deposit-amount, deposit-number,
deposit-interval, compounding-interval, date-1, rate-2 <, date-2, rate-2, ...>)
Returns the balance of a periodic savings by using variable interest rates.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
SCAN(expression, n [, delimiters[, modifier]])
Returns the nth word from a character expression.
Product: Base SAS
Document: SAS DS2 Language Reference
SCAN(expression, n [, delimiters[, modifier]])
Returns the nth word from a character expression.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
SCAN(string, count <, character-list <, modifier>>)
Returns the nth word from a character string.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
SDF('distribution', quantile, parameter-1, ..., parameter-k)
Returns a survival function.
Product: Base SAS
Document: SAS DS2 Language Reference
SDF('distribution', quantile, parameter-1, ..., parameter-k)
Returns a survival function.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
SDF(distribution, quantile, parameter-1, ..., parameter-k)
Returns a survival function.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
SEC(expression)
Returns the secant.
Product: Base SAS
Document: SAS DS2 Language Reference
SEC(expression)
Returns the secant.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
SEC(argument)
Returns the secant.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
SECOND(time | datetime)
Returns the second from a SAS time or datetime value.
Product: Base SAS
Document: SAS DS2 Language Reference
SECOND(time | datetime)
Returns the second from a time or datetime value.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
SECOND(time | datetime)
Returns the seconds and milliseconds from a SAS time or datetime value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
SESSBUSY(session-name)
SESSBUSY(uuid)
Determines whether a CAS session is busy processing actions.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
SESSFOUND (session-name)
SESSFOUND (uuid)
Returns a 0 when a CAS session is not connected to a server and a 1 when the session is connected to a server.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
Setting SAS Locale
SETLOCALE (sas_locale)
Customize single locale elements
SETLOCALE (key,value)
Customize single locale elements
SETLOCALE (category_name, sas_locale)
Specifies the locale keys for the current SAS locale.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
SHA256('string')
Returns the result of the message digest of a specified string.
Product: Base SAS
Document: SAS DS2 Language Reference
SHA256(message)
Returns an SHA256 message digest as a 32-byte binary string for a message consisting of a character string.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
SHA256HEX('string', string_indicator);
Returns the result of the message digest of a specified string and converts the string to hexadecimal representation.
Product: Base SAS
Document: SAS DS2 Language Reference
SHA256HEX('message', flag)
Returns the SHA256 digest for a specified message, and the digest is provided in hexadecimal representation.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
SHA256HMACHEX('key', 'message' [string-indicator]);
Returns the result of the message digest of a specified string by using the Hash-based Message Authentication (HMAC) algorithm.
Product: Base SAS
Document: SAS DS2 Language Reference
SHA256HMACHEX('key', 'message' <flag>);
Returns the result of the message digest of a specified string using the HMAC algorithm.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
SIGN(expression)
Returns a number that indicates the sign of a numeric value expression.
Product: Base SAS
Document: SAS DS2 Language Reference
SIGN(expression)
Returns a number that indicates the sign of a numeric value expression.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
SIGN(argument)
Returns the sign of a value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
SIN(expression)
Returns the trigonometric sine.
Product: Base SAS
Document: SAS DS2 Language Reference
SIN(expression)
Returns the trigonometric sine.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
SIN(argument)
Returns the sine.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
SINH(expression)
Returns the hyperbolic sine.
Product: Base SAS
Document: SAS DS2 Language Reference
SINH(expression)
Returns the hyperbolic sine.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
SINH(argument)
Returns the hyperbolic sine.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
SKEWNESS(expression-1, expression-2, expression-3 [, ...expression-n])
Returns the skewness.
Product: Base SAS
Document: SAS DS2 Language Reference
SKEWNESS([DISTINCT] expression)
Returns the skewness of all values in an expression.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
SKEWNESS(argument-1, argument-2, argument-3 <,...argument-n>)
Returns the skewness of the nonmissing arguments.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
SLEEP(number-of-time-units [, time-unit])
For a specified period of time, suspends the execution of a program that invokes this function.
Product: Base SAS
Document: SAS DS2 Language Reference
SLEEP(n <, unit>)
Suspends the execution of a program that invokes this function for a period of time.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
SLEEP(n<,unit>)
Suspends execution of a SAS DATA step for a specified period of time.
Product: Base SAS
Document: SAS Companion for Windows
SMALLEST(k, expression [, ...expression])
Returns the kth smallest non-null or nonmissing value.
Product: Base SAS
Document: SAS DS2 Language Reference
SMALLEST(k, expression [, ...expression])
Returns the kth smallest non-null or nonmissing value.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
SMALLEST(k, value-1 <, value-2...>)
Returns the kth smallest nonmissing value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
SOAPWEB(IN, URL <, options>)
Calls a web service by using basic web authentication; credentials are provided in the arguments.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
SOAPWEBMETA(IN, URL <, options>)
Calls a web service by using basic web authentication; credentials for the authentication domain are retrieved from metadata.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
SOAPWIPSERVICE(IN, SERVICE <, options>)
Calls a SAS web service by using WS-Security authentication; credentials are provided in the arguments.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
SOAPWIPSRS(IN, URL, SRSURL <, options>)
Calls a SAS web service by using WS-Security authentication; credentials are provided in the arguments.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
SOAPWS(IN, URL <, options>)
Calls a web service by using WS-Security authentication; credentials are provided in the arguments.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
SOAPWSMETA(IN, URL <, options>)
Calls a web service by using WS-Security authentication; credentials for the provided authentication domain are retrieved from metadata.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
answer = SOLVE('function-name', options-array, expected-value,
argument-1 <, argument-2, ...>);
Computes implicit values of a function using the Gauss-Newton method.
Product: Base SAS
Document: Base SAS Procedures Guide
SORT(argument)
Sorts a list of variables.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
sortKey(string, <locale, strength, case_order, numeric_order, collation order> )
Creates a linguistic sort key.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
SOUNDEX(argument)
Encodes a string to facilitate searching.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
SPEDIS(query, keyword)
Determines the likelihood of two words matching, expressed as the asymmetric spelling distance between the two words.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
int spqlcolinfo(void *stmttok, int *ncols, spqlcinfo_t **colvec)
Gets column information from a statement token.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
int spqlconnect(char *constr, void **contok)
Establishes a connection to a specified server’s SQL processor.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
int spqldisconnect(void *contok)
Terminates a connection from the server’s SQL processor specified with an SPQLDISCONNECT().
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
int spqlfetch(void *stmttok, void **bufptr, int *bufsize)
Gets row data from a statement token.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
int spqlfreestok(int void *stmttok)
Frees resources used by a previously performed statement.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
int spqlgmsg(char **mbuf)
Accesses thread-specific error or diagnostic message buffer contents.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
int spqlinit(void)
Initializes the SPQL library for operation.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
int spqlperform(void *contok, char *stmtbuf, int stmtlen, int *actions, void **stmttok)
Submits an SQL statement for execution on a given connection.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
int spqltabinfo(void *stmttok, spqltinfo_t **tinfo)
Gets table information from a statement token.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
int spqlterm(void)
Is the termination counterpart of the spqlinit() function.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
SQLEXEC('sql-text')
Executes a FedSQL statement to create, delete, or update a table or to insert rows into a table.
Product: Base SAS
Document: SAS DS2 Language Reference
SQRT(expression)
Returns the square root of a value.
Product: Base SAS
Document: SAS DS2 Language Reference
SQRT(expression)
Returns the square root of a value.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
SQRT(argument)
Returns the square root of a value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
SQUANTILE('distribution', probability, parameter-1, ..., parameter-k)
Returns the quantile from a distribution when you specify the right probability (SDF).
Product: Base SAS
Document: SAS DS2 Language Reference
SQUANTILE('distribution', probability, parameter-1, ..., parameter-k)
Returns the quantile from a distribution when you specify the right probability (SDF).
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
SQUANTILE(distribution, probability, parameter-1, ..., parameter-k)
Returns the quantile from a distribution when you specify the right probability (SDF).
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
STD(expression-1, expression-2 [, ...expression-n])
Returns the standard deviation.
Product: Base SAS
Document: SAS DS2 Language Reference
STD(expression-1, expression-2 [, ...expression-n])
Returns the standard deviation.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
STD(argument-1, argument-2 <, ... argument-n>)
Returns the standard deviation of the nonmissing arguments.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
STDDEV([DISTINCT] expression)
Returns the statistical standard deviation of all values in an expression.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
STDERR(expression-1, expression-2 [, ...expression-n])
Returns the standard error of the mean.
Product: Base SAS
Document: SAS DS2 Language Reference
STDERR([DISTINCT] expression)
Returns the statistical standard error of all values in an expression.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
STDERR(argument-1, argument-2 <, ...argument-n>)
Returns the standard error of the mean of the nonmissing arguments.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
STFIPS(postal-code)
Converts state postal codes to FIPS state codes.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
STNAME(postal-code)
Converts state postal codes to uppercase state names.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
STNAMEL(postal-code)
Converts state postal codes to mixed case state names.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
STPSRV_HEADER(Header Name,Header Value)
Adds or modifies a header.
Product: SAS Integration Technologies
Document: SAS Stored Processes: Developer’s Guide
STPSRV_SESSION('command',<timeout>)
Creates or deletes a session.
Product: SAS Integration Technologies
Document: SAS Stored Processes: Developer’s Guide
STPSRV_UNQUOTE2(paramname)
Unmasks quotation mark characters in an input parameter.
Product: SAS Integration Technologies
Document: SAS Stored Processes: Developer’s Guide
STPSRVGETC(valuecode)
Returns the character value of a server property.
Product: SAS Integration Technologies
Document: SAS Stored Processes: Developer’s Guide
STPSRVGETN(valuecode)
Returns the numeric value of a server property.
Product: SAS Integration Technologies
Document: SAS Stored Processes: Developer’s Guide
STPSRVSET(SESSION TIMEOUT, newvalue)
Sets the value of a server session time-out.
Product: SAS Integration Technologies
Document: SAS Stored Processes: Developer’s Guide
STREAMINIT([seed])
STREAMINIT([RNG]
STREAMINIT([RNG, seed]
Specifies a random-number generator and seed value for generating random numbers.
Product: Base SAS
Document: SAS DS2 Language Reference
STRIP(expression)
Returns a character string with all leading and trailing blanks removed.
Product: Base SAS
Document: SAS DS2 Language Reference
STRIP(string)
Returns a character string with all leading and trailing blanks removed.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
STUDENTS_T([DISTINCT] expression)
Returns the Student's t distribution of the values in an expression.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
SUBPAD(string, position <, length>)
Returns a substring that has a length that you specify, using blank padding if necessary.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
SUBSTR (character-variable, position-expression [, length-expression]) = characters-to-replace
Replaces a substring of content in a character variable.
Product: Base SAS
Document: SAS DS2 Language Reference
SUBSTR(variable, position <, length>)=characters-to-replace
Replaces character value contents.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
SUBSTR(character-expression, position-expression [, length-expression])
Extracts a substring from an argument.
Product: Base SAS
Document: SAS DS2 Language Reference
SUBSTR(string, position <, length>)
Extracts a substring from an argument.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
SUBSTRING(character-string FROM position [FOR length])
Extracts a substring from a character string.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
SUBSTRING (sql-expression FROM start <FOR length>)
Returns a part of a character expression.
Product: Base SAS
Document: SAS SQL Procedure User’s Guide
SUBSTRN(expression, position-expression[, length-expression])
Returns a substring, allowing a result with a length of zero.
Product: Base SAS
Document: SAS DS2 Language Reference
SUBSTRN(string, position <, length>)
Returns a substring, allowing a result with a length of zero.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
SUM(expression-1, expression-2 [, ...expression-n])
Returns the sum of the non-null or nonmissing arguments.
Product: Base SAS
Document: SAS DS2 Language Reference
SUM([DISTINCT] expression)
Returns the sum of all the values in an expression.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
SUM(argument-1 <, argument-2, ...>)
Returns the sum of the nonmissing arguments.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
SUMABS(value-1[, ...value-n])
Returns the sum of the absolute values of the nonmissing arguments.
Product: Base SAS
Document: SAS DS2 Language Reference
SUMABS(value-1[, ...value-n])
Returns the sum of the absolute values of the nonmissing arguments.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
SUMABS(value-1 <, value-2 ...>)
Returns the sum of the absolute values of the nonmissing arguments.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
SYMEXIST(argument)
Returns an indication of the existence of a macro variable.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
SYMGET(argument)
Returns the value of a macro variable during DATA step execution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
SYMGLOBL(argument)
Returns an indication of whether a macro variable is in global scope to the DATA step during DATA step execution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
SYMLOCAL(argument)
Returns an indication of whether a macro variable is in local scope to the DATA step during DATA step execution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
SYSEXIST(argument)
Returns a value that indicates whether an operating-environment variable exists in your environment.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
SYSGET('environment-variable')
SYSGET(operating-environment-variable)
Returns the value of the specified operating environment variable.
Product: Base SAS
Document: SAS DS2 Language Reference
SYSGET('environment-variable')
SYSGET(operating-environment-variable)
Returns the value of the specified operating environment variable.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
SYSGET('environment-variable')
SYSGET(operating-environment-variable)
Returns the value of the specified operating-environment variable.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
SYSGET('environment-variable')
Returns the value of the specified operating environment variable.
Product: Base SAS
Document: SAS Companion for UNIX Environments
SYSGET(operating-environment-variable)
Returns the value of the specified operating-environment variable.
Product: Base SAS
Document: SAS Companion for z/OS
SYSMSG()
Returns error or warning message text from processing the last data set or external file function.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
SYSPARM()
Returns the system parameter string.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
SYSPROCESSID()
Returns the process ID of the current process.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
SYSPROCESSNAME(<process_id>)
Returns the process name that is associated with a given process ID, or returns the name of the current process.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
SYSPROD(product-name)
Determines whether a product is licensed.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
SYSRC()
Returns a system error number.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
SYSTEM(command)
Issues an operating environment command during a SAS session, and returns the system return code.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
SYSTEM(command)
Executes an operating environment command and returns the command return code.
Product: Base SAS
Document: SAS Companion for z/OS
TAN(expression)
Returns the tangent.
Product: Base SAS
Document: SAS DS2 Language Reference
TAN(expression)
Returns the tangent.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
TAN(argument)
Returns the tangent.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
TANH(expression)
Returns the hyperbolic tangent.
Product: Base SAS
Document: SAS DS2 Language Reference
TANH(expression)
Returns the hyperbolic tangent.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
TANH(argument)
Returns the hyperbolic tangent.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
TIME( )
Returns the current time of day as a numeric SAS time value.
Product: Base SAS
Document: SAS DS2 Language Reference
TIME()
Returns the current time of day as a numeric SAS time value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
TIMEPART(datetime)
Extracts a time value from a SAS datetime value.
Product: Base SAS
Document: SAS DS2 Language Reference
TIMEPART(ts)
Returns the time as hours, minutes, and seconds.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
TIMEPART(datetime)
Extracts a time value from a SAS datetime value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
TIMEVALUE(base-date, reference-date, reference-amount, compounding-interval,
date-1, rate-1[, ...date-n, rate-n])
Returns the equivalent of a reference amount at a base date by using variable interest rates.
Product: Base SAS
Document: SAS DS2 Language Reference
TIMEVALUE(base-date, reference-date, reference-amount, compounding-interval,
date-1, rate-1[, ...date-n, rate-n])
Returns the equivalent of a reference amount at a base date by using variable interest rates.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
TIMEVALUE(base-date, reference-date, reference-amount, compounding-interval,
date-1, rate-1 <, date-2, rate-2, ...>)
Returns the equivalent of a reference amount at a base date by using variable interest rates.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
TINV(p, df[, nc])
Returns a quantile from the t distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
TINV(p, df[, nc])
Returns a quantile from the t distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
TINV(p, df <, nc>)
Returns a quantile from the t distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
TNONCT(x, df, prob)
Returns the value of the noncentrality parameter from the Student's t distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
TNONCT(x, df, prob)
Returns the value of the noncentrality parameter from the Student's t distribution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
TNONCT(x, df, prob)
Returns the value of the noncentrality parameter from the Student's t distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
TO_DATE(date)
Returns a DATE value from a DOUBLE value that specifies a SAS date value.
Product: Base SAS
Document: SAS DS2 Language Reference
TO_DOUBLE (date | time | timestamp)
Returns a DOUBLE value that specifies a SAS date, time, or datetime value, from a DATE, TIME, or TIMESTAMP value.
Product: Base SAS
Document: SAS DS2 Language Reference
TO_TIME(date)
Returns a TIME value from a DOUBLE value that specifies a SAS time value.
Product: Base SAS
Document: SAS DS2 Language Reference
TO_TIMESTAMP(date)
Returns a TIMESTAMP value from a DOUBLE value that specifies a SAS time value.
Product: Base SAS
Document: SAS DS2 Language Reference
TODAY( )
Returns the current date as a numeric SAS date value.
Product: Base SAS
Document: SAS DS2 Language Reference
TODAY( )
Returns the current date as a numeric SAS date value.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
TODAY()
Returns the current date as a numeric SAS date value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
TRANSLATE(expression, to-characters, from-characters)
Replaces specific characters in a character expression.
Product: Base SAS
Document: SAS DS2 Language Reference
TRANSLATE(source, to-1, from-1 <, ...to-n, from-n>)
Replaces specific characters in a character expression.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
TRANSLATE(source, to-1, from-1 <, ...to-n, from-n>)
Replaces specific characters in a character expression.
Product: Base SAS
Document: SAS Companion for UNIX Environments
TRANSLATE(source,to-1,from-1 < ,…to-n,from-n >)
Replaces specific characters in a character expression.
Product: Base SAS
Document: SAS Companion for Windows
TRANSLATE(source, to-1, from-1, <to-n, from-2 ...>)
Replaces specific characters in a character expression.
Product: Base SAS
Document: SAS Companion for z/OS
TRANSTRN(source-expression, target-expression, replacement-expression)
Replaces or removes all occurrences of a substring in a character string.
Product: Base SAS
Document: SAS DS2 Language Reference
TRANSTRN(source-expression, target-expression, replacement-expression)
Replaces or removes all occurrences of a substring in a character string.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
TRANSTRN(source, target, replacement)
Replaces or removes all occurrences of a substring in a character string.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
TRANTAB(string, trantab_name)
Transcodes data by using the specified translation table.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
TRANWRD(source-expression, target-expression, replacement-expression)
Replaces all occurrences of a substring in a character string.
Product: Base SAS
Document: SAS DS2 Language Reference
TRANWRD(source-expression, target-expression, replacement-expression)
Replaces all occurrences of a substring in a character string.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
TRANWRD(source, target, replacement)
Replaces all occurrences of a substring in a character string.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
TRIGAMMA(expression)
Returns the value of the trigamma function.
Product: Base SAS
Document: SAS DS2 Language Reference
TRIGAMMA(expression)
Returns the value of the trigamma function.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
TRIGAMMA(argument)
Returns the value of the trigamma function.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
TRIM('expression')
Removes trailing blanks from a character expression, and returns a string with a length of zero if the expression is missing.
Product: Base SAS
Document: SAS DS2 Language Reference
TRIM([BOTH | LEADING | TRAILING] [trim-character] FROM column)
Removes leading characters, trailing characters, or both from a character string.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
TRIM(argument)
Removes trailing blanks from a character string and returns one blank if the string is missing.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
TRIMN(argument)
Removes trailing blanks from character expressions and returns a string with a length of zero if the expression is missing.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
TRUNC(expression, length-expression)
Truncates a numeric value to a specified length.
Product: Base SAS
Document: SAS DS2 Language Reference
TRUNC(expression, length-expression)
Truncates a numeric value to a specified length.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
TRUNC(number, length)
Truncates a numeric value to a specified number of bytes.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
TSO(command)
Issues an operating environment command during a SAS session and returns the system return code.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
TSO(command)
Issues an operating environment command during a SAS session and returns the system return code.
Product: Base SAS
Document: SAS Companion for z/OS
TYPEOF(column)
Returns a value that indicates whether the argument is character or numeric.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
TZONEDSTNAME()
TZONEDSTNAME(<time-zone-id>)
Returns a daylight savings time name.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
TZONEDSTOFF()
TZONEDSTOFF(<time-zone-id>)
Returns the time zone offset value for the specified daylight savings time.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
TZONEID<(time-zone-id)>
Returns the current time zone ID.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
TZONEID<(time-zone-id)>
Returns the current time zone ID.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
TZONENAME()
TZONENAME(<time-zone-id,datetime>)
Returns the current standard or daylight savings time, time zone name.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
TZONENAME()
TZONENAME(<time-zone-id,datetime>)
Returns the current standard or daylight savings time, time zone name.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
TZONEOFF()
TZONEOFF(<time-zone-id, datetime>)
Returns the user time zone offset.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
TZONEOFF()
TZONEOFF(<time-zone-id, datetime>)
Returns the user time zone offset.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
TZONES2U (<datetime, time-zone-id>)
Converts a SAS date time value to a UTC date time value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
TZONES2U (<datetime, time-zone-id>)
Converts a SAS date time value to a UTC date time value.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
TZONESTTNAME()
TZONESTTNAME(<time-zone-id>)
Returns a standard time zone name.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
TZONESTTOFF()
TZONESTTOFF(<time-zone id>)
Returns the time zone offset value for the specified standard time.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
TZONEU2S (<UTC date time value,time-zone id>)
Converts a UTC date time value to a SAS date time value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
TZONEU2S (<UTC date time value,time-zone id>)
Converts a UTC date time value to a SAS date time value.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
STR=UNICODE(<instr> (,<Unicode type> ))
Converts Unicode characters to the current SAS session encoding.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
STR=UNICODEC(<instr> (,<Unicode type> ))
Converts characters in the current SAS session encoding to Unicode characters.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
UNICODELEN()
Specifies the length of the character unit for the Unicode data.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
UNICODEWIDTH()
Specifies the length of a display unit for the Unicode data.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
Returns a random variate from a uniform distribution.
Product: Base SAS
Document: SAS DS2 Language Reference
Returns a random variate from a uniform distribution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
UPCASE(expression)
Converts all letters in an argument to uppercase.
Product: Base SAS
Document: SAS DS2 Language Reference
UPCASE(expression)
Converts all letters in an argument to uppercase.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
UPCASE(argument)
Converts all lowercase single-width English alphabet letters in an argument to uppercase.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
UPPER (sql-expression)
Converts the case of a character string to uppercase.
Product: Base SAS
Document: SAS SQL Procedure User’s Guide
URLDECODE(expression)
Returns a string that was decoded using the URL escape syntax.
Product: Base SAS
Document: SAS DS2 Language Reference
URLDECODE(expression)
Returns a string that was decoded using the URL escape syntax.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
URLDECODE(argument)
Returns a string that was decoded using the URL escape syntax.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
URLENCODE(expression)
Returns a string that was encoded using the URL escape syntax.
Product: Base SAS
Document: SAS DS2 Language Reference
URLENCODE(expression)
Returns a string that was encoded using the URL escape syntax.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
URLENCODE(argument)
Returns a string that was encoded using the URL escape syntax.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
USS(expression [, ...expression-n])
Returns the uncorrected sum of squares.
Product: Base SAS
Document: SAS DS2 Language Reference
USS([DISTINCT] expression)
Returns the uncorrected sum of squares of all the values in an expression.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
USS(argument-1 <, ...argument-n>)
Returns the uncorrected sum of squares of the nonmissing arguments.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
UUIDGEN( )
Returns the short form of a Universally Unique Identifier (UUID).
Product: Base SAS
Document: SAS DS2 Language Reference
UUIDGEN(<maximum-warnings <, binary-result>>)
Returns a Universally Unique Identifier (UUID) as a string of 36 hexadecimal characters and hyphens or a binary value of 16 bytes.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
VAR(expression-1, expression-2 [ ,...expression-n])
Returns the variance.
Product: Base SAS
Document: SAS DS2 Language Reference
VAR(expression-1, expression-2 [ ,...expression-n])
Returns the variance.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
VAR(argument-1, argument-2 <, ...argument-n>)
Returns the variance of the nonmissing arguments.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
VARFMT(data-set-id, variable-number)
Returns the format that is assigned to a SAS data set variable.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
VARIANCE([DISTINCT] expression)
Returns the measure of the dispersion of all values in an expression.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
VARINFMT(data-set-id, variable-number)
Returns the informat that is assigned to a SAS data set variable.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
VARLABEL(data-set-id, variable-number)
Returns the label that is assigned to a SAS data set variable.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
VARLEN(data-set-id, variable-number)
Returns the length of a SAS data set variable.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
VARNAME(data-set-id, variable-number)
Returns the name of a SAS data set variable.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
VARNUM(data-set-id, variable-name)
Returns the number of a variable's position in a SAS data set.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
VARRAY(name)
Returns a value that indicates whether the specified name is an array.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
VARRAYX(expression)
Returns a value that indicates whether the value of the specified argument is an array.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
VARTRANSCODE(data-set-id, var-num)
Returns the transcode attribute of a SAS data set variable.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
VARTYPE(data-set-id, variable-number)
Returns the data type of a SAS data set variable.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
VERIFY(target-expression, search–expression)
Returns the position of the first character that is unique to an expression.
Product: Base SAS
Document: SAS DS2 Language Reference
VERIFY(target-expression, search–expression)
Returns the position of the first character that is unique to an expression.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
VERIFY(source, excerpt-1 <, ...excerpt-n>)
Returns the position of the first character in a string that is not in specified data strings.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
VFORMAT(variable | variable-list[i] | variable-array[i])
Returns the format that is associated with the specified variable.
Product: Base SAS
Document: SAS DS2 Language Reference
VFORMAT(variable)
Returns the format that is associated with the specified variable.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
VFORMATD(variable)
Returns the decimal value of the format that is associated with the specified variable.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
VFORMATDX(expression)
Returns the decimal value of the format that is associated with the value of the specified argument.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
VFORMATN(variable)
Returns the format name that is associated with the specified variable.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
VFORMATNX(expression)
Returns the format name that is associated with the value of the specified argument.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
VFORMATW(variable)
Returns the format width that is associated with the specified variable.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
VFORMATWX(expression)
Returns the format width that is associated with the value of the specified argument.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
VFORMATX(expression)
Returns the format that is associated with the value of the specified argument.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
VINARRAY(variable | variable-list[i] | variable-array[i])
Returns a value that indicates whether the specified variable is a member of an array.
Product: Base SAS
Document: SAS DS2 Language Reference
VINARRAY(variable)
Returns a value that indicates whether the specified variable is a member of an array.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
VINARRAYX(expression)
Returns a value that indicates whether the value of the specified argument is a member of an array.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
VINFORMAT(variable | variable-list[i] | variable-array[i])
Returns the informat that is associated with the specified variable.
Product: Base SAS
Document: SAS DS2 Language Reference
VINFORMAT(variable)
Returns the informat that is associated with the specified variable.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
VINFORMATD(variable)
Returns the decimal value of the informat that is associated with the specified variable.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
VINFORMATDX(expression)
Returns the decimal value of the informat that is associated with the value of the specified variable.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
VINFORMATN(variable)
Returns the informat name that is associated with the specified variable.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
VINFORMATNX(expression)
Returns the informat name that is associated with the value of the specified argument.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
VINFORMATW(variable)
Returns the informat width that is associated with the specified variable.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
VINFORMATWX(expression)
Returns the informat width that is associated with the value of the specified argument.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
VINFORMATX(expression)
Returns the informat that is associated with the value of the specified argument.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
VLABEL(variable | variable-list[i] | variable-array[i])
Returns the label that is associated with the specified variable.
Product: Base SAS
Document: SAS DS2 Language Reference
VLABEL(variable)
Returns the label that is associated with the specified variable.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
VLABELX(expression)
Returns the label that is associated with the value of the specified argument.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
VLENGTH(variable | variable-list[i] | variable-array[i])
Returns the size of the specified variable.
Product: Base SAS
Document: SAS DS2 Language Reference
VLENGTH(variable)
Returns the compile-time (allocated) size of the specified variable.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
VLENGTHX(expression)
Returns the compile-time (allocated) size for the variable with a name that is the same as the value of the argument.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
VNAME(variable | variable-list[i] | variable-array[i])
Returns the name of the specified variable.
Product: Base SAS
Document: SAS DS2 Language Reference
VNAME(variable)
Returns the name of the specified variable.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
VNAMEX(expression)
Validates the value of the specified argument as a variable name.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
VTRANSCODE (var)
Returns a value that indicates whether transcoding is enabled for the specified character variable.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
VTRANSCODEX (var)
Returns a value that indicates whether transcoding is enabled for the specified argument.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
VTYPE(variable | variable-list[i] | variable-array[i])
Returns the full name of the data type that is associated with a variable.
Product: Base SAS
Document: SAS DS2 Language Reference
VTYPE(variable)
Returns the type (character or numeric) of the specified variable.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
VTYPEX(expression)
Returns the type (character or numeric) for the value of the specified argument.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
VVALUE(variable)
Returns the formatted value that is associated with the variable that you specify.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
VVALUEX(expression)
Returns the formatted value that is associated with the argument that you specify.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
WAKEUP(until-when)
Specifies the amount of time a SAS DATA step continues execution.
Product: Base SAS
Document: SAS Companion for Windows
WEEK([sas-date], ['descriptor'])
Returns the week-number value.
Product: Base SAS
Document: SAS DS2 Language Reference
WEEK([sas-date], ['descriptor'])
Returns the week-number value.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
WEEK(<sas-date>, <'descriptor'>)
Returns the week-number value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
WEEKDAY(expression)
From a SAS date value, returns a whole number that corresponds to the day of the week.
Product: Base SAS
Document: SAS DS2 Language Reference
WEEKDAY(expression)
From a SAS date value, returns a whole number that corresponds to the day of the week.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
WEEKDAY(date)
From a SAS date value, returns an integer that corresponds to the day of the week.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
WHICHC(search-expression, expression-list-item-1, expression-list-item-2
[, ...expression-list-item-n])
Returns the first position of a character string from a list of character strings.
Product: Base SAS
Document: SAS DS2 Language Reference
WHICHC(search-expression, expression-list-item-1, expression-list-item-2
[, ...expression-list-item-n])
Returns the first position of a character string from a list of character strings.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
WHICHC(string, value-1 <, value-2, ...>)
Searches for a character value that is equal to the first argument, and returns the index of the first matching value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
WHICHN(search-expression, expression-list-item-1, expression-list-item-2
[, ...expression-list-item-n])
Returns the first position of a number from a list of numbers.
Product: Base SAS
Document: SAS DS2 Language Reference
WHICHN(search-expression, expression-list-item-1, expression-list-item-2
[, ...expression-list-item-n])
Returns the first position of a number from a list of numbers.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
WHICHN(argument, value-1 <, value-2, ...>)
Searches for a numeric value that is equal to the first argument, and returns the index of the first matching value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
rc = WRITE_ARRAY(data_set_name, array_variable <, 'column_name_1', 'column_name_2', ...>);
Writes data from a PROC FCMP array variable to a data set that can then be used by SAS programs, macros, and procedures.
Product: Base SAS
Document: Base SAS Procedures Guide
WTO(“text-string” | var)
Sends a message to the system console.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
WTO(“text-string” | var)
Sends a message to the system console.
Product: Base SAS
Document: SAS Companion for z/OS
YEAR(date)
Returns the year from a SAS date value.
Product: Base SAS
Document: SAS DS2 Language Reference
YEAR(date | datetime)
Returns the year from a date or datetime value.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
YEAR(date)
Returns the year from a SAS date value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
YIELDP(A, c, n, K, k0, p)
Returns the yield-to-maturity for a periodic cash flow stream, such as a bond.
Product: Base SAS
Document: SAS DS2 Language Reference
YIELDP(A, c, n, K, k0, p)
Returns the yield-to-maturity for a periodic cash flow stream, such as a bond.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
YIELDP(A, c, n, K, k0, p)
Returns the yield-to-maturity for a periodic cash flow stream, such as a bond.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
YRDIF(start-date, end-date[, basis])
Returns the difference in years between two dates according to specified day count conventions; returns a person’s age.
Product: Base SAS
Document: SAS DS2 Language Reference
YRDIF(start-date, end-date[, basis])
Returns the difference in years between two dates according to specified day count conventions; returns a person’s age.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
YRDIF(start-date, end-date, < basis>)
Returns the difference in years between two dates according to specified day count conventions; returns a person’s age.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
YYQ(year, quarter)
Returns a SAS date value from year and quarter year values.
Product: Base SAS
Document: SAS DS2 Language Reference
YYQ(year, quarter)
Returns a SAS date value from year and quarter year values.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
YYQ(year, quarter)
Returns a SAS date value from year and quarter year values.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
zdsattr(variable name, <option>);
Returns the attributes of a data set name or UFS filename.
Product: Base SAS
Document: SAS Companion for z/OS
zdsidnm(variable name, index);
Returns individual data set names from the result of the ZDSLIST function, based on an index.
Product: Base SAS
Document: SAS Companion for z/OS
zdslist(category, data set filter, volume filter, <option>);
Returns a list of data set names according to the requested criteria.
Product: Base SAS
Document: SAS Companion for z/OS
zdsnum(variable name);
Returns a count of the number of data set names that are returned from the ZDSLIST function.
Product: Base SAS
Document: SAS Companion for z/OS
zdsratt(variable name,<option>);
Returns security attributes for a z/OS data set or UFS file or directory.
Product: Base SAS
Document: SAS Companion for z/OS
zdsxatt(variable name);
Returns the number of attributes retrieved by a previous ZDSATTR or ZDSRATT request.
Product: Base SAS
Document: SAS Companion for z/OS
zdsyatt(variable name, index);
Displays attribute information that is stored by ZDSATTR or ZDSRATT.
Product: Base SAS
Document: SAS Companion for z/OS
ZIPCITY(ZIP-code)
Returns a city name and the two-character postal code that corresponds to a ZIP code.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
ZIPCITYDISTANCE(ZIP-code-1, ZIP-code-2)
Returns the geodetic distance between two ZIP code locations.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
ZIPFIPS(ZIP-code)
Converts ZIP codes to two-digit FIPS codes.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
ZIPNAME(ZIP-code)
Converts ZIP codes to uppercase state names.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
ZIPNAMEL(ZIP-code)
Converts ZIP codes to mixed-case state names.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
ZIPSTATE(ZIP-code)
Converts ZIP codes to two-character state postal codes.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
ZVOLLIST(category, <volume filter>, <option>);
Returns a list of volume serial numbers according to the requested criteria.
Product: Base SAS
Document: SAS Companion for z/OS
Last updated: March 30, 2026