sas函数大全 - 经管之家

15438

收藏 2011-01-04

WORD版下载http://www.pinggu.org/bbs/thread-1004933-1-1.html

Functions and CALL Routines by Category
Categories and Descriptions of Functions Category Function Description
Array DIM Returns the number of elements in an array

HBOUND Returns the upper bound of an array

LBOUND Returns the lower bound of an array
Bitwise Logical Operations BAND Returns the bitwise logical AND of two arguments

BLSHIFT Returns the bitwise logical left shift of two arguments

BNOT Returns the bitwise logical NOT of an argument

BOR Returns the bitwise logical OR of two arguments

BRSHIFT Returns the bitwise logical right shift of two arguments

BXOR Returns the bitwise logical EXCLUSIVE OR of two arguments
Character String Matching CALL RXCHANGE Changes one or more substrings that match a pattern

CALL RXFREE Frees memory allocated by other regular expression_r(RX) functions and CALL routines

CALL RXSUBSTR Finds the position, length, and score of a substring that matches a pattern

RXMATCH Finds the beginning of a substring that matches a pattern and returns a value

RXPARSE Parses a pattern and returns a value
Character BYTE Returns one character in the ASCII or the EBCDIC collating sequence

扫码加我拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

全部回复

guo.bailing

2011-1-4 12:54:19

COLLATE Returns an ASCII or EBCDIC collating sequence character string

COMPBL Removes multiple blanks from a character string

COMPRESS Removes specific characters from a character string

DEQUOTE Removes quotation marks from a character value

INDEX Searches a character expression for a string of characters

INDEXC Searches a character expression for specific characters

INDEXW Searches a character expression for a specified string as a word

LEFT Left aligns a SAS character expression

LENGTH Returns the length of an argument

LOWCASE Converts all letters in an argument to lowercase

MISSING Returns a numeric result that indicates whether the argument contains a missing value

QUOTE Adds double quotation marks to a character value

RANK Returns the position of a character in the ASCII or EBCDIC collating sequence

REPEAT Repeats a character expression

REVERSE Reverses a character expression

RIGHT Right aligns a character expression

SCAN Selects a given word from a character expression

SOUNDEX Encodes a string to facilitate searching

SPEDIS Determines the likelihood of two words matching, expressed as the asymmetric spelling distance between the two words

SUBSTR (left of =) Replaces character value contents

SUBSTR (right of =) Extracts a substring from an argument

TRANSLATE Replaces specific characters in a character expression

扫码加我拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

guo.bailing

2011-1-4 12:54:50

TRANWRD Replaces or removes all occurrences of a word in a character string

TRIM Removes trailing blanks from character expressions and returns one blank if the expression is missing

TRIMN Removes trailing blanks from character expressions and returns a null string (zero blanks) if the expression is missing

UPCASE Converts all letters in an argument to uppercase

VERIFY Returns the position of the first character that is unique to an expression
DBCS KCOMPARE Returns the result of a comparison of character strings

KCOMPRESS Removes specific characters from a character string

KCOUNT Returns the number of double-byte characters in a string

KINDEX Searches a character expression for a string of characters

KINDEXC Searches a character expression for specific characters

KLEFT Left aligns a SAS character expression by removing unnecessary leading DBCS blanks and SO/SI

KLENGTH Returns the length of an argument

KLOWCASE Converts all letters in an argument to lowercase

KREVERSE Reverses a character expression

KRIGHT Right aligns a character expression by trimming trailing DBCS blanks and SO/SI

KSCAN Selects a given word from a character expression

KSTRCAT Concatenates two or more character strings

KSUBSTR Extracts a substring from an argument

KSUBSTRB Extracts a substring from an argument based on byte position

KTRANSLATE Replaces specific characters in a character expression

KTRIM Removes trailing DBCS blanks and SO/SI from character expressions

KTRUNCATE Truncates a numeric value to a specified length

KUPCASE Converts all single-byte letters in an argument to uppercase

KUPDATE Inserts, deletes, and replaces character value contents

KUPDATEB Inserts, deletes, and replaces character value contents based on byte unit

KVERIFY Returns the position of the first character that is unique to an expression
Date and Time DATDIF Returns the number of days between two dates

