Chapter Contents |
Previous |
Next |
SAS Language Reference: Dictionary |
Category | Functions and CALL Routine | 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 (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 |
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 | |
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 | |
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 | |
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 | |
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 |
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 | |
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 | |
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 |
Chapter Contents |
Previous |
Next |
Top of Page |
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.