CAS Functions Listed by Product
SAS Cloud Analytic Services SAS Client
|
Name
|
Syntax and Description
|
|---|---|
|
ANYDIGIT(string <,start>)
Searches a character string for a digit, and returns
the first position at which the digit is found.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
ANYSPACE(string <,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 position at which that character
is found.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
ANYUPPER(string <,start>)
Searches a character string for an uppercase letter,
and returns the first position at which the letter is found.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL 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: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
ARCOS (argument)
Returns the arccosine.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
ARCOSH(x)
Returns the inverse hyperbolic cosine.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
ARSIN(argument)
Returns the arcsine.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
ARSINH(x)
Returns the inverse hyperbolic sine.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
ARTANH(x)
Returns the inverse hyperbolic tangent.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
ATAN(argument)
Returns the arc tangent.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
ATAN2(argument-1, argument-2)
Returns the arc tangent of the ratio of two numeric
variables.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
BAND(expression-1, expression-2)
Returns the bitwise logical AND of two arguments.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
BETA(a, b)
Returns the value of the beta function.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
BETAINV(p, a, b)
Returns a quantile from the beta distribution.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
BLACKCLPRC(E, t, F, r, sigma)
Calculates call prices for European options on futures,
based on the Black model.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
BLACKPTPRC(E, t, F, r, sigma)
Calculates put prices for European options on futures,
based on the Black model.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
BLKSHCLPRC(E, t, S, r, sigma)
Calculates call prices for European options on stocks,
based on the Black-Scholes model.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
BLKSHPTPRC(E, t, S, r, sigma)
Calculates put prices for European options on stocks,
based on the Black-Scholes model.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
BLSHIFT(expression-1, expression-2)
Returns the bitwise logical left shift of two arguments.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
BNOT(expression)
Returns the bitwise logical NOT of an argument.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
BOR(expression-1, expression-2)
Returns the bitwise logical OR of two arguments.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
BRSHIFT(expression-1, expression-2)
Returns the bitwise logical right shift of two arguments.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
BXOR(expression-1, expression-2)
Returns the bitwise logical EXCLUSIVE OR of two
arguments.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
BYTE(n)
Returns one character in the ASCII or the EBCDIC
collating sequence.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
CAT(item-1<, ...item-n>)
Does not remove leading or trailing blanks, and
returns a concatenated character string.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL 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: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
CATS(item<, ...item>)
Removes leading and trailing blanks, and returns
a concatenated character string.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
CATT(item<, ...item>)
Removes trailing blanks, and returns a concatenated
character string.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
CATX(delimiter, item-1<, ...item-n>)
Removes leading and trailing blanks, inserts delimiters,
and returns a concatenated character string.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
CEIL(expression)
Returns the smallest integer greater than or equal
to a numeric value expression.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
CEILZ(expression)
Returns the smallest integer that is greater than
or equal to the argument, using zero fuzzing.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
CHOOSEC(index-expression, selection-1<, ...selection-n>)
Returns a character value that represents the results
of choosing from a list of arguments.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
CHOOSEN(index-expression, selection-1<, ...selection-n>)
Returns a numeric value that represents the results
of choosing from a list of arguments.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
CMISS(argument <, ...argument,>)
Counts the number of missing arguments.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
CNONCT(x, df, probability)
Returns the noncentrality parameter from a chi-square
distribution.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
COALESCE(expression<, ...expression>)
Returns the first non-null or nonmissing value from
a list of numeric arguments.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
COALESCEC(expression<, ...expression>)
Returns the first non-null or nonmissing value from
a list of character arguments.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
COMB(n, r)
Computes the number of combinations of n elements
taken r at a time.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
COMPARE(string-1, string-2<, modifiers>)
Returns the position of the leftmost character by
which two strings differ, or returns 0 if there is no difference.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
COMPBL(character-expression)
Removes multiple blanks from a character string.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
COMPFUZZ(expression-1, expression-2<, fuzz<, scale>>)
Performs a fuzzy comparison of two numeric values.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
COMPOUND(a, f, r, n)
Returns compound interest parameters.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
COMPRESS(character-expression<, character-list-expression>)
Returns a character string with specified characters
removed from the original string.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
CONSTANT(constant<, parameter>)
Computes machine and mathematical constants.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
CONVX(y, f, c(1), ..., c(k))
Returns the convexity for an enumerated cash flow.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
CONVXP(A, c, n, K, k0, y)
Returns the convexity for a periodic cash flow stream,
such as a bond.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
COS(expression)
Returns the cosine in radians.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
COSH(expression)
Returns the hyperbolic cosine in radians.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
COT(argument)
Returns the cotangent.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
COUNT(string, substring<, modifiers>)
Counts the number of times that a specified substring
appears within a character string.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
COUNTC(string, charlist<, modifiers>)
Counts the number of characters in a string that
appear or do not appear in a list of characters.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
COUNTW(string<, chars<, modifiers>>)
Counts the number of words in a character string.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
CSC(argument)
Returns the cosecant.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
CSS(expression<, ...expression>)
Returns the corrected sum of squares.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
CUMIPMT(rate, number-of-periods, principal-amount<, start-period><, end-period ><, type>)
Returns the cumulative interest paid on a loan between
the start and end period.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
CUMPRINC(rate, number-of-periods, principal-amount<, start-period>
<, end-period><, type>) Returns the cumulative principal paid on a loan
between the start and end period.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
CV(expression-1, expression-2 <, ...expression-n>)
Returns the coefficient of variation.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
DAIRY(x)
Returns the derivative of the AIRY function.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
DATDIF(sdate, edate, basis)
Returns the number of days between two dates after
computing the difference between the dates according to specified
day count conventions.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
DATE( )
Returns the current date as a SAS date value.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
DATEJUL(julian-date)
Converts a Julian date to a SAS date value.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
DATEPART(datetime)
Extracts the date from a SAS datetime value.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
DATETIME( )
Returns the current date and time of day as a SAS
datetime value.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
DAY(date)
Returns the day of the month from a SAS date value.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
DEQUOTE(expression)
Removes matching single quotation marks from a character
string that begins with a single quotation mark, and deletes all characters
to the right of the closing quotation mark.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
DEVIANCE(distribution, variable, shape-parameter(s)<, ε>)
Returns the deviance based on a probability distribution.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
DHMS(date, hour, minute, second)
Returns a SAS datetime value from date, hour, minute,
and second values.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
DIGAMMA(expression)
Returns the value of the digamma function.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
DIVIDE(x, y)
Returns the result of a division that handles special
missing values for ODS output.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
DURP(A, c, n, K, k0, y)
Returns the modified duration for a periodic cash
flow stream, such as a bond.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
EFFRATE(compounding-interval, rate)
Returns the effective annual interest rate.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
ERF(expression)
Returns the value of the (normal) error function.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
ERFC(expression)
Returns the value of the complementary (normal)
error function.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
EXP(expression)
Returns the value of the e constant raised to a
specified power.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
FACT(expression)
Computes a factorial.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL 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: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
FINDC(string<, charlist>)
FINDC(string, charlist<, modifier>)
FINDC(string, charlist, modifier<, startpos>)
FINDC(string, charlist<, startpos><, modifier>)
Searches a string for any character in a list of
characters.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL 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: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
FLOOR(expression)
Returns the largest integer less than or equal to
a numeric value expression.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
FLOORZ(expression)
Returns the largest integer that is less than or
equal to the argument, using zero fuzzing.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
FMTINFO('format-name',
'information-type');
Returns information about a SAS format or informat.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
FNONCT(x, ndf, ddf, probability)
Returns the value of the noncentrality parameter
of an F distribution.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
FUZZ(expression)
Returns the nearest whole number if the argument
is within 1E-12 of that number.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
GAMINV(p, a)
Returns a quantile from the gamma distribution.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
GAMMA(expression)
Returns the value of the gamma function.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
GARKHCLPRC(E, t, S, Rd, Rf, sigma)
Calculates call prices for European options on stocks,
based on the Garman-Kohlhagen model.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
GARKHPTPRC(E, t, S, Rd, Rf, sigma)
Calculates put prices for European options on stocks,
based on the Garman-Kohlhagen model.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
GCD(expression-1, expression-2 <, ...expression-n>)
Returns the greatest common divisor for a set of
integers.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
GEODIST(latitude-1, longitude-1, latitude-2, longitude-2 <,options>)
Returns the geodetic distance between two latitude
and longitude coordinates.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
GEOMEAN(expression <, ...expression>)
Returns the geometric mean.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
GEOMEANZ(expression <, ...expression>)
Returns the geometric mean, using zero fuzzing.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
HARMEAN(expression <, ...expression>)
Returns the harmonic mean.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
HARMEANZ(expression <, ...expression>)
Returns the harmonic mean, using zero fuzzing.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
HMS(hour, minute, second)
Returns a SAS time value from hour, minute, and
second values.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
HOLIDAY('holiday', year)
Returns a SAS date value of a specified holiday
for a specified year.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
HOUR(time | datetime)
Returns the hour from a SAS time or datetime value.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
IBESSEL(nu, x, kode)
Returns the value of the modified Bessel function.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL 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: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL 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: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
INDEX(target-expression, search-expression)
Searches a character expression for a string of
characters, and returns the position of the string's first character
for the first occurrence of the string.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
INDEXC(target-expression, search-expression<, ...search-expression>)
Searches a character expression for specified characters
and returns the position of the first occurrence of any of the characters.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL 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: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
INPUTC(source, informat<, w>)
Enables you to specify a character informat at run
time.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
INPUTN(source, informat<, w<, d>>)
Enables you to specify a numeric informat at run
time.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
INT(expression)
Returns the whole number, fuzzed to avoid unexpected
floating-point results.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
INTCINDEX({interval<multiple><.shift-index>}, date-time-value)
Returns the cycle index when a date, time, or timestamp
interval and value are specified.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
INTCK({interval<multiple><.shift-index>}, start-date, end-date<,
'method'>)
INTCK(start-date, end-date<,
'method'>)
Returns the number of interval boundaries of a given
kind that lie between two SAS dates, times, or timestamp values encoded
as DOUBLE.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
INTCYCLE({interval<multiple><.shift-index>}<, seasonality>)
Returns the date, time, or datetime interval at
the next higher seasonal cycle when a date, time, or datetime interval
is specified.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
INTFIT(expresssion-1, expression-2,
'type')
Returns a time interval that is aligned between
two dates.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
INTGET(date-1, date-2, date-3)
Returns a time interval based on three date or datetime
values.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
INTINDEX({interval<multiple><.shift-index>}, date-value<, seasonality>)
Returns the seasonal index when a date, time, or
timestamp interval and value are specified.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
INTNX({interval<multiple><.shift-index>}, start-from, increment<, 'alignment'>)
INTNX(start-from, increment<, 'alignment'>)
Increments a SAS date, time, or datetime value encoded
as a DOUBLE, and returns a SAS date, time, or datetime value encoded
as a DOUBLE.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
INTRR(freq, c0, c1<..., cn>)
Returns the internal rate of return as a decimal
value.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
INTSEAS({interval<multiple><.shift-index>}<, seasonality>)
Returns the length of the seasonal cycle when a
date, time, or datetime interval is specified.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
INTSHIFT(interval<multiple><.shift-index>)
Returns the shift interval that corresponds to the
base interval.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
INTTEST(interval<multiple><.shift-index>)
Returns 1 if a time interval is valid, and returns
0 if a time interval is invalid.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
INTZ(expression)
Returns the whole number portion of the argument,
using zero fuzzing.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
IPMT(rate, period, number-of-periods, principal-amount<, future-amount><, type>)
Returns the interest payment for a given period
for a constant payment loan or the periodic savings for a future balance.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
IQR(expression <, ...expression>)
Returns the interquartile range.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
IRR(freq, c1, c2 <..., cn>)
Returns the internal rate of return as a percentage.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
JBESSEL(nu, x)
Returns the value of the Bessel function.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
JULDATE(date)
Returns the Julian date from a SAS date value.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
JULDATE7(date)
Returns a seven-digit Julian date from a SAS date
value.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
KURTOSIS(expression-1, expression-2, expression-3,
expression-4 <, ...expression-n>)
Returns the kurtosis.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
LARGEST(k, expression <, ...expression>)
Returns the kth
largest non-null or nonmissing value.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
LCM(expression-1, expression-2 <, ...expression-n>)
Returns the least common multiple for a set of whole
numbers.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
LCOMB(n, r)
Computes the logarithm of the COMB function, which
is the logarithm of the number of combinations of n objects
taken r at a time.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
LEFT(expression)
Left aligns a character expression.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
LENGTH(string)
Returns the length of a non-blank character string,
excluding trailing blanks, and returns 1 for a blank character string.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
LENGTHC(expression)
Returns the length of a character string, including
trailing blanks, in characters.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
LENGTHM(variable)
Returns the amount of memory, in bytes, that could
or might be allocated for a character string.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
LENGTHN(string)
Returns the length of a character string, excluding
trailing blanks.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
LFACT(n)
Computes the logarithm of the FACT (factorial) function.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
LGAMMA(expression)
Returns the natural logarithm of the Gamma function.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
LOG(expression)
Returns the natural logarithm (base e) of a numeric
value expression.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
LOG10(expression)
Returns the base-10 logarithm of a numeric value
expression.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
LOG1PX(x)
Returns the log of 1 plus the argument.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
LOG2(expression)
Returns the base 2 logarithm of a numeric value
expression.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
LOGBETA(a, b)
Returns the logarithm of the beta function.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
LOGISTIC(argument)
Returns the logistic transformation of the argument.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
LOWCASE(expression)
Converts all letters in a character expression to
lowercase.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
MAD(expression-1<, ...expression-n>)
Returns the median absolute deviation from the median.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
MARGRCLPRC(X1, t, X2, sigma1, sigma2, rho12)
Calculates call prices for European options on stocks,
based on the Margrabe model.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
MARGRPTPRC(X1, t, X2, sigma1, sigma2, rho12)
Calculates put prices for European options on stocks,
based on the Margrabe model.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
MAX(expression-1, expression-2 <, ...expression-n>)
Returns the largest value from a list of arguments.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
MDY(month, day, year)
Returns a SAS date value from month, day, and year
values.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
MEAN(expression-1<, ...expression-n>)
Returns the arithmetic mean (average) of the non-null
or nonmissing arguments.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
MEDIAN(expression-1<, ...expression-n >)
Returns the median value.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
MIN(expression-1, expression-2 <,
…expression-n>)
Returns the smallest value.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
MINUTE(time | datetime)
Returns the minute from a SAS time or datetime value.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
MISSING(expression)
Returns a number that indicates whether the argument
contains a missing value.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
MOD(dividend-expression, divisor-expression)
Returns the remainder from the division of the first
argument by the second argument, fuzzed to avoid most unexpected floating-point
results.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
MODZ(dividend-expression, divisor-expression)
Returns the remainder from the division of the first
argument by the second argument, using zero fuzzing.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
MONTH(date)
Returns a number that represents the month from
a SAS date value.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
MORT(a, p, r, n)
Returns amortization parameters.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
N(expression <, ...expression>)
Returns the number of non-null or nonmissing numeric
values.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
NETPV(r, freq, c0, c1, ..., cn)
Returns the net present value as a percent.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
NMISS(expression <, ...expression>)
Returns the number of null and SAS missing numeric
values.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
NOMRATE(compounding-interval, rate)
Returns the nominal annual interest rate.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
NOTALNUM('expression'<, start>)
Searches a character string for a non-alphanumeric
character, and returns the first character position at which the character
is found.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
NOTALPHA('expression'<, start>)
Searches a character string for a nonalphabetic
character, and returns the first character position at which the character
is found.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL 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: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
NOTDIGIT('expression'<, start>)
Searches a character string for any character that
is not a digit, and returns the first character position at which
that character is found.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
NOTFIRST('expression'<, start>)
Searches a character string for an invalid first
character in a SAS variable name under VALIDVARNAME=V7, and returns
the first character position at which that character is found.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL 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: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
NOTLOWER('expression'<, start>)
Searches a character string for a character that
is not a lowercase letter, and returns the first character position
at which that character is found.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
NOTNAME('expression'<, start>)
Searches a character string for an invalid character
in a SAS variable name under VALIDVARNAME=V7, and returns the first
character position at which that character is found.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL 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: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
NOTPUNCT('expression'<, start>)
Searches a character string for a character that
is not a punctuation character, and returns the first character position
at which that character is found.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
NOTSPACE('expression'<, start>)
Searches a character string for a character that
is not a whitespace character (blank, horizontal and vertical tab,
carriage return, line feed, and form feed), and returns the first
character position at which that character is found.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
NOTUPPER('expression'<, start>)
Searches a character string for a character that
is not an uppercase letter, and returns the first character position
at which that character is found.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
NOTXDIGIT('expression'<, start>)
Searches a character string for a character that
is not a hexadecimal character, and returns the first character position
at which that character is found.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
NPV(r, freq, c0, c1, ..., cn)
Returns the net present value with the rate expressed
as a percentage.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
NWKDOM(n, weekday, month, year)
Returns the date for the nth
occurrence of a weekday for the specified month and year.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
ORDINAL(position, expression-1, expression-2 <, ...expression-n>)
Orders a list of values, and returns a value that
is based on a position in the list.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
PCTL<n>(percentage, expression<, ...expression>)
Returns the percentile that corresponds to the percentage.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
PERM(n<, r>)
Computes the number of permutations of n items
that are taken r at a time.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
PMT(rate, number-of-periods, principal-amount<, future-amount><, type>)
Returns the periodic payment for a constant payment
loan or the periodic savings for a future balance.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
POISSON(m, n)
Returns the probability from a Poisson distribution.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL 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: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
PROBBETA(x, a, b)
Returns the probability from a beta distribution.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
PROBBNML(p, n, m)
Returns the probability from a binomial distribution.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
PROBCHI(x, df<, nc>)
Returns the probability from a chi-square distribution.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
PROBF(x, ndf, ddf<, nc>)
Returns the probability from an F distribution.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
PROBGAM(x, a)
Returns the probability from a gamma distribution.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
PROBHYPR(N, K, n, x<, r>)
Returns the probability from a hypergeometric distribution.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
PROBIT(p)
Returns a quantile from the standard normal distribution.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
PROBMC(distribution, q, prob, df, nparms<, parameters>)
Returns a probability or a quantile from various
distributions for multiple comparisons of means.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
PROBNEGB(p, n, m)
Returns the probability from a negative binomial
distribution.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
PRXCHANGE(perl-regular-expression | regular-expression-id, times, source)
Performs a pattern-matching replacement.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
PRXMATCH(perl-regular-expression, source)
Searches for a pattern match and returns the position
at which the pattern is found.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL 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: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
PRXPOSN(regular-expression-id, capture-buffer, source)
Returns a character string that contains the value
for a capture buffer.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
PUTC(value, format-specification <, w>)
Enables you to specify a character format at run
time.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
PUTN(value, format-specification <, w <, d>>)
Enables you to specify a numeric format at run time.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
PVP(A, c, n, K, k0, y)
Returns the present value for a periodic cash flow
stream (such as a bond), with repayment of principal at maturity.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
QTR(date)
Returns the quarter of the year from a SAS date
value.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
QUOTE(expression)
Adds double quotation marks to a character value.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
RANGE(expression <, ...expression>)
Returns the difference between the largest and the
smallest values.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
RANK(expression)
Returns the position of a character in the ASCII
or EBCDIC collating sequence.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
REPEAT(expression, n)
Repeats a character expression.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
REVERSE(expression)
Reverses a character expression.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
RIGHT(expression)
Right aligns a character expression.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
RMS(expression <, ...expression>)
Returns the root mean square.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
ROUND(expression <, rounding-unit>)
Rounds the first argument to the nearest multiple
of the second argument, or to the nearest integer when the second
argument is omitted.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL 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: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
ROUNDZ(expression <, rounding-unit>)
Rounds the first argument to the nearest multiple
of the second argument, using zero fuzzing.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
SAVING(f, p, r, n)
Returns the future value of a periodic saving.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
SAVINGS(base-date, initial-deposit-date, deposit-amount, deposit-number,
deposit-interval, compounding-interval, date-1, rate-1<, ...date-n, rate-n>) Returns the balance of a periodic savings by using
variable interest rates.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
SCAN(expression, n <, delimiters<, modifier>>)
Returns the nth
word from a character expression.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
SEC(expression)
Returns the secant.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
SECOND(time | datetime)
Returns the second from a SAS time or datetime value.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
SIGN(expression)
Returns a number that indicates the sign of a numeric
value expression.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
SIN(expression)
Returns the trigonometric sine.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
SINH(expression)
Returns the hyperbolic sine.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
SKEWNESS(expression-1, expression-2, expression-3 <, ...expression-n>)
Returns the skewness.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
SLEEP (<value>);
Sleep in the operating system (OS) for the number
of seconds specified.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
SMALLEST(k, expression <, ...expression>)
Returns the kth
smallest non-null or nonmissing value.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
SQRT(expression)
Returns the square root of a value.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
STD(expression-1, expression-2 <, ...expression-n>)
Returns the standard deviation.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
STDERR(expression-1, expression-2 <, ...expression-n>)
Returns the standard error of the mean.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
STRIP(expression)
Returns a character string with all leading and
trailing blanks removed.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
SUBSTR(“string”, position <, length>)
Returns a substring from an argument.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
SUBSTRN(character-expression, position<, length>)
Returns a substring, allowing a result with a length
of zero.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
SUM(expression-1, expression-2 <, ...expression-n>)
Returns the sum of the non-null or nonmissing arguments.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
SUMABS(value-1<, ...value-n>)
Returns the sum of the absolute values of the nonmissing
arguments.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
TAN(expression)
Returns the tangent.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
TANH(expression)
Returns the hyperbolic tangent.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
TIME( )
Returns the current time of day as a numeric SAS
time value.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
TIMEPART(datetime)
Extracts a time value from a SAS datetime value.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
TIMEVALUE(base-date, reference-date, reference-amount, compounding-interval,
date-1, rate-1<, ...date-n, rate-n>) Returns the equivalent of a reference amount at
a base date by using variable interest rates.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
TINV(p, df<, nc>)
Returns a quantile from the t distribution.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
TODAY( )
Returns the current date as a numeric SAS date value.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
TRANSLATE(expression, to-characters, from-characters)
Replaces specific characters in a character expression.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
TRANSTRN(source-expression, target-expression, replacement-expression)
Replaces or removes all occurrences of a substring
in a character string.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
TRIGAMMA(expression)
Returns the value of the trigamma function.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL 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: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
TRIMN(argument)
Removes trailing blanks from character expressions,
and returns a string with a length of zero if the expression is missing.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
TRUNC(expression, length-expression)
Truncates a numeric value to a specified length.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
Returns a random variate from a uniform distribution.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
UPCASE(expression)
Converts all letters in an argument to uppercase.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
USS(expression <, ...expression-n>)
Returns the uncorrected sum of squares.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
UUIDGEN( )
Returns the short form of a Universally Unique Identifier
(UUID).
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
VAR(expression-1, expression-2 < ,...expression-n>)
Returns the variance.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
VERIFY(target-expression, search–expression)
Returns the position of the first character that
is unique to an expression.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
WEEK(<sas-date>, <'descriptor'>)
Returns the week-number value.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
WEEKDAY(expression)
From a SAS date value, returns a whole number that
corresponds to the day of the week.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
WHICHC(search-expression, expression-list-item-1, expression-list-item-2
<, ...expression-list-item-n>) Returns the first position of a character string
from a list of character strings.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
WHICHN(search-expression, expression-list-item-1, expression-list-item-2
<, ...expression-list-item-n>) Returns the first position of a number from a list
of numbers.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
YEAR(date)
Returns the year from a SAS date value.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
YIELDP(A, c, n, K, k0, p)
Returns the yield-to-maturity for a periodic cash
flow stream, such as a bond.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
YRDIF(start-date, end-date<, basis>)
Returns the difference in years between two dates
according to specified day count conventions; returns a person’s
age.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
YYQ(year, quarter)
Returns a SAS date value from year and quarter year
values.
Product: SAS Cloud Analytic Services SAS Client
Document: SAS Cloud Analytic Services: CASL Reference
|
Last updated: March 23, 2022