DATE Returns the current date as a SAS date value

DATEJUL Converts a Julian date to a SAS date value

DATEPART Extracts the date from a SAS datetime value

DATETIME Returns the current date and time of day as a SAS datetime value

DAY Returns the day of the month from a SAS date value

DHMS Returns a SAS datetime value from date, hour, minute, and second

HMS Returns a SAS time value from hour, minute, and second values

扫码加我拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

guo.bailing

2011-1-4 12:55:18

HOUR Returns the hour from a SAS time or datetime value

INTCK Returns the integer number of time intervals in a given time span

INTNX Advances a date, time, or datetime value by a given interval, and returns a date, time, or datetime value

JULDATE Returns the Julian date from a SAS date value

JULDATE7 Returns a seven-digit Julian date from a SAS date value

MDY Returns a SAS date value from month, day, and year values

MINUTE Returns the minute from a SAS time or datetime value

MONTH Returns the month from a SAS date value

QTR Returns the quarter of the year from a SAS date value

SECOND Returns the second from a SAS time or datetime value

TIME Returns the current time of day

TIMEPART Extracts a time value from a SAS datetime value

TODAY Returns the current date as a SAS date value

WEEKDAY Returns the day of the week from a SAS date value

YEAR Returns the year from a SAS date value

YRDIF Returns the difference in years between two dates

YYQ Returns a SAS date value from the year and quarter
Descriptive Statistics CSS Returns the corrected sum of squares

CV Returns the coefficient of variation

KURTOSIS Returns the kurtosis

MAX Returns the largest value

MEAN Returns the arithmetic mean (average)

MIN Returns the smallest value

MISSING Returns a numeric result that indicates whether the argument contains a missing value

N Returns the number of nonmissing values

NMISS Returns the number of missing values

ORDINAL Returns any specified order statistic

RANGE Returns the range of values

SKEWNESS Returns the skewness

STD Returns the standard deviation

STDERR Returns the standard error of the mean

SUM Returns the sum of the nonmissing arguments

USS Returns the uncorrected sum of squares

VAR Returns the variance
External Files DCLOSE Closes a directory that was opened by the DOPEN function and returns a value

DINFO Returns information about a directory

DNUM Returns the number of members in a directory

DOPEN Opens a directory and returns a directory identifier value

DOPTNAME Returns directory attribute information

DOPTNUM Returns the number of information items that are available for a directory

DREAD Returns the name of a directory member

DROPNOTE Deletes a note marker from a SAS data set or an external file and returns a value

FAPPEND Appends the current record to the end of an external file and returns a value

FCLOSE Closes an external file, directory, or directory member, and returns a value

FCOL Returns the current column position in the File Data Buffer (FDB)

FDELETE Deletes an external file or an empty directory

FEXIST Verifies the existence of an external file associated with a fileref and returns a value

FGET Copies data from the File Data Buffer (FDB) into a variable and returns a value

FILEEXIST Verifies the existence of an external file by its physical name and returns a value

FILENAME Assigns or deassigns a fileref for an external file, directory, or output device and returns a value

FILEREF Verifies that a fileref has been assigned for the current SAS session and returns a value

FINFO Returns the value of a file information item

FNOTE Identifies the last record that was read and returns a value that FPOINT can use

FOPEN Opens an external file and returns a file identifier value

扫码加我拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

guo.bailing

2011-1-4 12:55:53

FOPTNAME Returns the name of an item of information about a file

FOPTNUM Returns the number of information items that are available for an external file

FPOINT Positions the read pointer on the next record to be read and returns a value

FPOS Sets the position of the column pointer in the File Data Buffer (FDB) and returns a value

FPUT Moves data to the File Data Buffer (FDB) of an external file, starting at the FDB's current column position, and returns a value

FREAD Reads a record from an external file into the File Data Buffer (FDB) and returns a value

FREWIND Positions the file pointer to the start of the file and returns a value

FRLEN Returns the size of the last record read, or, if the file is opened for output, returns the current record size

FSEP Sets the token delimiters for the FGET function and returns a value

FWRITE Writes a record to an external file and returns a value

MOPEN Opens a file by directory id and member name, and returns the file identifier or a 0

PATHNAME Returns the physical name of a SAS data library or of an external file, or returns a blank

