Glossary
A
ABS(numexpr)
ABS(numexpr). Numeric. Returns the absolute value of numexpr, which must be
numeric.
ANY(test,value[,value,...])
ANY(test,value[,value,...]). Logical. Returns 1 or true if the value of test matches
any of the subsequent values; returns 0 or false otherwise. This function requires two or more
arguments. For example, ANY(var1, 1, 3, 5) returns 1 if the value of var1 is 1, 3, or 5 and 0 for
other values. ANY can also be used to scan a list of variables or expressions for a value. For
example, ANY(1, var1, var2, var3) returns 1 if any of the three specified variables has a value of 1
and 0 if all three variables have values other than 1.
ApplyModel(handle,"function",category)
ApplyModel(handle, "function", value). Numeric. Applies a particular scoring function
to the input case data using the model specified by handle and where "function" is one of the
following string literal values enclosed in quotes: predict, stddev, probability, confidence,
nodeid, cumhazard, neighbor, distance. The model handle is the name associated with the external XML
file, as defined on the MODEL HANDLE command. The optional third argument applies when the function
is "probability", "neighbor", or "distance". For "probability", it specifies a category for which
the probability is calculated. For "neighbor" and "distance", it specifies a particular neighbor (as
an integer) for nearest neighbor models. ApplyModel returns system-missing if a value can not be
computed.
ARSIN(numexpr)
ARSIN(numexpr). Numeric. Returns the inverse sine (arcsine), in radians, of numexpr,
which must evaluate to a numeric value between -1 and +1.
ARTAN(numexpr)
ARTAN(numexpr). Numeric. Returns the inverse tangent (arctangent), in radians, of
numexpr, which must be numeric.
C
CDF.BERNOULLI(quant, prob)
CDF.BERNOULLI(quant, prob). Numeric. Returns the cumulative probability that a value
from the Bernoulli distribution, with the given probability parameter, will be less than or equal to
quant.
CDF.BETA(quant, shape1, shape2)
CDF.BETA(quant, shape1, shape2). Numeric. Returns the cumulative probability that a
value from the Beta distribution, with the given shape parameters, will be less than quant.
CDF.BINOM(quant, n, prob)
CDF.BINOM(quant, n, prob). Numeric. Returns the cumulative probability that the number
of successes in n trials, with probability prob of success in each, will be less than or equal to
quant. When n is 1, this is the same as CDF.BERNOULLI.
CDF.BVNOR
CDF.BVNOR(quant1, quant2, corr). Numeric. Returns the cumulative probability that a
value from the standard bivariate normal distribution, with the given correlation parameter, will be
less than quant1 and quant2.
CDF.CAUCHY(quant, loc, scale)
CDF.CAUCHY(quant, loc, scale). Numeric. Returns the cumulative probability that a value
from the Cauchy distribution, with the given location and scale parameters, will be less than
quant.
CDF.CHISQ(quant, df)
CDF.CHISQ(quant, df). Numeric. Returns the cumulative probability that a value from the
chi-square distribution, with df degrees of freedom, will be less than quant.
CDF.EXP(quant, scale)
CDF.EXP(quant, scale). Numeric. Returns the cumulative probability that a value from
the exponential distribution, with the given scale parameter, will be less than quant.
CDF.F(quant, df1, df2)
CDF.F(quant, df1, df2). Numeric. Returns the cumulative probability that a value from
the F distribution, with degrees of freedom df1 and df2, will be less than quant.
CDF.GAMMA(quant, shape, scale)
CDF.GAMMA(quant, shape, scale). Numeric. Returns the cumulative probability that a
value from the Gamma distribution, with the given shape and scale parameters, will be less than
quant.
CDF.GEOM(quant, prob)
CDF.GEOM(quant, prob). Numeric. Returns the cumulative probability that the number of
trials to obtain a success, when the probability of success is given by prob, will be less than or
equal to quant.
CDF.HALFNRM
CDF.HALFNRM(quant, mean, stddev). Numeric. Returns the cumulative probability that a
value from the half normal distribution, with specified mean and standard deviation, will be less
than quant.
CDF.HYPER(quant, total, sample, hits)
CDF.HYPER(quant, total, sample, hits). Numeric. Returns the cumulative probability that
the number of objects with a specified characteristic, when sample objects are randomly selected
from a universe of size total in which hits have the specified characteristic, will be less than or
equal to quant.
CDF.IGAUSS
CDF.IGAUSS(quant, loc, scale). Numeric. Returns the cumulative probability that a value
from the inverse Gaussian distribution, with the given location and scale parameters, will be less
than quant.
CDF.LAPLACE(quant, mean, scale)
CDF.LAPLACE(quant, mean, scale). Numeric. Returns the cumulative probability that a
value from the Laplace distribution, with the specified mean and scale parameters, will be less than
quant.
CDF.LNORMAL(quant, a, b)
CDF.LNORMAL(quant, a, b). Numeric. Returns the cumulative probability that a value from
the log-normal distribution, with the specified parameters, will be less than quant.
CDF.LOGISTIC(quant, mean, scale)
CDF.LOGISTIC(quant, mean, scale). Numeric. Returns the cumulative probability that a
value from the logistic distribution, with the specified mean and scale parameters, will be less
than quant.
CDF.NEGBIN(quant, thresh, prob)
CDF.NEGBIN(quant, thresh, prob). Numeric. Returns the cumulative probability that the
number of trials to obtain a success, when the threshold parameter is thresh and the probability of
success is given by prob, will be less than or equal to quant.
CDF.NORMAL(quant, mean, stddev)
CDF.NORMAL(quant, mean, stddev). Numeric. Returns the cumulative probability that a
value from the normal distribution, with specified mean and standard deviation, will be less than
quant.
CDF.PARETO(quant, threshold, shape)
CDF.PARETO(quant, threshold, shape). Numeric. Returns the cumulative probability that a
value from the Pareto distribution, with the specified threshold and shape parameters, will be less
than quant.
CDF.POISSON(quant, mean)
CDF.POISSON(quant, mean). Numeric. Returns the cumulative probability that a value from
the Poisson distribution, with the specified mean or rate parameter, will be less than or equal to
quant.
CDF.SMOD
CDF.SMOD(quant, a, b). Numeric. Returns the cumulative probability that a value from
the Studentized maximum modulus, with the specified parameters, will be less than quant.
CDF.SRANGE
CDF.SRANGE(quant, a, b). Numeric. Returns the cumulative probability that a value from
the Studentized range statistic, with the specified parameters, will be less than quant.
CDF.T(quant, df)
CDF.T(quant, df). Numeric. Returns the cumulative probability that a value from
Student's t distribution, with the specified degrees of freedom df, will be less than quant.
CDF.UNIFORM(quant, min, max)
CDF.UNIFORM(quant, min, max). Numeric. Returns the cumulative probability that a value
from the uniform distribution, with the specified minimum and maximum, will be less than quant.
CDF.WEIBULL(quant, a, b)
CDF.WEIBULL(quant, a, b). Numeric. Returns the cumulative probability that a value from
the Weibull distribution, with the specified parameters, will be less than quant.
CDFNORM(zvalue)
CDFNORM(zvalue). Numeric. Returns the probability that a random variable with mean 0
and standard deviation 1 would be less than zvalue, which must be numeric.
CFVAR(numexpr,numexpr[,..])
CFVAR(numexpr,numexpr[,...]). Numeric. Returns the coefficient of variation (the
standard deviation divided by the mean) of its arguments that have valid values. This function
requires two or more arguments, which must be numeric. You can specify a minimum number of valid
arguments for this function to be evaluated.
CHAR.INDEX(haystack, needle, divisor)
CHAR.INDEX(haystack, needle[, divisor]). Numeric. Returns a number indicating the
character position of the first occurrence of needle in haystack. The optional third argument,
divisor, is a number of characters used to divide needle into separate strings. Each substring is
used for searching and the function returns the first occurrence of any of the substrings. For
example, CHAR.INDEX(var1, 'abcd') will return the value of the starting position of the complete
string "abcd" in the string variable var1; CHAR.INDEX(var1, 'abcd', 1) will return the value of the
position of the first occurrence of any of the values in the string; and CHAR.INDEX(var1, 'abcd', 2)
will return the value of the first occurrence of either "ab" or "cd". Divisor must be a positive
integer and must divide evenly into the length of needle. Returns 0 if needle does not occur within
haystack.
CHAR.LENGTH(strexpr)
CHAR.LENGTH(strexpr). Numeric. Returns the length of strexpr in characters, with any
trailing blanks removed.
CHAR.LPAD(strexpr1, length, strexpr2)
CHAR.LPAD(strexpr1,length[,strexpr2]). String. Left-pads strexpr1 to make its length
the value specified by length using as many complete copies as will fit of strexpr2 as the padding
string. The value of length represents the number of characters and must be a positive integer. If
the optional argument strexpr2 is omitted, the value is padded with blank spaces.
CHAR.MBLEN(strexpr,pos)
CHAR.MBLEN(strexpr,pos). Numeric. Returns the number of bytes in the character at
character position pos of strexpr.
CHAR.RINDEX(haystack,needle,divisor)
CHAR.RINDEX(haystack,needle[,divisor]). Numeric. Returns an integer that indicates the
starting character position of the last occurrence of the string needle in the string haystack. The
optional third argument, divisor, is the number of characters used to divide needle into separate
strings. For example, CHAR.RINDEX(var1, 'abcd') will return the starting position of the last
occurrence of the entire string "abcd" in the variable var1; CHAR.RINDEX(var1, 'abcd', 1) will
return the value of the position of the last occurrence of any of the values in the string; and
CHAR.RINDEX(var1, 'abcd', 2) will return the value of the starting position of the last occurrence
of either "ab" or "cd". Divisor must be a positive integer and must divide evenly into the length of
needle. If needle is not found, the value 0 is returned.
CHAR.RPAD(strexpr1,length,strexpr2)
CHAR.RPAD(strexpr1,length[,strexpr2]). String. Right-pads strexpr1 with strexpr2 to
extend it to the length given by length using as many complete copies as will fit of strexpr2 as the
padding string. The value of length represents the number of characters and must be a positive
integer. The optional third argument strexpr2 is a quoted string or an expression that resolves to a
string. If strepxr2 is omitted, the value is padded with blanks.
CHAR.SUBSTR(strexpr,pos,length)
CHAR.SUBSTR(strexpr,pos[,length]). String. Returns the substring beginning at character
position pos of strexpr. The optional third argument represents the number of characters in the
substring. If the optional argument length is omitted, returns the substring beginning at character
position pos of strexpr and running to the end of strexpr. For example CHAR.SUBSTR('abcd', 2)
returns 'bcd' and CHAR.SUBSTR('abcd', 2, 2) returns 'bc'.
CONCAT(strexpr,strexpr[,..])
CONCAT(strexpr,strexpr[,..]). String. Returns a string that is the concatenation of all
its arguments, which must evaluate to strings. This function requires two or more arguments. In code
page mode, if strexpr is a string variable, use RTRIM if you only want the actual string value
without the right-padding to the defined variable width. For example, CONCAT(RTRIM(stringvar1),
RTRIM(stringvar2)).
COS(radians)
COS(radians). Numeric. Returns the cosine of radians, which must be a numeric value,
measured in radians.
CTIME.DAYS(timevalue)
CTIME.DAYS(timevalue). Numeric. Returns the number of days, including fractional days,
in timevalue, which is a number of seconds, a time expression, or a time format variable.
CTIME.HOURS(timevalue)
CTIME.HOURS(timevalue). Numeric. Returns the number of hours, including fractional
hours, in timevalue, which is a number of seconds, a time expression, or a time format
variable.
CTIME.MINUTES(timevalue)
CTIME.MINUTES(timevalue). Numeric. Returns the number of minutes, including fractional
minutes, in timevalue, which is a number of seconds, a time expression, or a time format
variable.
CTIME.SECONDS(timevalue)
CTIME.SECONDS(timevalue). Numeric. Returns the number of seconds, including fractional
seconds, in timevalue, which is a number, a time expression, or a time format variable.
D
DATE.DMY(day,month,year)
DATE.DMY(day,month,year). Numeric. Returns a date value corresponding to the indicated
day, month, and year. The arguments must resolve to integers, with day between 0 and 31, month
between 1 and 13, and year a four-digit integer greater than 1582. To display the result as a date,
assign a date format to the result variable.
DATE.MDY(month,day,year)
DATE.MDY(month,day,year). Numeric. Returns a date value corresponding to the indicated
month, day, and year. The arguments must resolve to integers, with day between 0 and 31, month
between 1 and 13, and year a four-digit integer greater than 1582. To display the result as a date,
assign a date format to the result variable.
DATE.MOYR(month,year)
DATE.MOYR(month,year). Numeric. Returns a date value corresponding to the indicated
month and year. The arguments must resolve to integers, with month between 1 and 13, and year a
four-digit integer greater than 1582. To display the result as a date, assign a date format to the
result variable.
DATE.QYR(quarter,year)
DATE.QYR(quarter,year). Numeric. Returns a date value corresponding to the indicated
quarter and year. The arguments must resolve to integers, with quarter between 1 and 4, and year a
four-digit integer greater than 1582. To display the result as a date, assign a date format to the
result variable.
DATE.WKYR(weeknum,year)
DATE.WKYR(weeknum,year). Numeric. Returns a date value corresponding to the indicated
weeknum and year. The arguments must resolve to integers, with weeknum between 1 and 53, and year a
four-digit integer greater than 1582. The date value returned represents the first day of the
specified week for that year. The first week starts on January 1 of each year; so the date returned
for any given week value will differ between years. To display the result as a date, assign a date
format to the result variable.
DATE.YRDAY(year,daynum)
DATE.YRDAY(year,daynum). Numeric. Returns a date value corresponding to the indicated
year and daynum. The arguments must resolve to integers, with daynum between 1 and 366 and with year
being a four-digit integer greater than 1582. To display the result as a date, assign a date format
to the result variable.
E
EXP(numexpr)
EXP(numexpr). Numeric. Returns e raised to the power numexpr, where e is the base of
the natural logarithms and numexpr is numeric. Large values of numexpr may produce results that
exceed the capacity of the machine.
I
IDF.BETA(prob, shape1, shape2)
IDF.BETA(prob, shape1, shape2). Numeric. Returns the value from the Beta distribution,
with the given shape parameters, for which the cumulative probability is prob.
IDF.CAUCHY(prob, loc, scale)
IDF.CAUCHY(prob, loc, scale). Numeric. Returns the value from the Cauchy distribution,
with the given location and scale parameters, for which the cumulative probability is prob.
IDF.CHISQ(prob, df)
IDF.CHISQ(prob, df). Numeric. Returns the value from the chi-square distribution, with
the specified degrees of freedom df, for which the cumulative probability is prob. For example, the
chi-square value that is significant at the 0.05 level with 3 degrees of freedom is
IDF.CHISQ(0.95,3).
IDF.EXP(p, scale)
IDF.EXP(p, scale). Numeric. Returns the value of an exponentially decaying variable,
with rate of decay scale, for which the cumulative probability is p.
IDF.F(prob, df1, df2)
IDF.F(prob, df1, df2). Numeric. Returns the value from the F distribution, with the
specified degrees of freedom, for which the cumulative probability is prob. For example, the F value
that is significant at the 0.05 level with 3 and 100 degrees of freedom is IDF.F(0.95,3,100).
IDF.GAMMA(prob, shape, scale)
IDF.GAMMA(prob, shape, scale). Numeric. Returns the value from the Gamma distribution,
with the specified shape and scale parameters, for which the cumulative probability is prob.
IDF.HALFNRM
IDF.HALFNRM(prob, mean, stddev). Numeric. Returns the value from the half normal
distribution, with the specified mean and standard deviation, for which the cumulative probability
is prob.
IDF.IGAUSS
IDF.IGAUSS(prob, loc, scale). Numeric. Returns the value from the inverse Gaussian
distribution, with the given location and scale parameters, for which the cumulative probability is
prob.
IDF.LAPLACE(prob, mean, scale)
IDF.LAPLACE(prob, mean, scale). Numeric. Returns the value from the Laplace
distribution, with the specified mean and scale parameters, for which the cumulative probability is
prob.
IDF.LNORMAL(prob, a, b)
IDF.LNORMAL(prob, a, b). Numeric. Returns the value from the log-normal distribution,
with specified parameters, for which the cumulative probability is prob.
IDF.LOGISTIC(prob, mean, scale)
IDF.LOGISTIC(prob, mean, scale). Numeric. Returns the value from the logistic
distribution, with specified mean and scale parameters, for which the cumulative probability is
prob.
IDF.NORMAL(prob, mean, stddev)
IDF.NORMAL(prob, mean, stddev). Numeric. Returns the value from the normal
distribution, with specified mean and standard deviation, for which the cumulative probability is
prob.
IDF.PARETO(prob, threshold, shape)
IDF.PARETO(prob, threshold, shape). Numeric. Returns the value from the Pareto
distribution, with specified threshold and scale parameters, for which the cumulative probability is
prob.
IDF.SMOD
IDF.SMOD(prob, a, b). Numeric. Returns the value from the Studentized maximum modulus,
with the specified parameters, for which the cumulative probability is prob.
IDF.SRANGE
IDF.SRANGE(prob, a, b). Numeric. Returns the value from the Studentized range
statistic, with the specified parameters, for which the cumulative probability is prob.
IDF.T(prob, df)
IDF.T(prob, df). Numeric. Returns the value from Student's t distribution, with
specified degrees of freedom df, for which the cumulative probability is prob.
IDF.UNIFORM(prob, min, max)
IDF.UNIFORM(prob, min, max). Numeric. Returns the value from the uniform distribution
between min and max for which the cumulative probability is prob.
IDF.WEIBULL(prob, a, b)
IDF.WEIBULL(prob, a, b). Numeric. Returns the value from the Weibull distribution, with
specified parameters, for which the cumulative probability is prob.
INDEX(haystack, needle,divisor)
INDEX(haystack,needle[,divisor]). Numeric. Returns a number that indicates the byte
position of the first occurrence of needle in haystack. The optional third argument, divisor, is a
number of bytes used to divide needle into separate strings. Each substring is used for searching
and the function returns the first occurrence of any of the substrings. Divisor must be a positive
integer and must divide evenly into the length of needle. Returns 0 if needle does not occur within
haystack.
L
LAG(variable, n)
LAG(variable[, n]). Numeric or string. The value of variable in the previous case or n
cases before. The optional second argument, n, must be a positive integer; the default is 1. For
example, prev4=LAG(gnp,4) returns the value of gnp for the fourth case before the current one. The
first four cases have system-missing values for prev4.
LENGTH(strexpr)
LENGTH(strexpr). Numeric. Returns the length of strexpr in bytes, which must be a
string expression. For string variables, in Unicode mode this is the number of bytes in each value,
excluding trailing blanks, but in code page mode this is the defined variable length, including
trailing blanks. To get the length (in bytes) without trailing blanks in code page mode, use
LENGTH(RTRIM(strexpr)).
LG10(numexpr)
LG10(numexpr). Numeric. Returns the base-10 logarithm of numexpr, which must be numeric
and greater than 0.
LN(numexpr)
LN(numexpr). Numeric. Returns the base-e logarithm of numexpr, which must be numeric
and greater than 0.
LNGAMMA
LNGAMMA(numexpr). Numeric. Returns the logarithm of the complete Gamma function of
numexpr, which must be numeric and greater than 0.
LOWER(strexpr)
LOWER(strexpr). String. Returns strexpr with uppercase letters changed to lowercase and
other characters unchanged. The argument can be a string variable or a value. For example,
LOWER(name1) returns charles if the value of name1 is Charles.
LPAD(strexpr1,length,strexpr2)
LPAD(strexpr1,length[,strexpr2]). String. Left-pads strexpr1 to make its length the
value specified by length using as many complete copies as will fit of strexpr2 as the padding
string. The value of length represents the number of bytes and must be a positive integer. If the
optional argument strexpr2 is omitted, the value is padded with blank spaces.
LTRIM(strexpr,char)
LTRIM(strexpr[,char]). String. Returns strexpr with any leading instances of char
removed. If char is not specified, leading blanks are removed. Char must resolve to a single
character.
M
MAX(value,value[,..])
MAX(value,value[,..]). Numeric or string. Returns the maximum value of its arguments
that have valid values. This function requires two or more arguments. For numeric values, you can
specify a minimum number of valid arguments for this function to be evaluated.
MBLEN.BYTE(strexpr,pos)
MBLEN.BYTE(strexpr,pos). Numeric. Returns the number of bytes in the character at byte
position pos of strexpr.
MEAN(numexpr,numexpr[,..])
MEAN(numexpr,numexpr[,..]). Numeric. Returns the arithmetic mean of its arguments that
have valid, nonmissing values. This function requires two or more arguments, which must be numeric.
You can specify a minimum number of valid arguments for this function to be evaluated.
MEDIAN(numexpr,numexpr[,..])
MEDIAN(numexpr,numexpr[,..]). Numeric. Returns the median (50th percentile) of its
arguments that have valid, nonmissing values. This function requires two or more arguments, which
must be numeric. You can specify a minimum number of valid arguments for this function to be
evaluated.
MIN(value,value[,..])
MIN(value,value[,..]). Numeric or string. Returns the minimum value of its arguments
that have valid, nonmissing values. This function requires two or more arguments. For numeric
values, you can specify a minimum number of valid arguments for this function to be evaluated.
MISSING(variable)
MISSING(variable). Logical. Returns 1 or true if variable has a system- or user-missing
value. The argument should be a variable name in the active dataset.
MOD(numexpr,modulus)
MOD(numexpr,modulus). Numeric. Returns the remainder when numexpr is divided by
modulus. Both arguments must be numeric, and modulus must not be 0.
N
NCDF.BETA(quant, shape1, shape2, nc)
NCDF.BETA(quant, shape1, shape2, nc). Numeric. Returns the cumulative probability that
a value from the noncentral Beta distribution, with the given shape and noncentrality parameters,
will be less than quant.
NCDF.CHISQ(quant, df,nc)
NCDF.CHISQ(quant, df, nc). Numeric. Returns the cumulative probability that a value
from the noncentral chi-square distribution, with df degrees of freedom and the specified
noncentrality parameter, will be less than quant.
NCDF.F(quant, df1, df2,nc)
NCDF.F(quant, df1, df2, nc). Numeric. Returns the cumulative probability that a value
from the noncentral F distribution, with degrees of freedom df1 and df2, and noncentrality nc, will
be less than quant.
NCDF.T(quant, df,nc)
NCDF.T(quant, df, nc). Numeric. Returns the cumulative probability that a value from
the noncentral Student's t distribution, with the specified degrees of freedom df and noncentrality
nc, will be less than quant.
NMISS(variable[,..])
NMISS(variable[,..]). Numeric. Returns a count of the arguments that have system- and
user-missing values. This function requires one or more arguments, which should be variable names in
the active dataset.
NORMAL(stddev)
NORMAL(stddev). Numeric. Returns a normally distributed pseudorandom number from a
distribution with mean 0 and standard deviation stddev, which must be a positive number. You can
repeat the sequence of pseudorandom numbers by setting a seed in the Random Number Seed dialog box
before each sequence.
NORMALIZE(strexp).
NORMALIZE(strexp). String. Returns the normalized version of strexp. In Unicode mode,
it returns Unicode NFC. In code page mode, it has no effect and returns strexp unmodified. The
length of the result may be different from the length of the input.
NPDF.BETA
NPDF.BETA(quant, shape1, shape2, nc). Numeric. Returns the probability density of the
noncentral beta distribution, with the given shape and noncentrality parameters, at quant.
NPDF.CHISQ
NPDF.CHISQ(quant, df, nc). Numeric. Returns the probability density of the noncentral
chi-square distribution, with df degrees of freedom and the specified noncentrality parameter, at
quant.
NPDF.F
NPDF.F(quant, df1, df2, nc). Numeric. Returns the probability density of the noncentral
F distribution, with degrees of freedom df1 and df2 and noncentrality nc, at quant.
NPDF.T
NPDF.T(quant, df, nc). Numeric. Returns the probability density of the noncentral
Student's t distribution, with the specified degrees of freedom df and noncentrality nc, at
quant.
NTRIM(varname)
NTRIM(varname). Returns the value of varname, without removing trailing blanks. The
value of varname must be a variable name; it cannot be an expression.
NUMBER(strexpr,format)
NUMBER(strexpr,format). Numeric. Returns the value of the string expression strexpr as
a number. The second argument, format, is the numeric format used to read strexpr. For example,
NUMBER(stringDate,DATE11) converts strings containing dates of the general format dd-mmm-yyyy to a
numeric number of seconds that represent that date. (To display the value as a date, use the FORMATS
or PRINT FORMATS command.) If the string cannot be read using the format, this function returns
system-missing.
NVALID(variable[,..])
NVALID(variable[,..]). Numeric. Returns a count of the arguments that have valid,
nonmissing values. This function requires one or more arguments, which should be variable names in
the active dataset.
P
PDF.BERNOULLI
PDF.BERNOULLI(quant, prob). Numeric. Returns the probability that a value from the
Bernoulli distribution, with the given probability parameter, will be equal to quant.
PDF.BETA
PDF.BETA(quant, shape1, shape2). Numeric. Returns the probability density of the beta
distribution, with the given shape parameters, at quant.
PDF.BINOM
PDF.BINOM(quant, n, prob). Numeric. Returns the probability that the number of
successes in n trials, with probability prob of success in each, will be equal to quant. When n is
1, this is the same as PDF.BERNOULLI.
PDF.BVNOR
PDF.BVNOR(quant1, quant2, corr). Numeric. Returns the probability density of the
standard bivariate normal distribution, with the given correlation parameter, at quant1,
quant2.
PDF.CAUCHY
PDF.CAUCHY(quant, loc, scale). Numeric. Returns the probability density of the Cauchy
distribution, with the given location and scale parameters, at quant.
PDF.CHISQ
PDF.CHISQ(quant, df). Numeric. Returns the probability density of the chi-square
distribution, with df degrees of freedom, at quant.
PDF.EXP
PDF.EXP(quant, shape). Numeric. Returns the probability density of the exponential
distribution, with the given shape parameter, at quant.
PDF.F
PDF.F(quant, df1, df2). Numeric. Returns the probability density of the F distribution,
with degrees of freedom df1 and df2, at quant.
PDF.GAMMA
PDF.GAMMA(quant, shape, scale). Numeric. Returns the probability density of the gamma
distribution, with the given shape and scale parameters, at quant.
PDF.GEOM
PDF.GEOM(quant, prob). Numeric. Returns the probability that the number of trials to
obtain a success, when the probability of success is given by prob, will be equal to quant.
PDF.HALFNRM
PDF.HALFNRM(quant, mean, stddev). Numeric. Returns the probability density of the half
normal distribution, with specified mean and standard deviation, at quant.
PDF.HYPER
PDF.HYPER(quant, total, sample, hits). Numeric. Returns the probability that the number
of objects with a specified characteristic, when sample objects are randomly selected from a
universe of size total in which hits have the specified characteristic, will be equal to quant.
PDF.IGAUSS
PDF.IGAUSS(quant, loc, scale). Numeric. Returns the probability density of the inverse
Gaussian distribution, with the given location and scale parameters, at quant.
PDF.LAPLACE
PDF.LAPLACE(quant, mean, scale). Numeric. Returns the probability density of the
Laplace distribution, with the specified mean and scale parameters, at quant.
PDF.LNORMAL
PDF.LNORMAL(quant, a, b). Numeric. Returns the probability density of the log-normal
distribution, with the specified parameters, at quant.
PDF.LOGISTIC
PDF.LOGISTIC(quant, mean, scale). Numeric. Returns the probability density of the
logistic distribution, with the specified mean and scale parameters, at quant.
PDF.NEGBIN
PDF.NEGBIN(quant, thresh, prob). Numeric. Returns the probability that the number of
trials to obtain a success, when the threshold parameter is thresh and the probability of success is
given by prob, will be equal to quant.
PDF.NORMAL
PDF.NORMAL(quant, mean, stddev). Numeric. Returns the probability density of the normal
distribution, with specified mean and standard deviation, at quant.
PDF.PARETO
PDF.PARETO(quant, threshold, shape). Numeric. Returns the probability density of the
Pareto distribution, with the specified threshold and shape parameters, at quant.
PDF.POISSON
PDF.POISSON(quant, mean). Numeric. Returns the probability that a value from the
Poisson distribution, with the specified mean or rate parameter, will be equal to quant.
PDF.T
PDF.T(quant, df). Numeric. Returns the probability density of Student's t distribution,
with the specified degrees of freedom df, at quant.
PDF.UNIFORM
PDF.UNIFORM(quant, min, max). Numeric. Returns the probability density of the uniform
distribution, with the specified minimum and maximum, at quant.
PDF.WEIBULL
PDF.WEIBULL(quant, a, b). Numeric. Returns the probability density of the Weibull
distribution, with the specified parameters, at quant.
PROBIT(prob)
PROBIT(prob). Numeric. Returns the value in a standard normal distribution having a
cumulative probability equal to prob. The argument prob is a probability greater than 0 and less
than 1.
R
RANGE(test,lo,hi[,lo,hi,..])
RANGE(test,lo,hi[,lo,hi,..]). Logical. Returns 1 or true if test is within any of the
inclusive ranges defined by the pairs lo, hi. Arguments must be all numeric or all strings of the
same length, and each of the lo, hi pairs must be ordered with lo <= hi. Note: For string values,
results can vary by locale even for the same set of characters, since the national collating
sequence is used. Language order, not ASCII order, determines where certain characters fall in the
sequence.
REPLACE(a1,a2,a3,a4)
REPLACE(a1, a2, a3[, a4]). String. In a1, instances of a2 are replaced with a3. The
optional argument a4 specifies the number of occurrences to replace; if a4 is omitted, all
occurrences are replaced. Arguments a1, a2, and a3 must resolve to string values (literal strings
enclosed in quotes or string variables), and the optional argument a4 must resolve to a non-negative
integer. For example, REPLACE("abcabc", "a", "x") returns a value of "xbcxbc" and REPLACE("abcabc",
"a", "x", 1) returns a value of "xbcabc".
RINDEX(haystack,needle,divisor)
RINDEX(haystack,needle[,divisor]). Numeric. Returns an integer that indicates the
starting byte position of the last occurrence of the string needle in the string haystack. The
optional third argument, divisor, is the number of bytes used to divide needle into separate
strings. Divisor must be a positive integer and must divide evenly into the length of needle. If
needle is not found, the value 0 is returned.
RPAD(strexpr1,length,strexpr2)
RPAD(strexpr1,length[,strexpr2]). String. Right-pads strexpr1 with strexpr2 to extend
it to the length given by length using as many complete copies as will fit of strexpr2 as the
padding string. The value of length represents the number of bytes and must be a positive integer.
The optional third argument strexpr2 is a quoted string or an expression that resolves to a string.
If strepxr2 is omitted, the value is padded with blanks.
RTRIM(strexpr,char)
RTRIM(strexpr[,char]). String. Trims trailing instances of char within strexpr. The
optional second argument char is a single quoted character or an expression that yields a single
character. If char is omitted, trailing blanks are trimmed.
RV.BERNOULLI(prob)
RV.BERNOULLI(prob). Numeric. Returns a random value from a Bernoulli distribution with
the specified probability parameter prob.
RV.BETA(shape1, shape2)
RV.BETA(shape1, shape2). Numeric. Returns a random value from a Beta distribution with
specified shape parameters.
RV.BINOM(n, prob)
RV.BINOM(n, prob). Numeric. Returns a random value from a binomial distribution with
specified number of trials and probability parameter.
RV.CAUCHY(loc, scale)
RV.CAUCHY(loc, scale). Numeric. Returns a random value from a Cauchy distribution with
specified location and scale parameters.
RV.CHISQ(df)
RV.CHISQ(df). Numeric. Returns a random value from a chi-square distribution with
specified degrees of freedom df.
RV.EXP(shape)
RV.EXP(scale). Numeric. Returns a random value from an exponential distribution with
specified scale parameter.
RV.F(df1, df2)
RV.F(df1, df2). Numeric. Returns a random value from an F distribution with specified
degrees of freedom, df1 and df2.
RV.GAMMA(shape, scale)
RV.GAMMA(shape, scale). Numeric. Returns a random value from a Gamma distribution with
specified shape and scale parameters.
RV.GEOM(prob)
RV.GEOM(prob). Numeric. Returns a random value from a geometric distribution with
specified probability parameter.
RV.HALFNRM
RV.HALFNRM(mean, stddev). Numeric. Returns a random value from a half normal
distribution with the specified mean and standard deviation.
RV.HYPER(total, sample, hits)
RV.HYPER(total, sample, hits). Numeric. Returns a random value from a hypergeometric
distribution with specified parameters.
RV.IGAUSS
RV.IGAUSS(loc, scale). Numeric. Returns a random value from an inverse Gaussian
distribution with the specified location and scale parameters.
RV.LAPLACE(mean, scale)
RV.LAPLACE(mean, scale). Numeric. Returns a random value from a Laplace distribution
with specified mean and scale parameters.
RV.LNORMAL(a, b)
RV.LNORMAL(a, b). Numeric. Returns a random value from a log-normal distribution with
specified parameters.
RV.LOGISTIC(mean, scale)
RV.LOGISTIC(mean, scale). Numeric. Returns a random value from a logistic distribution
with specified mean and scale parameters.
RV.NEGBIN(threshold, prob)
RV.NEGBIN(threshold, prob). Numeric. Returns a random value from a negative binomial
distribution with specified threshold and probability parameters.
RV.NORMAL(mean, stddev)
RV.NORMAL(mean, stddev). Numeric. Returns a random value from a normal distribution
with specified mean and standard deviation.
RV.PARETO(threshold, shape)
RV.PARETO(threshold, shape). Numeric. Returns a random value from a Pareto distribution
with specified threshold and shape parameters.
RV.POISSON(mean)
RV.POISSON(mean). Numeric. Returns a random value from a Poisson distribution with
specified mean/rate parameter.
RV.T(df)
RV.T(df). Numeric. Returns a random value from a Student's t distribution with
specified degrees of freedom df.
RV.UNIFORM(min, max)
RV.UNIFORM(min, max). Numeric. Returns a random value from a uniform distribution with
specified minimum and maximum. See also the UNIFORM function.
RV.WEIBULL(a, b)
RV.WEIBULL(a, b). Numeric. Returns a random value from a Weibull distribution with
specified parameters.
S
SD(numexpr,numexpr[,..])
SD(numexpr,numexpr[,..]). Numeric. Returns the standard deviation of its arguments that
have valid, nonmissing values. This function requires two or more arguments, which must be numeric.
You can specify a minimum number of valid arguments for this function to be evaluated.
SIG.CHISQ
SIG.CHISQ(quant, df). Numeric. Returns the cumulative probability that a value from the
chi-square distribution, with df degrees of freedom, will be greater than quant
Sig. F
These significance values should not be used to test hypotheses about the F values in
this table. Cluster analysis specifically attempts to maximize between-group variance, and the
significance values reported here do not reflect this.
SIN(radians)
SIN(radians). Numeric. Returns the sine of radians, which must be a numeric value,
measured in radians.
SQRT(numexpr)
SQRT(numexpr). Numeric. Returns the positive square root of numexpr, which must be
numeric and not negative.
StrApplyModel(handle, "function", category)
StrApplyModel(handle, "function", value). String. Applies a particular scoring function
to the input case data using the model specified by handle and where "function" is one of the
following string literal values enclosed in quotes: predict, stddev, probability, confidence,
nodeid, cumhazard, neighbor, distance. The model handle is the name associated with the external XML
file, as defined on the MODEL HANDLE command. The optional third argument applies when the function
is "probability", "neighbor", or "distance". For "probability", it specifies a category for which
the probability is calculated. For "neighbor" and "distance", it specifies a particular neighbor (as
an integer) for nearest neighbor models. StrApplyModel returns a blank string if a value cannot be
computed.
STRING(numexpr,format)
STRING(numexpr,format). String. Returns the string that results when numexpr is
converted to a string according to format. STRING(-1.5,F5.2) returns the string value '-1.50'. The
second argument format must be a format for writing a numeric value.
STRUNC (strexp, length)
STRUNC(strexp, length). String. Returns strexp truncated to length (in bytes) and then
trimmed of any trailing blanks. Truncation removes any fragment of a character that would be
truncated.
SUBSTR(strexpr,pos,length)
SUBSTR(strexpr,pos[,length]). String. Returns the substring beginning at byte position
pos of strexpr. The optional third argument represents the number of bytes in the substring. If the
optional argument length is omitted, returns the substring beginning at byte position pos of strexpr
and running to the end of strexpr.
SUM(numexpr,numexpr[,..])
SUM(numexpr,numexpr[,..]). Numeric. Returns the sum of its arguments that have valid,
nonmissing values. This function requires two or more arguments, which must be numeric. You can
specify a minimum number of valid arguments for this function to be evaluated.
SYSMIS(numvar)
SYSMIS(numvar). Logical. Returns 1 or true if the value of numvar is system-missing.
The argument numvar must be the name of a numeric variable in the active dataset.
T
TIME.DAYS(days)
TIME.DAYS(days). Numeric. Returns a time interval corresponding to the indicated number
of days. The argument must be numeric. To display the result as a time, assign a time format to the
result variable.
TIME.HMS(hours[,min,sec])
TIME.HMS(hours[,minutes,seconds]). Numeric. Returns a time interval corresponding to
the indicated number of hours, minutes, and seconds. The minutes and seconds arguments are optional.
Minutes and seconds must resolve to numbers less than 60 if any higher-order argument is non-zero.
All arguments except the last non-zero argument must resolve to integers. For example TIME.HMS(25.5)
and TIME.HMS(0,90,25.5) are valid, while TIME.HMS(25.5,30) and TIME.HMS(25,90) are invalid. All
arguments must resolve to either all positive or all negative values. To display the result as a
time, assign a time format to the result variable.
U
UNIFORM(max)
UNIFORM(max). Numeric. Returns a uniformly distributed pseudorandom number between 0
and the argument max, which must be numeric (but can be negative).
UPCASE(strexpr)
UPCASE(strexpr). String. Returns strexpr with lowercase letters changed to uppercase
and other characters unchanged.
V
VALUE(variable)
VALUE(variable). Numeric. Returns the value of variable, ignoring user missing-value
definitions for variable, which must be a numeric variable name or a vector reference to a variable
name.
VALUELABEL(varname)
VALUELABEL(varname). String. Returns the value label for the value of variable or an
empty string if there is no label for the value. The value of varname must be a variable name; it
cannot be an expression.
VARIANCE(numexpr,numexpr[,..])
VARIANCE(numexpr,numexpr[,..]). Numeric. Returns the variance of its arguments that
have valid values. This function requires two or more arguments, which must be numeric. You can
specify a minimum number of valid arguments for this function to be evaluated.
X
XDATE.DATE(datevalue)
XDATE.DATE(datevalue). Numeric. Returns the date portion from a numeric value that
represents a date. The argument can be a number, a date format variable, or an expression that
resolves to a date. To display the result as a date, apply a date format to the variable.
XDATE.HOUR(datetime)
XDATE.HOUR(datetime). Numeric. Returns the hour (an integer between 0 and 23) from a
value that represents a time or a datetime. The argument can be a number, a time or datetime
variable or an expression that resolves to a time or datetime value.
XDATE.JDAY(datevalue)
XDATE.JDAY(datevalue). Numeric. Returns the day of the year (an integer between 1 and
366) from a numeric value that represents a date. The argument can be a number, a date format
variable, or an expression that resolves to a date.
XDATE.MDAY(datevalue)
XDATE.MDAY(datevalue). Numeric. Returns the day of the month (an integer between 1 and
31) from a numeric value that represents a date. The argument can be a number, a date format
variable, or an expression that resolves to a date.
XDATE.MINUTE(datetime)
XDATE.MINUTE(datetime). Numeric. Returns the minute (an integer between 0 and 59) from
a value that represents a time or a datetime. The argument can be a number, a time or datetime
variable, or an expression that resolves to a time or datetime value.
XDATE.MONTH(datevalue)
XDATE.MONTH(datevalue). Numeric. Returns the month (an integer between 1 and 12) from a
numeric value that represents a date. The argument can be a number, a date format variable, or an
expression that resolves to a date.
XDATE.QUARTER(datevalue)
XDATE.QUARTER(datevalue). Numeric. Returns the quarter of the year (an integer between
1 and 4) from a numeric value that represents a date. The argument can be a number, a date format
variable, or an expression that resolves to a date.
XDATE.SECOND(datetime)
XDATE.SECOND(datetime). Numeric. Returns the second (a number between 0 and 60) from a
value that represents a time or a datetime. The argument can be a number, a time or datetime
variable or an expression that resolves to a time or datetime value.
XDATE.TDAY(timevalue)
XDATE.TDAY(timevalue). Numeric. Returns the number of whole days (as an integer) from a
numeric value that represents a time interval. The argument can be a number, a time format variable,
or an expression that resolves to a time interval.
XDATE.TIME(datetime)
XDATE.TIME(datetime). Numeric. Returns the time portion from a value that represents a
time or a datetime. The argument can be a number, a time or datetime variable or an expression that
resolves to a time or datetime value. To display the result as a time, apply a time format to the
variable.
XDATE.WEEK(datevalue)
XDATE.WEEK(datevalue). Numeric. Returns the week number (an integer between 1 and 53)
from a numeric value that represents a date. The argument can be a number, a date format variable,
or an expression that resolves to a date.
XDATE.WKDAY(datevalue)
XDATE.WKDAY(datevalue). Numeric. Returns the day-of-week number (an integer between 1,
Sunday, and 7, Saturday) from a numeric value that represents a date. The argument can be a number,
a date format variable, or an expression that resolves to a date.
XDATE.YEAR(datevalue)
XDATE.YEAR(datevalue). Numeric. Returns the year (as a four-digit integer) from a
numeric value that represents a date. The argument can be a number, a date format variable, or an
expression that resolves to a date.