General Functions Listed by Product
Base SAS
|
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: Base SAS
Document: SAS FedSQL Language Reference
| |
|
ABS(argument)
Returns the absolute value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
| |
|
ADDRLONG(variable)
Returns the memory address of a variable on a 64-bit
platform.
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: Base SAS
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 ..., variable-n>)
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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
| |
|
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: Base SAS
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: Base SAS
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: Base SAS
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
| |
|
ARCOS(expression)
Returns the arccosine in radians.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
ARCOS(expression)
Returns the arccosine in radians.
Product: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
Document: SAS FedSQL Language Reference
| |
|
ATAN2(expression-1, expression-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,
CHARSET | COMPRESS | DATAREP | ENCODING | ENCRYPT | ENGINE | LABEL | LIB | MEM | MODE | MTYPE | SORTEDBY | SORTLVL | SORTSEQ | TYPE)
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,
ALTERPW | ANOBS | ANY | ARAND | ARWU | AUDIT | AUDIT_DATA | AUDIT_BEFORE | AUDIT_ERROR | CRDTE | ICONST | INDEX | ISINDEX | ISSUBSET | LRECL | LRID | MAXGEN | MAXRC | MODTE | NDEL | NEXTGEN | NLOBS | NLOBSF | NOBS | NVARS | PW | RADIX | READPW | REUSE | TAPE | WHSTMT | WRITEPW)
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: Base SAS
Document: SAS FedSQL Language Reference
| |
|
AVG (ALL | DISTINCT
sql-expression)
Returns the arithmetic mean or average of all values in a
column.
Product: Base SAS
Document: SAS SQL Procedure User’s Guide
| |
|
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: Base SAS
Document: SAS FedSQL Language Reference
| |
|
BAND(argument-1, argument-2)
Returns the bitwise logical AND of 32-bit integer
values.
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: Base SAS
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: Base SAS
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
| |
|
BHAMMING_32(argument-1, argument-2)
Returns the bitwise Hamming distance between two
32-bit integer values.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
BHAMMING_32(argument-1, argument-2)
Returns the bitwise Hamming distance between two
32-bit integer values.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
| |
|
BHAMMING_HEX(hex-string-1,
hex-string-2);
Returns the bitwise Hamming distance between two
hexadecimal bit strings.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
BHAMMING_HEX(hex-string-1,
hex-string-2);
Returns the bitwise Hamming distance between two hexadecimal bit
strings.
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
Document: SAS FedSQL Language Reference
| |
|
BLSHIFT(argument-1, argument-2)
Returns the bitwise logical left shift of two 32-bit
integer values.
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: Base SAS
Document: SAS FedSQL Language Reference
| |
|
BNOT(argument)
Returns the bitwise logical NOT of 32-bit integer
values.
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: Base SAS
Document: SAS FedSQL Language Reference
| |
|
BOR(argument-1, argument-2)
Returns the bitwise logical OR of 32-bit integer
values.
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: Base SAS
Document: SAS FedSQL Language Reference
| |
|
BRSHIFT(argument-1, argument-2)
Returns the bitwise logical right shift of 32-bit
integer values.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
| |
|
BTRIM(<<LEADING | TRAILING | BOTH> <'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: Base SAS
Document: SAS FedSQL Language Reference
| |
|
BXOR(argument-1, argument-2)
Returns the bitwise logical EXCLUSIVE OR of two
32-bit integer values.
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 DS2 Language Reference
| |
|
BYTE(n)
Returns one character in the ASCII collating sequence.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
BYTE (n)
Returns one character in the ASCII collating sequence.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
| |
|
CASLSTORE( { CASLIB= caslib-reference-name,
NAME= caslstore-table-name}
<,{ CASLIB=caslib-reference-name-2,
NAME= caslstore-table-name-2}...
, {CASLIB= caslib-reference-name-n,
NAME=caslstore-table-name-n}>
);
CASLSTORE( {PATH=pathname} <,
{PATH=pathname-2},
..., {PATH=pathname-n}>);
Creates a caslstore value.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
CAST(expression AS data-type [(length)])
Converts a value from one data type to another.
Product: Base SAS
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: Base SAS
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: Base SAS
Document: SAS FedSQL Language Reference
| |
|
CDF('BETA', x, a, b v<, 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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
Document: SAS Functions and CALL Routines: Reference
| |
|
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,…, argument-n>)
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: Base SAS
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: Base SAS
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: Base SAS
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 collating
sequence.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
| |
|
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: Base SAS
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: Base SAS
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: Base SAS
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
| |
|
COMPFUZZ_MISS(value-1, value-2 <<, fuzz<<scale>>>>)
Performs comparisons of missing numeric values and
fuzzy comparisons of nonmissing 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: Base SAS
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: Base SAS
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
| |
|
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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([* | [DISTINCT] expression)]
Returns the number of rows retrieved by a SELECT
statement for a specified table.
Product: Base SAS
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
| |
|
COUNT (<ALL | DISTINCT>
* | sql-expression)
Returns the number of rows retrieved by a SELECT statement for a specified
table.
Product: Base SAS
Document: SAS SQL Procedure User’s Guide
| |
|
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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
| |
|
CSS (<ALL | DISTINCT>
sql-expression)
Returns the corrected sum of squares.
Product: Base SAS
Document: SAS SQL Procedure User’s Guide
| |
|
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: Base SAS
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: Base SAS
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: Base SAS
Document: SAS FedSQL Language Reference
| |
|
CURRENT_LOCALE()
Returns the five-character name of the current locale.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
CURRENT_TIME
Returns the current time for your time zone.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
CURRENT_TIME_GMT()
Returns the current GMT time.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
CURRENT_TIMESTAMP
Returns the date and time for your time zone.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
CURRENT_TIMESTAMP_GMT()
Returns the current GMT date and time.
Product: Base SAS
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: Base SAS
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
| |
|
CV (<ALL | DISTINCT>
sql-expression)
Returns the coefficient of variation (percent).
Product: Base SAS
Document: SAS SQL Procedure User’s Guide
| |
|
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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
| |
|
DEFAULT_CASLSTORE(caslstore-value);
Sets the default caslstore.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
DEGREES(expression)
Returns the number of degrees for an angle in radians.
Product: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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
| |
|
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
| |
|
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
| |
|
DOPTNAME(directory-id, nval)
Returns directory attribute information.
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 Functions and CALL Routines: Reference
| |
|
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
| |
|
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
| |
|
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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
| |
|
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: Base SAS
Document: SAS FedSQL Language Reference
| |
|
EXP(argument)
Returns the value of the exponential function.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
| |
|
EXPM1(x)
Returns 1 less than the exponential function of the
argument.
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: Base SAS
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
| |
|
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
| |
|
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
| |
|
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
| |
|
FILENAME(fileref, <filename>
<,device-type>
<, 'host-options'>
<, directory-reference>); [Linux] Assigns or deassigns a fileref to an external file,
directory, or output device.
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 Functions and CALL Routines: 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 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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
Document: SAS FedSQL Language Reference
| |
|
FINANCE('COUPDAYSNC', settlement, maturity, frequency, <basis>);
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: Base SAS
Document: SAS FedSQL Language Reference
| |
|
FINANCE('COUPNCD', settlement, maturity, frequency, <basis>);
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
Document: SAS FedSQL Language Reference
| |
|
FINANCE(string-identifier, parameter–1, parameter–2,
…, parameter-n)
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: Base SAS
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: Base SAS
Document: SAS FedSQL Language Reference
| |
|
FINANCE('FVSCHEDULE', principal, schedule-1, schedule-2 ..., schedule-n);
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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[, startpos][, modifiers])
FINDC(string, charlist, modifiers[, startpos])
FINDC(string, charlist[, modifiers])
FINDC(string[, charlist])
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
| |
|
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 DS2 Language 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 DS2 Language 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 DS2 Language 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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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
| |
|
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
| |
|
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
| |
|
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
Document: SAS FedSQL Language Reference
| |
|
GEOMEAN(argument <, argument, ..., argument-n>)
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: Base SAS
Document: SAS FedSQL Language Reference
| |
|
GEOMEANZ(argument <, argument, ..., argument-n>)
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: Base SAS
Document: SAS Functions and CALL Routines: Reference
| |
|
GETKEYS(dictionary);
Extracts the keys from the dictionary into an array.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
GETLCASLIB(libref)
Returns the caslib that was bound to a CAS LIBNAME engine libref using the
CASLIB= option when it was assigned.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
| |
|
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: Base SAS
Document: SAS Functions and CALL Routines: Reference
| |
|
GETLTAG(libref)
Returns the tag that was associated with a CAS LIBNAME engine libref in the
TAG= option when it is assigned.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
| |
|
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 Functions and CALL Routines: Reference
| |
|
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: Base SAS
Document: SAS Functions and CALL Routines: Reference
| |
|
GETTHREADERRORSTATUS()
Gets the runtime error status of the current DS2 thread.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
GETVALUES(dictionary);
Extracts the values from the dictionary into an
array.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
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)
GIT_CLONE('uri',
'directory',
'',
'',
'',
'',
'',
2,
auth-domain-ID)
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'<,'second-parent-commit-ID'>)
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', 'SLL-certificate-path',
kerberos>)
GIT_FETCH('directory',
'',
'',
'',
'',
'target-branch',
'',
2,
'auth-domain-ID')
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', 'default-branch-name'<, '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)
GIT_PULL('directory',
'',
'',
'',
'',
'',2,
auth-domain-ID)
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
GIT_PUSH('directory',
'',
'',
'',
'',
'',
2,
'auth-domain-ID')
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_REF_FREE
('directory')
Clears the reference objects that are associated with the local
repository.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
| |
|
GIT_REF_GET
(n,
'directory',
'attribute',
attribute-out
Returns the specified attribute of a reference object in the local
repository.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
| |
|
GIT_REF_LIST
('directory',
<create-data-set>)
Returns the list of reference objects that are associated with the local
repository.
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
| |
|
HARMEAN(expression [, ...expression])
Returns the harmonic mean.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
HARMEAN(expression [, ...expression])
Returns the harmonic mean.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
HARMEAN(argument <, argument, ..., argument-n>)
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: Base SAS
Document: SAS FedSQL Language Reference
| |
|
HARMEANZ(argument <, argument, ..., argument-n>)
Returns the harmonic mean, using zero fuzzing.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
| |
|
HASH_FAST_HEX(key,<arg1..., argn>)
Returns a message digest as a 16-byte hexadecimal string for a key value and a
message consisting of one or more character strings or numbers, using the fast-hash
algorithm.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
| |
|
HASH_XX_HEX(key,<arg1..., argn>)
Returns a message digest as a 16-byte hexadecimal string for a key value and a
message consisting of one or more character strings or numbers.
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 various 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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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
| |
|
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
Document: SAS FedSQL Language Reference
| |
|
IQR(value-1 <, value-2..., value-n>)
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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
| |
|
%KCMPRES (text | text
expression)
Compresses multiple blanks and removes leading and
trailing blanks.
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
| |
|
KNEXTCHAR(text,offset)
Returns a character from a string at a specified
byte offset.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
| |
|
byte_offset=KOFFSET(text<,character_position>);
Returns the byte offset from the character
position.
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
| |
|
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: Base SAS
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: Base SAS
Document: SAS FedSQL Language Reference
| |
|
LARGEST(k, value-1 <, value-2 ..., value-n>)
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: Base SAS
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: Base SAS
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: Base SAS
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 bytes 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 bytes in 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: Base SAS
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: Base SAS
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
| |
|
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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 Viya Logging Facility for SAS Programs and Jobs
| |
|
LOG4SAS_LOGEVENT("name",
"level",
"message")
Logs a message by using a specific logger.
Product: Base SAS
Document: SAS Viya Logging Facility for SAS Programs and Jobs
| |
|
LOG4SAS_LOGGER("name",
<"options">
)
Creates a logger.
Product: Base SAS
Document: SAS Viya Logging Facility for SAS Programs and Jobs
| |
|
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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 number of permutations
of n objects, and can include r number of elements.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
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 ..., value-n>)
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: Base SAS
Document: SAS FedSQL Language Reference
| |
|
MAD(value-1 <, value-2..., value-n>)
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: Base SAS
Document: SAS FedSQL Language Reference
| |
|
MAKETIME(h, m, s)
Returns the time as hours, minutes, and seconds.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
MAKETIMESTAMP(d,
t) | (y, m, d, h, m, s)
Returns the timestamp.
Product: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
Document: SAS FedSQL Language Reference
| |
|
MAX(argument-1 <, argument-2,
..., argument-n>)
Returns the largest value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
| |
|
MAX (<ALL | DISTINCT>
sql-expression)
Returns the largest value.
Product: Base SAS
Document: SAS SQL Procedure User’s Guide
| |
|
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: Base SAS
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: Base SAS
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: Base SAS
Document: SAS FedSQL Language Reference
| |
|
MEDIAN(value–1 <, value–2, ..., value-n>)
Returns the median value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
| |
|
MEDIAN (<ALL | DISTINCT>
sql-expression)
Returns median value.
Product: Base SAS
Document: SAS SQL Procedure User’s Guide
| |
|
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: Base SAS
Document: SAS FedSQL Language Reference
| |
|
MIN(argument-1 <, argument-2, ..., argument-n>)
Returns the smallest value.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
| |
|
MIN (<ALL | DISTINCT>
sql-expression)
Returns the smallest value.
Product: Base SAS
Document: SAS SQL Procedure User’s Guide
| |
|
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: Base SAS
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: Base SAS
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
| |
|
CALL
MODULE(<control-string>,module,argument-1, ..., argument-n);
MODULEN(<control-string>,module,argument-1, ..., argument-n);
MODULEC(<control-string> ,module,argument-1, ..., argument-n);
CALL MODULEI(<control-string> ,module,argument-1, ..., argument-n);
MODULEIN(<control-string> ,module,argument-1, ..., argument-n)
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
| |
|
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: Base SAS
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: Base SAS
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
| |
|
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: Base SAS
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: Base SAS
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
| |
|
rc= NDIMS(array-name)
Returns the number of dimensions in an array.
Product: Base SAS
Document: Base SAS Procedures Guide
| |
|
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: Base SAS
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: Base SAS
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
| |
|
NMISS (<ALL | DISTINCT>
sql-expression)
Returns the number of missing values in a table column.
Product: Base SAS
Document: SAS SQL Procedure User’s Guide
| |
|
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: Base SAS
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: Base SAS
Document: SAS FedSQL Language Reference
| |
|
NOTALNUM(string <, start>)
Searches a character string for a non-alphanumeric
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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
| |
|
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: Base SAS
Document: SAS FedSQL Language Reference
| |
|
PCTL<n> (percentage, value–1 <, value–2, ..., value-n>)
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
Document: SAS FedSQL Language Reference
| |
|
PEEKCLONG(address <, length>)
Stores the contents of a memory address in a character
variable on a 64-bit platform.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
| |
|
PEEKLONG(address <, length>)
Stores the contents of a memory address in a numeric
variable on a 64-bit platform.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
| |
|
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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
| |
|
PROGRAMBLOCKLINENUMBER()
Returns the line number of the current statement
starting from the beginning of the current program block.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
PROGRAMBLOCKNAME()
Returns the name of the current programming block.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
PROGRAMBLOCKTYPE()
Returns the type of the current programming block.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
PROPCASE(argument <, delimiters>)
Converts all words in an argument to proper case.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
| |
|
PRT (<ALL | DISTINCT>
sql-expression)
Specifies the two-tailed p-value for Student's t statistic, T with n - 1
degrees of freedom.
Product: Base SAS
Document: SAS SQL Procedure User’s Guide
| |
|
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 DS2 Language 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
| |
|
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 a 64-bit platform.
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: Base SAS
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 DS2 Language 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 DS2 Language 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: Base SAS
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
| |
|
%QKCMPRES (text | text
expression)
Compresses multiple blanks and removes leading and
trailing blanks.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
| |
|
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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
| |
|
RAND(distribution, parameter-1, ..., parameter-k)
Generates random numbers from a distribution that
you specify.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
RANDPERM(variable-1,
<variable-2..., variable-n)>
Randomly permutes the values of the arguments.
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: Base SAS
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
| |
|
RANGE (<ALL | DISTINCT>
sql-expression)
Returns the range of the nonmissing values.
Product: Base SAS
Document: SAS SQL Procedure User’s Guide
| |
|
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: Base SAS
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
| |
|
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: Base SAS
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
| |
|
RESOLVE(argument)
Resolves the value of a text expression during DATA
step execution.
Product: Base SAS
Document: SAS Macro Language: Reference
| |
|
REVERSE(expression)
Reverses a character expression.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
REVERSE(expression)
Reverses a character expression.
Product: Base SAS
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
| |
|
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: Base SAS
Document: SAS FedSQL Language Reference
| |
|
RMS(argument <, argument, ..., argument-n>)
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: Base SAS
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: Base SAS
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
| |
|
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
| |
|
SASLOGLINENUMBER( )
Returns the line number of the current statement
in the SAS log.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
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: Base SAS
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: Base SAS
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, ..., date-n, rate-n>) 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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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-reference)
SESSBUSY(uuid)
Determines whether a CAS session is busy processing
actions.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
| |
|
SESSFOUND
(session-reference)
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: Base SAS
Document: SAS Functions and CALL Routines: Reference
| |
|
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
| |
|
SETTHREADERRORSTATUS(status-value[, 'string'])
Sets a user-specified error status value for non-fatal runtime errors, and
optionally logs a user-specified message to the SAS log.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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
| |
|
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: Base SAS
Document: SAS FedSQL Language Reference
| |
|
SMALLEST(k, value-1 <, value-2..., value-n>)
Returns the kth
smallest nonmissing value.
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(variable)
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
| |
|
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: Base SAS
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: Base SAS
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: Base SAS
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
| |
|
STD (<ALL | DISTINCT>
sql-expression)
Returns the standard deviation of the nonmissing arguments.
Product: Base SAS
Document: SAS SQL Procedure User’s Guide
| |
|
STDDEV([DISTINCT] expression)
Returns the statistical standard deviation of all
values in an expression.
Product: Base SAS
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: Base SAS
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
| |
|
STDERR (<ALL | DISTINCT>
sql-expression)
Returns the standard error of the mean of nonmissing
arguments.
Product: Base SAS
Document: SAS SQL Procedure User’s Guide
| |
|
STFIPS(postal-code)
Converts state postal codes to FIPS state codes.
Product: Base SAS
Document: SAS DS2 Language 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 DS2 Language 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 DS2 Language Reference
| |
|
STNAMEL(postal-code)
Converts state postal codes to mixed case state
names.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
| |
|
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: Base SAS
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 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
| |
|
SUBSTR(character-expression, position-expression [, length-expression])
Extracts a substring from an argument.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
SUBSTRING(character-expression FROM position [FOR length])
Extracts a substring from a character string.
Product: Base SAS
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: Base SAS
Document: SAS FedSQL Language Reference
| |
|
SUM(argument-1 <, argument-2, ..., argument-n>)
Returns the sum of the nonmissing arguments.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
| |
|
SUM (<ALL | DISTINCT>
sql-expression)
Returns the sum of all the values.
Product: Base SAS
Document: SAS SQL Procedure User’s Guide
| |
|
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: Base SAS
Document: SAS FedSQL Language Reference
| |
|
SUMABS(value-1 <, value-2 ..., value-n>)
Returns the sum of the absolute values of the nonmissing
arguments.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
| |
|
SUMWGT (<ALL | DISTINCT>
sql-expression)
Specifies the sum of the WEIGHT variable values.
Product: Base SAS
Document: SAS SQL Procedure User’s Guide
| |
|
SYMEXIST(argument)
Returns an indication of the existence of a macro
variable.
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 Macro Language: Reference
| |
|
SYMGET(argument)
Returns the value of a macro variable during DATA
step execution.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
| |
|
SYMGET(argument)
Returns the value of a macro variable to the DATA
step during DATA step execution.
Product: Base SAS
Document: SAS Macro Language: Reference
| |
|
SCL-variable-name=SYMGETN(argument)
In SAS Component Control Language (SCL) programs,
returns the value of a global macro variable as a numeric value when
the SCL program executes.
Product: Base SAS
Document: SAS Macro Language: 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
| |
|
SYMGLOBL(argument)
Returns an indication as to whether a macro variable
is global in scope to the DATA step during DATA step execution.
Product: Base SAS
Document: SAS Macro Language: 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
| |
|
SYMLOCAL(argument)
Returns an indication as to whether a macro variable
is local in scope to the DATA step during DATA step execution.
Product: Base SAS
Document: SAS Macro Language: 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')
Returns the value of the specified operating-environment variable .
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
SYSGET('environment-variable')
Returns the value of the specified operating-environment variable .
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
SYSGET('environment-variable')
Returns the value of the specified operating-environment
variable.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
| |
|
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
| |
|
T (<ALL | DISTINCT>
sql-expression)
Specifies the student's t value for testing the hypothesis that the population
mean is zero.
Product: Base SAS
Document: SAS SQL Procedure User’s Guide
| |
|
TAN(expression)
Returns the tangent.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
TAN(expression)
Returns the tangent.
Product: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
Document: SAS FedSQL Language Reference
| |
|
TIMEVALUE(base-date, reference-date, reference-amount, compounding-interval,
date-1, rate-1 <, date-2, rate-2, ..., 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 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: Base SAS
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: Base SAS
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: Base SAS
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(expression, to-characters, from-characters)
Replaces specific characters in a character expression.
Product: Base SAS
Document: SAS FedSQL 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
| |
|
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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
| |
|
TSLVL(binary-file[,option[option-n]])
Provides information about the SAS installation
image, including the release number, hot fixes, and maintenance images.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
TSLVL(<option-1,–option-n>)
provides information about the specifics of the
installation, including the release, hot fixes, and maintenance images.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
| |
|
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: Base SAS
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
| |
|
UPLOAD_CASLSTORE({NAME=store-name <,
CASLIB=caslib-name> <,
REPLACE=TRUE | FALSE> <,
ENCRYPT=TRUE | FALSE>}, casl-code–1, <, ...casl-code-n>);
UPLOAD_CASLSTORE({PATH=path-name <,
REPLACE=TRUE | FALSE> <,
ENCRYPT=TRUE | FALSE>}, casl-code–1, <, ...casl-code-n>);
Uploads CASL functions from a specified CASL source
code string into the specified code storage repository.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL 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: Base SAS
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: Base SAS
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: Base SAS
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
| |
|
USS (<ALL | DISTINCT>
sql-expression)
Returns the uncorrected sum of squares of the nonmissing
arguments.
Product: Base SAS
Document: SAS SQL Procedure User’s Guide
| |
|
UUIDGEN( )
Returns the short form of a Universally Unique Identifier
(UUID).
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
UUIDGEN( )
Returns the short form of a Universally Unique Identifier
(UUID).
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
UUIDGEN(<maximum-warnings <, binary-result>>)
Returns a Universally Unique Identifier (UUID) as a string of 36 hexidecimal
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: Base SAS
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
| |
|
VAR (<ALL | DISTINCT>
sql-expression)
Returns the variance of the nonmissing arguments.
Product: Base SAS
Document: SAS SQL Procedure User’s Guide
| |
|
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: Base SAS
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: Base SAS
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-array\[ i
\] | varlist\[ i
\])
Returns the format that is associated with the specified
global 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
| |
|
VGETVALUE (source-variable, destination-variable )
Gets the value of the specified variable and assigns it to another variable.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
VINARRAY(variable | variable-array\[ i
\] | varlist\[ 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-array\[ i
\] | varlist\[ 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-array\[ i
\] | varlist\[ 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-array\[ i
\] | varlist\[ 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-array\[ i
\] | varlist\[ 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
| |
|
VSETMISSING(variable-name1[,...variable-nameN])
Assigns a missing or null value to the specified variable or
variables.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
VSETVALUE
(destination-variable,
value)
Sets a variable to a specified value.
Product: Base SAS
Document: SAS DS2 Language 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-array\[
i
\] | varlist\[
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
| |
|
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: Base SAS
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: Base SAS
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: Base SAS
Document: SAS FedSQL Language Reference
| |
|
WHICHC(string, value-1 <, value-2, ..., value-n>)
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: Base SAS
Document: SAS FedSQL Language Reference
| |
|
WHICHN(argument, value-1 <, value-2, ..., value-n>)
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
| |
|
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: Base SAS
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: Base SAS
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: Base SAS
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: Base SAS
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
| |
|
ZIPCITY(ZIP-code)
Returns a city name and the two-character postal
code that corresponds to a ZIP code.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
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 DS2 Language 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 DS2 Language 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 DS2 Language 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 DS2 Language 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 DS2 Language Reference
| |
|
ZIPSTATE(ZIP-code)
Converts ZIP codes to two-character state postal
codes.
Product: Base SAS
Document: SAS Functions and CALL Routines: Reference
|
SAS Data Quality Server
|
Name
|
Syntax and Description
|
|---|---|
|
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: 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: 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: 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: 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: 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: Language Reference
| |
|
DMSRVUSER(user-ID, password)
Registers a user on a DataFlux Data Management Server.
Product: SAS Data Quality Server
Document: SAS Data Quality: Language Reference
| |
|
DMSRVVER(host, port)
Returns the version of the DataFlux Data Management
Server.
Product: SAS Data Quality Server
Document: SAS Data Quality: Language Reference
| |
|
DQCASE(character-value,
'case-definition'
<,
'locale'>)
Returns a character value with standardized capitalization.
Product: SAS Data Quality Server
Document: SAS Data Quality: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: Language Reference
| |
|
DQMATCH(character-value, 'match-definition'
<
,'sensitivity'
>
<
,'locale'
>)
Returns a match code from a character value.
Product: SAS Data Quality Server
Document: SAS Data Quality: 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: Language Reference
| |
|
DQMATCHPARSED(delimited-string, 'match-definition'
<
,sensitivity
>
<
,'locale'
>)
Returns a match code from a delimited string of parse token
values.
Product: SAS Data Quality Server
Document: SAS Data Quality: Language Reference
| |
|
DQOPTSURFACE('surface-flag')
Reveals or hides non-surfaced definitions.
Product: SAS Data Quality Server
Document: SAS Data Quality: 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: 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: 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: Language Reference
| |
|
DQPARSERESLIMIT('resource-limit')
Overrides the default expected limit on resources
consumed during parsing.
Product: SAS Data Quality Server
Document: SAS Data Quality: 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: 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: 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: 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: 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: 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: 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: Language Reference
| |
|
DQVER()
Returns the version of the SAS Data Quality engine.
Product: SAS Data Quality Server
Document: SAS Data Quality: Language Reference
| |
|
DQVERQKB ()
Returns the version of the currently loaded QKB.
Product: SAS Data Quality Server
Document: SAS Data Quality: Language Reference
|
SAS Intelligent Decisioning
|
Name
|
Syntax and Description
|
|---|---|
|
DATAGRID_ADDCHARACTERCOLUMN (dataGrid,
column)
Adds a character column to the specified data grid.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_ADDCOLUMN (dataGrid,
column,
type)
Adds a column of the specified type to the specified data
grid.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_ADDNUMERICCOLUMN (dataGrid,
column)
Adds a numeric column to the specified data grid.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_ADDROW (dataGrid<,
numberOfRows=n>)
Appends new rows to the specified data grid.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_APPEND (dataGrid1,
dataGrid2)
Appends dataGrid2 to
dataGrid1.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_BOTTOMN (source_dataGrid,
column,
number,
target_dataGrid)
Populates the target data grid with the rows from the source data grid
that contain the lowest number values in
the specified column.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_CLEAR (dataGrid)
Deletes all rows and all column metadata from the specified data
grid.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_CLEARCOLUMN (dataGrid,
column<,
start_row_number,
end_row_number>)
Deletes the data in the specified columns.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_CLEARDATA (dataGrid)
Deletes all rows from the specified data grid but does not remove the
column metadata.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_COLUMNCOUNT (dataGrid)
Returns the number of columns in the specified data
grid.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_COLUMNCOUNTMATCHBYFILTER (source_dataGrid,.'filter_string')
DATAGRID_COLUMNCOUNTMATCHBYFILTER(source_dataGrid,.'filter_string',.start_row, end_row)
Returns the number of rows in the data grid that match the specified filter
criteria.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_COLUMNEXISTS
(dataGrid,
column)
Returns the index of the specified column in the specified data
grid.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_COLUMNINDEX
(dataGrid,
column)
Returns the index of the specified column in the specified data
grid.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_COLUMNISNUMERIC
(dataGrid,
column)
Determines whether the data type of the specified data grid column is
numeric.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_COLUMNNAME (dataGrid,
column_number)
Returns the name of the column that is in the specified ordinal
position in the specified data grid.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_COLUMNTYPE
(dataGrid,
column)
Returns the data type of the specified column in the specified data
grid.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_COLUMNVALUESTOLIST (dataGrid,
column,
valueList)
Creates a comma-separated list of the values in the specified data
grid column.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_CONFORM (dataGrid1,
dataGrid2)
Adds the columns that are exclusive to
dataGrid1 to
dataGrid2, and adds the columns that
are exclusive to dataGrid2 to
dataGrid1.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_COPY (source_dataGrid,
target_dataGrid)
Copies the source data grid into the target data
grid.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_COPYCOLUMN
(source_dataGrid,
target_dataGrid,
source-column,
target-column)
Copies the specified column in the source data grid into the target
data grid.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_CORR (dataGrid,
column1,
column2)
Returns the Pearson product-moment correlation coefficient for the
specified columns in the specified data grid.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_COUNT (dataGrid)
Returns the number of rows in the specified data
grid.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_CREATE (dataGrid,
JSON_string)
Creates the data grid columns that are defined in the specified JSON
string, and assigns to those columns any values that are specified in the JSON
string.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_DATASTRING (data_grid)
Returns the JSON string that defines the data for the specified data
grid.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_DELETECOLUMN (dataGrid,
column)
Deletes the specified column from the specified data
grid.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_DELETEROW (dataGrid,
start_row_number<,
end_row_number>)
Deletes one or more rows from the specified data
grid.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_DISTINCTROWCOUNT (dataGrid)
Returns the number of unique rows in the specified data
grid.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_EQUALS (dataGrid1,
dataGrid2)
Compares the column count, row count, column names, data types, and
values in specified data grids and determines whether they are
identical.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_FILTEREDGET (dataGrid,
columnToSearch,
filterColumn,
operator,
variableOrValue)
Returns the value in the first row in the specified column for which
the specified comparison evaluates to true.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_FILTEREDGETBYFILTER (dataGrid,.filter_string,.columnToRetrieve)
DATAGRID_FILTEREDGETBYFILTER (dataGrid,.filter_string,.columnToRetrieve,.start_row,.end_row)
Returns the value of the specified column in the first row that matches the
specified filter criteria.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_FILTEREDGETINDEX (dataGrid,
filterColumn,
operator,
variableOrValue)
Returns the index of the first row in the specified column for which
the specified comparison evaluates to true.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_FILTEREDGETINDEXBYFILTER (dataGrid,.filter_string)
DATAGRID_FILTEREDGETINDEXBYFILTER (dataGrid,.filter_string,.start_row, end_row)
Returns the index of the first row that matches the specified filter
criteria.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_FILTEREDSET (dataGrid,
columnToAssign,
rowNumber,
filterColumn, operator, variableOrValue, valueToAssign) Sets the value in the specified row and column to the specified value
if the specified comparison evaluates to true.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_FILTEREDSETALL (dataGrid,
columnToAssign,
filterColumn,
operator,
variableOrValue,
valueToAssign)
Sets the cell in the specified column to the specified value for each
row for which the specified comparison evaluates to true.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_FILTEREDSETALLBYFILTER (dataGrid, filter_string, columnToAssign, valueToAssign)
Sets the cell in the specified column to the specified value for each row for
which the column values in the row match the specified filter.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_FILTEREDSETBYFILTER (dataGrid, filter_string, columnToAssign, rowNumber, valueToAssign)
Sets the value in the specified row and column to the specified value if the
column values in the row match the specified filter.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_FREQ (dataGrid,
column)
Returns the number of distinct values for the specified
column.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_FULLJOIN (dataGrid1,
dataGrid2,
keyColumn1,
keyColumn2,
target_dataGrid)
DATAGRID_FULLJOIN (dataGrid1,
dataGrid2,
join_dataGrid,
target_dataGrid)
Performs a full join of two data grids, and populates the target data
grid with the results of the join.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
target_dataGrid = DATAGRID_FULLJOINBYFILTER (left_dataGrid, right_dataGrid, keep_columns, filter_string)
numRows = DATAGRID_FULLJOINBYFILTER (left_dataGrid, right_dataGrid, keep_columns, filter_string, target_dataGrid)
Performs an full join of two data grids and populates the target data grid
with the results of the join.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_GET (dataGrid,
column,
rowNumber)
Returns the value of the cell in the specified row and
column.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_GETBOOL (dataGrid,
column,
rowNumber)
Returns the value of the cell in the specified row and column as an
integer.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_GETDOUBLE (dataGrid,
column,
rowNumber)
Returns the value of the cell in the specified row and column as a
decimal value.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_GETFIRSTINDEXBYVALUE
(dataGrid,
column,
variableOrValue)
Returns the index of the first row that contains the specified value
in the specified column.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_GETFIRSTMISSINGINDEX
(dataGrid,
column)
Returns the index of the first row that contains a missing value in
the specified column.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_GETINT (dataGrid,
column,
rowNumber)
Returns the value of the cell in the specified row and column as an
integer.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_GETLASTINDEXBYVALUE
(dataGrid,
column,
variableOrValue)
Returns the index of the last row that contains the specified value in
the specified column.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_GETLASTMISSINGINDEX
(dataGrid,
column)
Returns the index of the last row that contains a missing value in the
specified column.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_GETLONG (dataGrid,
column,
rowNumber)
Returns the value of the cell in the specified row and column as a
long integer.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_GETSTRING (dataGrid,
column,
rowNumber)
Returns the value of the cell in the specified row and column as a
character string.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_GRIDMATCHCOUNT (dataGrid1,
dataGrid2,
column1,
column2)
DATAGRID_GRIDMATCHCOUNT (dataGrid1,
dataGrid2,
key_dataGrid)
Returns the number of rows for which the values in the specified
columns in one data grid match the values in the specified columns in another data
grid.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_GRIDMATCHCOUNTBYFILTER (left_dataGrid,.right_dataGrid,.filter_string)
Returns the number of rows for which the column values in the specified data
grids match the specified filter.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_INITIALIZE
(dataGrid,
character-value,
numeric-value)
Replaces all of the values in the specified data grid with the
specified default values.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_INNERJOIN (dataGrid1,
dataGrid2,
keyColumn1,
keyColumn2,
target_dataGrid)
DATAGRID_INNERJOIN (dataGrid1,
dataGrid2,
join_dataGrid,
target_dataGrid)
Performs an inner join of two data grids and populates the target data
grid with the results of the join.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
target_dataGrid = DATAGRID_INNERJOINBYFILTER (left_dataGrid, right_dataGrid, keep_columns, filter_string)
numRows = DATAGRID_INNERJOINBYFILTER (left_dataGrid, right_dataGrid, keep_columns, filter_string, target_dataGrid)
Performs an inner join of two data grids and populates the target data grid
with the results of the join.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_LEFTJOIN (dataGrid1,
dataGrid2,
keyColumn1,
keyColumn2,
target_dataGrid)
DATAGRID_LEFTJOIN (dataGrid1,
dataGrid2,
join_dataGrid,
target_dataGrid)
Performs a left join of two data grids, and populates the target data
grid with the results of the join.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
target_dataGrid = DATAGRID_LEFTJOINBYFILTER (left_dataGrid, right_dataGrid, keep_columns, filter_string)
numRows = DATAGRID_LEFTJOINBYFILTER (left_dataGrid, right_dataGrid, keep_columns, filter_string, target_dataGrid)
Performs an left join of two data grids and populates the target data grid
with the results of the join.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_MATCHCOUNT (dataGrid,
filterColumn,
operator,
variableOrValue)
Returns the number of rows in the specified column for which the
specified comparison evaluates to true.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_MAX (dataGrid,
column)
Returns the maximum value for the specified column.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_MAXBOOL (dataGrid,
column)
Returns the maximum value for the specified column.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_MAXINT (dataGrid,
column)
Returns the maximum value for the specified column.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_MAXLONG (dataGrid,
column)
Returns the maximum value for the specified column.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_MAXSTRING (dataGrid,
column)
Returns the maximum value for the specified column.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_MEAN (dataGrid,
column)
Returns the mean value for the specified column.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_MEDIAN (dataGrid,
column)
Returns the median value for the specified column.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_METADATASTRING (data_grid)
Returns the JSON string that defines the column metadata for the specified
data grid.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_MIN (dataGrid,
column)
Returns the minimum value that appears in the specified
column.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_MINBOOL (dataGrid,
column)
Returns the minimum value that appears in the specified
column.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_MININT (dataGrid,
column)
Returns the minimum value that appears in the specified
column.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_MINLONG (dataGrid,
column)
Returns the minimum value that appears in the specified
column.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_MINSTRING (dataGrid,
column)
Returns the minimum value that appears in the specified
column.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_MULTISORT (source_dataGrid,
sort_column_1,
sort_order_1
< , sort_column_2 >< ,sort_order_2 >..., target_dataGrid) Sorts a data grid based on the values of one or more columns, and then
populates the target data grid with the sorted data.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_NMISS (dataGrid,
column)
Returns the number of missing values for the specified column of the
specified data grid.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_NVALID (dataGrid,
column)
Returns the number of valid nonmissing numeric values in the specified
column of the specified data grid.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_RENAMECOLUMN (dataGrid,
oldName,
newName)
Renames the specified column in the specified data
grid.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_RIGHTJOIN (dataGrid1,
dataGrid2,
keyColumn1,
keyColumn2,
target_dataGrid)
DATAGRID_RIGHTJOIN (dataGrid1,
dataGrid2,
join_dataGrid,
target_dataGrid)
Performs a right join of two data grids, and populates the target data
grid with the results of the join.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
target_dataGrid = DATAGRID_RIGHTJOINBYFILTER (left_dataGrid, right_dataGrid, keep_columns, filter_string)
numRows = DATAGRID_RIGHTJOINBYFILTER (left_dataGrid, right_dataGrid, keep_columns, filter_string, target_dataGrid)
Performs an right join of two data grids and populates the target data grid
with the results of the join.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_SET (dataGrid,
column,
rowNumber,
variableOrValue)
Assigns the specified value to the specified row and
column.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_SETALL (dataGrid,
column,
variableOrValue)
Assigns the specified value to all rows in the specified
column.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_SETBOOL (dataGrid,
column,
rowNumber,
variableOrValue)
Assigns the specified Boolean value to the specified row and
column.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_SETDOUBLE (dataGrid,
column,
rowNumber,
variableOrValue)
Assigns the specified decimal value to the specified row and
column.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_SETINT (dataGrid,
column,
rowNumber,
variableOrValue)
Assigns the specified integer value to the specified row and
column.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_SETLONG (dataGrid,
column,
rowNumber,
variableOrValue)
Assigns the specified long integer value to the specified row and
column.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_SETSTRING (dataGrid,
column,
rowNumber,
variableOrValue)
Assigns the specified character string to the specified row and
column.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_SORT (source_dataGrid,
sort_column,
sort_order,
target_dataGrid)
Sorts a data grid based on the values in a single column, and then
populates the target data grid with the sorted data.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_STDDEV (dataGrid,
column)
Returns the standard deviation of the values in the specified
column.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_SUBSETBYVALUE
(source_dataGrid,
filterColumn,
operator,
variableOrValue,
target_dataGrid)
DATAGRID_SUBSETBYVALUE
(source_dataGrid,
criteria_dataGrid,
target_dataGrid)
Populates the target data grid with the rows from the source data grid
for which the specified comparison evaluates to true.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
target_datagrid = DATAGRID_SUBSETBYVALUEBYFILTER (source_dataGrid, keep_columns, filter_string)
num_rows = DATAGRID_SUBSETBYVALUEBYFILTER (source_dataGrid,.keep_columns,.filter_string,.target_dataGrid)
Returns a target data grid that contains the rows from the source data grid
that match the specified filter, or returns the number of rows that match the specified
filter.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_SUM (dataGrid,
column)
Returns the sum of the values in the specified
column.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_SUMLONG (dataGrid,
column)
Returns the sum of the values in the specified
column.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
count = DATAGRID_TABLESELECT
(source_dataGrid,
'column_clause',
'where_clause',
target_dataGrid)
target_dataGrid =
DATAGRID_TABLESELECT
(source_dataGrid,
'column_clause',
'where_clause')
Creates a target data grid that contains a copy of the rows in the source data
grid that satisfy the WHERE clause. Each row in the target data grid contains the
columns
that are specified in the column clause.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_TOPN (source_dataGrid,
column,
number,
target_dataGrid)
Populates the target data grid with the rows from the source data grid
that contain the highest number values in
the specified column.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
DATAGRID_TOSTRING (dataGrid)
Returns the JSON string for the specified data
grid.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: Using Data Grids
| |
|
LOOKUP
('lookup_table_name',
variable_or_value)
Determines whether a lookup key exists in a lookup table.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: User’s Guide
| |
|
LOOKUPVALUE
('lookup_table_name',
variable_or_value)
Retrieves a lookup value from a lookup table.
Product: SAS Intelligent Decisioning
Document: SAS Intelligent Decisioning: User’s Guide
|
Last updated: July 17, 2025