SYSMSG Returns the text of error messages or warning messages from the last data set or external file function execution

SYSRC Returns a system error number
External Routines CALL MODULE Calls the external routine without any return code

CALL MODULEI Calls the external routine without any return code (in IML environment only)

MODULEC Calls an external routine and returns a character value

MODULEIC Calls an external routine and returns a character value (in IML environment only)

MODULEIN Calls an external routine and returns a numeric value (in IML environment only)

MODULEN Calls an external routine and returns a numeric value
Financial COMPOUND Returns compound interest parameters

CONVX Returns the convexity for an enumerated cashflow

CONVXP Returns the convexity for a periodic cashflow stream, such as a bond

DACCDB Returns the accumulated declining balance depreciation

DACCDBSL Returns the accumulated declining balance with conversion to a straight-line depreciation

DACCSL Returns the accumulated straight-line depreciation

DACCSYD Returns the accumulated sum-of-years-digits depreciation

DACCTAB Returns the accumulated depreciation from specified tables

DEPDB Returns the declining balance depreciation

DEPDBSL Returns the declining balance with conversion to a straight-line depreciation

DEPSL Returns the straight-line depreciation

DEPSYD Returns the sum-of-years-digits depreciation

DEPTAB Returns the depreciation from specified tables

DUR Returns the modified duration for an enumerated cashflow

DURP Returns the modified duration for a periodic cashflow stream, such as a bond

INTRR Returns the internal rate of return as a fraction

IRR Returns the internal rate of return as a percentage

MORT Returns amortization parameters

NETPV Returns the net present value as a fraction

NPV Returns the net present value with the rate expressed as a percentage

PVP Returns the present value for a periodic cashflow stream, such as a bond

SAVING Returns the future value of a periodic saving

扫码加我拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

guo.bailing

2011-1-4 12:56:31

YIELDP Returns the yield-to-maturity for a periodic cashflow stream, such as a bond
Hyperbolic COSH Returns the hyperbolic cosine

SINH Returns the hyperbolic sine

TANH Returns the hyperbolic tangent
Macro CALL EXECUTE Resolves an argument and issues the resolved value for execution

CALL SYMPUT Assigns DATA step information to a macro variable

RESOLVE Returns the resolved value of an argument after it has been processed by the macro facility

SYMGET Returns the value of a macro variable during DATA step execution
Mathematical ABS Returns the absolute value

AIRY Returns the value of the airy function

CNONCT Returns the noncentrality parameter from a chi-squared distribution

COMB Computes the number of combinations of n elements taken r at a time and returns a value

CONSTANT Computes some machine and mathematical constants and returns a value

DAIRY Returns the derivative of the airy function

DEVIANCE Computes the deviance and returns a value

DIGAMMA Returns the value of the DIGAMMA function

ERF Returns the value of the (normal) error function

ERFC Returns the value of the complementary (normal) error function

EXP Returns the value of the exponential function

FACT Computes a factorial and returns a value

FNONCT Returns the value of the noncentrality parameter of an F distribution

GAMMA Returns the value of the Gamma function

IBESSEL Returns the value of the modified bessel function

JBESSEL Returns the value of the bessel function

LGAMMA Returns the natural logarithm of the Gamma function

LOG Returns the natural (base e) logarithm

LOG10 Returns the logarithm to the base 10

LOG2 Returns the logarithm to the base 2

MOD Returns the remainder value

PERM Computes the number of permutations of n items taken r at a time and returns a value

SIGN Returns the sign of a value

SQRT Returns the square root of a value

TNONCT Returns the value of the noncentrality parameter from the student's t distribution

TRIGAMMA Returns the value of the TRIGAMMA function
Probability CDF Computes cumulative distribution functions

扫码加我拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

点击查看更多内容…

guo.bailing

2011-1-4 12:57:25

LOGPDF Computes the logarithm of a probability (mass) function

LOGSDF Computes the logarithm of a survival function

PDF Computes probability density (mass) functions

POISSON Returns the probability from a Poisson distribution

PROBBETA Returns the probability from a beta distribution

PROBBNML Returns the probability from a binomial distribution

PROBBNRM Computes a probability from the bivariate normal distribution and returns a value

