SAS FUNCTIONS
Excerpted from SAS release 8.2 Online Documentation
July, 2004
Arithmetic Functions
ABS(argument)
returns absolute value
DIM<n>(array-name)
returns the number of elements in a one-dimensional array or the number of elements in a specified dimension of a multidimensional array.
n specifies the dimension, in a multidimensional array, for which you want to know the the number of elements.
DIM(array-name,bound-n)
returns the number of elements in a one-dimensional array or the number of elements in the specified dimension of a multidimensional array
bound-n specifies the dimension in a multidimensional array, for which you want to know the number of elements.
HBOUND<n>(array-name)
returns the upper bound of an array
HBOUND(array-name,bound-n)
returns the upper bound of an array
LBOUND<n>(array-name)
returns the lower bound of an array
LBOUND(array-name,bound-n)
returns the lower bound of an array
MAX(argument,argument, ...)
returns the largest value of the numeric arguments
MIN(argument,argument, ...)
returns the smallest value of the numeric arguments
MOD(argument-1, argument-2)
returns the remainder
SIGN(argument)
returns the sign of a value or 0
SQRT(argument)
returns the square root
Character Functions
c型钢特点
BYTE(n)
returns one character in the ASCII or EBCDIC collating sequence where nis an integer representing a specific ASCII or EBCDIC character
COLLATE(start-position<,end-position>) | (start-position<,,length>)
returns an ASCII or EBCDIC collating sequence character string
COMPBL(source)
removes multiple blanks between words in a character string
COMPRESS(source<,characters-to-remove>)
removes specific characters from a character string
DEQUOTE(argument)
linux命令top详解
removes quotation marks from a character value
INDEX(source,excerpt)
searches the source for the character string specified by the excerpt
INDEXC(source,excerpt-1<, ... excerpt-n>)
searches the source for any character present in the excerpt
INDEXW(source,excerpt)
searches the source for a specified pattern as a word
LEFT(argument)
left-aligns a SAS character string
LENGTH(argument)
returns the length of an argument
LOWCASE(argument)
converts all letters in an argument to lowercase
QUOTE(argument)
adds double quotation marks to a character value
RANK(x)
returns the position of a character in the ASCII or EBCDIC collating sequence
REPEAT(argument,n)
repeats a character expression
REVERSE(argument)
reverses a character expression
RIGHT(argument)
right-aligns a character expression
SCAN(argument,n<,delimiters>)
returns a given word from a character expression
SOUNDEX(argument)
encodes a string to facilitate searching
SUBSTR(argument,position<,n>)=characters-to-replace
replaces character value contents
var=SUBSTR(argument,position<,n>)
extracts a substring from an argument. (var is any valid SAS variable name.)
TRANSLATE(source,to-1,from-1<,...to-n,from-n>)
replaces specific characters in a character expression
TRANWRD(source,target,replacement)
replaces or removes all occurrences of a word in a character string
TRIM(argument)
removes trailing blanks from character expression and returns one blank if the expression is missing
TRIMN(argument)
removes trailing blanks from character expressions and returns a null string if the expression is missing
UPCASE(argument)
converts all letters in an argument to uppercase
jsp动作标记有哪些VERIFY(source,excerpt-1<,...excerpt-n)
returns the position of the first character unique to an expression
Date and Time Functions
DATDIF(sdate,edate,basis)
returns the number of days between two dates
DATE()
returns the current date as a SAS date value
DATEJUL(julian-date)
converts a Julian date to a SAS date value
DATEPART(datetime)
extracts the date from a SAS datetime value
DATETIME()
returns the current date and time of day
用matlab画sinx图像
DAY(date)
returns the day of the month from a SAS date value
DHMS(date,hour,minute,second)
returns a SAS datetime value from date, hour, minute, and second
HMS(hour,minute,second)
returns a SAS time value from hour, minute, and second
HOUR(<time | datetime>)
returns the hour from a SAS time or datetime value
INTCK('interval',from,to)
returns the number of time intervals in a given time span
INTNX('interval',start-from,increment<,'alignment'>)
advances a date, time, or datetime value by a given interval, and returns a date, time, or datetime value
JULDATE(date)
returns the Julian date from a SAS date value
MDY(month,day,year)
returns a SAS date value from month, day, and year values
MINUTE(time | datetime)
returns the minute from a SAS time or datetime value
MONTH(date)
returns the month from a SAS date value
QTR(date)
returns the quarter of the year from a SAS date value
SECOND(time | datetime)
returns the second from a SAS time or datetime value
TIME()
returns the current time of day
TIMEPART(datetime)
extracts a time value from a SAS datetime value
TODAY()
position of the day
returns the current date as a SAS date value
WEEKDAY(date)
returns the day of the week from a SAS date value
YEAR(date)
returns the year from a SAS date value
YRDIF(sdate,edate,basis)
returns the difference in years between two dates
YYQ(year,quarter)
returns a SAS date value from the year and quarter
Mathematical Functions
AIRY(x)
returns the value of the AIRY function
DAIRY(x)
returns the derivative of the AIRY function
DIGAMMA(argument)
returns the value of the DIGAMMA function
ERF(argument)
returns the value of the (normal) error function
ERFC(argument)
returns the value of the (normal) error function
EXP(argument)
returns the value of the exponential function
GAMMA(argument)
returns the value of the GAMMA function
IBESSEL(nu,x,kode)
returns the value of the modified bessel function
JBESSEL(nu,x)
returns the value of the bessel function
LGAMMA(argument)
returns the natural logarithm of the GAMMA function
LOG(argument)
returns the natural (base e) logarithm
LOG2(argument)
returns the logarithm to the base 2
LOG10(argument)
returns the logarithm to the base 10
TRIGAMMA(argument)
returns the value of the TRIGAMMA function
Noncentrality Functions
CNONCT(x,df,prob)
returns the noncentrality parameter from a chi-squared distribution
FNONCT(x,ndf,ddf,prob)
returns the value of the noncentrality parameter of an F distribution
TNONCT(x,df,prob)
returns the value of the noncentrality parameter from the student's t distribution
Probability and Density Functions
muimui女包
CDF('dist',quantile,parm-1,...,parm-k)
computes cumulative distribution functions
LOGPDF|LOGPMF('dist',quantile,parm-1,...,parm-k)
computes the logarithm of a probability density (mass) function. The two functions are identical.
LOGSDF('dist',quantile,parm-1,...,parm-k)
computes the logarithm of a survival function
PDF|PMF('dist',quantile,parm-1,...,parm-k)
computes probability density (mass) functions
POISSON(m,n)
returns the probability from a POISSON distribution
PROBBETA(x,a,b)
returns the probability from a beta distribution
PROBBNML(p,n,m)
returns the probability from a binomial distribution
PROBCHI(x,df<,nc>)
returns the probability from a chi-squared distribution
PROBF(x,ndf,ddf<,nc>)
returns the probability from an F distribution
PROBGAM(x,a)
returns the probability from a gamma distribution
PROBHYPR(N,K,n,x<,r>)
returns the probability from a hypergeometric distribution
PROBMC
probabilities and critical values (quantiles) from various distributions for multiple comparisons of the means of several groups.
PROBNEGB(p,n,m)
returns the probability from a negative binomial distribution
PROBBNRM(x,y,r)
standardized bivariate normal distribution
PROBNORM(x)
returns the probability from the standard normal distribution
PROBT(x,df<,nc>)
returns the probability from a Student's t distribution
SDF('dist',quantile,parm-1,...,parm-k)
computes a survival function

版权声明:本站内容均来自互联网,仅供演示用,请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198,我们将在24小时内删除。