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
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小时内删除。
发表评论