PROBCHI Returns the probability from a chi-squared distribution

PROBF Returns the probability from an F distribution

PROBGAM Returns the probability from a gamma distribution

PROBHYPR Returns the probability from a hypergeometric distribution

PROBMC Computes a probability or a quantile from various distributions for multiple comparisons of means, and returns a value

PROBNEGB Returns the probability from a negative binomial distribution

PROBNORM Returns the probability from the standard normal distribution

PROBT Returns the probability from a t distribution

SDF Computes a survival function
Quantile BETAINV Returns a quantile from the beta distribution

CINV Returns a quantile from the chi-squared distribution

FINV Returns a quantile from the F distribution

GAMINV Returns a quantile from the gamma distribution

PROBIT Returns a quantile from the standard normal distribution

TINV Returns a quantile from the t distribution
Random Number CALL RANBIN Returns a random variate from a binomial distribution

CALL RANCAU Returns a random variate from a Cauchy distribution

CALL RANEXP Returns a random variate from an exponential distribution

CALL RANGAM Returns a random variate from a gamma distribution

CALL RANNOR Returns a random variate from a normal distribution

CALL RANPOI Returns a random variate from a Poisson distribution

CALL RANTBL Returns a random variate from a tabled probability distribution

CALL RANTRI Returns a random variate from a triangular distribution

CALL RANUNI Returns a random variate from a uniform distribution

NORMAL Returns a random variate from a normal distribution

RANBIN Returns a random variate from a binomial distribution

RANCAU Returns a random variate from a Cauchy distribution

RANEXP Returns a random variate from an exponential distribution

RANGAM Returns a random variate from a gamma distribution

RANNOR Returns a random variate from a normal distribution

RANPOI Returns a random variate from a Poisson distribution

RANTBL Returns a random variate from a tabled probability

RANTRI Random variate from a triangular distribution

RANUNI Returns a random variate from a uniform distribution

UNIFORM Random variate from a uniform distribution
SAS File I/O ATTRC Returns the value of a character attribute for a SAS data set

ATTRN Returns the value of a numeric attribute for the specified SAS data set

CEXIST Verifies the existence of a SAS catalog or SAS catalog entry and returns a value

CLOSE Closes a SAS data set and returns a value

CUROBS Returns the observation number of the current observation

DROPNOTE Deletes a note marker from a SAS data set or an external file and returns a value

DSNAME Returns the SAS data set name that is associated with a data set identifier

EXIST Verifies the existence of a SAS data library member

FETCH Reads the next nondeleted observation from a SAS data set into the Data Set Data Vector (DDV) and returns a value

FETCHOBS Reads a specified observation from a SAS data set into the Data Set Data Vector (DDV) and returns a value

GETVARC Returns the value of a SAS data set character variable

GETVARN Returns the value of a SAS data set numeric variable

IORCMSG Returns a formatted error message for _IORC_

LIBNAME Assigns or deassigns a libref for a SAS data library and returns a value

LIBREF Verifies that a libref has been assigned and returns a value

NOTE Returns an observation ID for the current observation of a SAS data set

OPEN Opens a SAS data set and returns a value

PATHNAME Returns the physical name of a SAS data library or of an external file, or returns a blank

POINT Locates an observation identified by the NOTE function and returns a value

REWIND Positions the data set pointer at the beginning of a SAS data set and returns a value

扫码加我拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

guo.bailing

2011-1-4 12:57:44

SYSMSG Returns the text of error messages or warning messages from the last data set or external file function execution

SYSRC Returns a system error number

VARFMT Returns the format assigned to a SAS data set variable

VARINFMT Returns the informat assigned to a SAS data set variable

VARLABEL Returns the label assigned to a SAS data set variable

VARLEN Returns the length of a SAS data set variable

VARNAME Returns the name of a SAS data set variable

VARNUM Returns the number of a variable's position in a SAS data set

VARTYPE Returns the data type of a SAS data set variable
Special ADDR Returns the memory address of a variable

CALL POKE Writes a value directly into memory

CALL SYSTEM Submits an operating environment command for execution

DIF Returns differences between the argument and its nth lag

GETOPTION Returns the value of a SAS system or graphics option

INPUT Returns the value produced when a SAS expression that uses a specified informat expression is read

INPUTC Enables you to specify a character informat at run time

INPUTN Enables you to specify a numeric informat at run time

LAG Returns values from a queue

PEEK Stores the contents of a memory address into a numeric variable

PEEKC Stores the contents of a memory address into a character variable

POKE Writes a value directly into memory

PUT Returns a value using a specified format

PUTC Enables you to specify a character format at run time

PUTN Enables you to specify a numeric format at run time

SYSGET Returns the value of the specified operating environment variable

SYSPARM Returns the system parameter string

SYSPROD Determines if a product is licensed

SYSTEM Issues an operating environment command during a SAS session
State and ZIP Code FIPNAME Converts FIPS codes to uppercase state names

FIPNAMEL Converts FIPS codes to mixed case state names

FIPSTATE Converts FIPS codes to two-character postal codes

STFIPS Converts state postal codes to FIPS state codes

STNAME Converts state postal codes to uppercase state names

STNAMEL Converts state postal codes to mixed case state names

ZIPFIPS Converts ZIP codes to FIPS state codes

ZIPNAME Converts ZIP codes to uppercase state names

ZIPNAMEL Converts ZIP codes to mixed case state names

ZIPSTATE Converts ZIP codes to state postal codes
Trigonometric ARCOS Returns the arccosine

ARSIN Returns the arcsine

ATAN Returns the arctangent

COS Returns the cosine

SIN Returns the sine

TAN Returns the tangent
Truncation CEIL Returns the smallest integer that is greater than or equal to the argument

FLOOR Returns the largest integer that is less than or equal to the argument

FUZZ Returns the nearest integer if the argument is within 1E-12

INT Returns the integer value

ROUND Rounds to the nearest round-off unit

TRUNC Truncates a numeric value to a specified length
Variable Control CALL LABEL Assigns a variable label to a specified character variable

CALL SET Links SAS data set variables to DATA step or macro variables that have the same name and data type

CALL VNAME Assigns a variable name as the value of a specified variable
Variable Information VARRAY Returns a value that indicates whether the specified name is an array

VARRAYX Returns a value that indicates whether the value of the specified argument is an array

VFORMAT Returns the format that is associated with the specified variable

扫码加我拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

guo.bailing

2011-1-4 12:58:32

VFORMATD Returns the format decimal value that is associated with the specified variable

VFORMATDX Returns the format decimal value that is associated with the value of the specified argument

VFORMATN Returns the format name that is associated with the specified variable

VFORMATNX Returns the format name that is associated with the value of the specified argument

VFORMATW Returns the format width that is associated with the specified variable

VFORMATWX Returns the format width that is associated with the value of the specified argument

VFORMATX Returns the format that is associated with the value of the specified argument

VINARRAY Returns a value that indicates whether the specified variable is a member of an array

VINARRAYX Returns a value that indicates whether the value of the specified argument is a member of an array

VINFORMAT Returns the informat that is associated with the specified variable

VINFORMATD Returns the informat decimal value that is associated with the specified variable

VINFORMATDX Returns the informat decimal value that is associated with the value of the specified argument

VINFORMATN Returns the informat name that is associated with the specified variable

VINFORMATNX Returns the informat name that is associated with the value of the specified argument

VINFORMATW Returns the informat width that is associated with the specified variable

VINFORMATWX Returns the informat width that is associated with the value of the specified argument

VINFORMATX Returns the informat that is associated with the value of the specified argument

VLABEL Returns the label that is associated with the specified variable

VLABELX Returns the variable label for the value of a specified argument

VLENGTH Returns the compile-time (allocated) size of the specified variable

VLENGTHX Returns the compile-time (allocated) size for the value of the specified argument

VNAME Returns the name of the specified variable

VNAMEX Validates the value of the specified argument as a variable name

VTYPE Returns the type (character or numeric) of the specified variable

VTYPEX Returns the type (character or numeric) for the value of the specified argument
Web Tools HTMLDECODE Decodes a string containing HTML numeric character references or HTML character entity references and returns the decoded string

HTMLENCODE Encodes characters using HTML character entity references and returns the encoded string

URLDECODE Returns a string that was decoded using the URL escape syntax

URLENCODE Returns a string that was encoded using the URL escape syntax