Functions and CALL Routines 
Category  Functions and CALL Routines  Description 


ANYXDIGIT Function 
Searches a character string for a hexadecimal character that represents a digit, and returns the first position at which that character is found. 
Arithmetic 
DIVIDE Function 
Returns the result of a division that handles special missing values for ODS output. 
Array 
DIM Function 
Returns the number of elements in an array. 
HBOUND Function 
Returns the upper bound of an array.  
LBOUND Function 
Returns the lower bound of an array.  
Bitwise Logical Operations 
BAND Function 
Returns the bitwise logical AND of two arguments. 
BLSHIFT Function 
Returns the bitwise logical left shift of two arguments.  
BNOT Function 
Returns the bitwise logical NOT of an argument.  
BOR Function 
Returns the bitwise logical OR of two arguments.  
BRSHIFT Function 
Returns the bitwise logical right shift of two arguments.  
BXOR Function 
Returns the bitwise logical EXCLUSIVE OR of two arguments.  
Character String Matching 
CALL PRXCHANGE Routine 
Performs a patternmatching replacement. 
CALL PRXDEBUG Routine 
Enables Perl regular expressions in a DATA step to send debugging output to the SAS log.  
CALL PRXFREE Routine 
Frees memory that was allocated for a Perl regular expression.  
CALL PRXNEXT Routine 
Returns the position and length of a substring that matches a pattern, and iterates over multiple matches within one string.  
CALL PRXPOSN Routine 
Returns the start position and length for a capture buffer.  
CALL PRXSUBSTR Routine 
Returns the position and length of a substring that matches a pattern.  
PRXCHANGE Function 
Performs a patternmatching replacement.  
PRXMATCH Function 
Searches for a pattern match and returns the position at which the pattern is found.  
PRXPAREN Function 
Returns the last bracket match for which there is a match in a pattern.  
PRXPARSE Function 
Compiles a Perl regular expression (PRX) that can be used for pattern matching of a character value.  
PRXPOSN Function 
Returns a character string that contains the value for a capture buffer.  
Character 
ANYALNUM Function 
Searches a character string for an alphanumeric character, and returns the first position at which the character is found. 
ANYALPHA Function 
Searches a character string for an alphabetic character, and returns the first position at which the character is found.  
ANYCNTRL Function 
Searches a character string for a control character, and returns the first position at which that character is found.  
ANYDIGIT Function 
Searches a character string for a digit, and returns the first position at which the digit is found.  
ANYFIRST Function 
Searches a character string for a character that is valid as the first character in a SAS variable name under VALIDVARNAME=V7, and returns the first position at which that character is found.  
ANYGRAPH Function 
Searches a character string for a graphical character, and returns the first position at which that character is found.  
ANYLOWER Function 
Searches a character string for a lowercase letter, and returns the first position at which the letter is found.  
ANYNAME Function 
Searches a character string for a character that is valid in a SAS variable name under VALIDVARNAME=V7, and returns the first position at which that character is found.  
ANYPRINT Function 
Searches a character string for a printable character, and returns the first position at which that character is found.  
ANYPUNCT Function 
Searches a character string for a punctuation character, and returns the first position at which that character is found.  
ANYSPACE Function 
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.  
ANYUPPER Function 
Searches a character string for an uppercase letter, and returns the first position at which the letter is found.  
ANYXDIGIT Function 
Searches a character string for a hexadecimal character that represents a digit, and returns the first position at which that character is found.  
BYTE Function 
Returns one character in the ASCII or the EBCDIC collating sequence.  
CALL CATS Routine 
Removes leading and trailing blanks, and returns a concatenated character string.  
CALL CATT Routine 
Removes trailing blanks, and returns a concatenated character string.  
CALL CATX Routine 
Removes leading and trailing blanks, inserts delimiters, and returns a concatenated character string.  
CALL COMPCOST Routine 
Sets the costs of operations for later use by the COMPGED function  
CALL MISSING Routine 
Assigns missing values to the specified character or numeric variables.  
CALL SCAN Routine 
Returns the position and length of the nth word from a character string.  
CAT Function 
Does not remove leading or trailing blanks, and returns a concatenated character string.  
CATQ Function 
Concatenates character or numeric values by using a delimiter to separate items and by adding quotation marks to strings that contain the delimiter.  
CATS Function 
Removes leading and trailing blanks, and returns a concatenated character string.  
CATT Function 
Removes trailing blanks, and returns a concatenated character string.  
CATX Function 
Removes leading and trailing blanks, inserts delimiters, and returns a concatenated character string.  
CHAR Function 
Returns a single character from a specified position in a character string.  
CHOOSEC Function 
Returns a character value that represents the results of choosing from a list of arguments.  
CHOOSEN Function 
Returns a numeric value that represents the results of choosing from a list of arguments.  
COALESCEC Function 
Returns the first nonmissing value from a list of character arguments.  
COLLATE Function 
Returns a character string in ASCII or EBCDIC collating sequence.  
COMPARE Function 
Returns the position of the leftmost character by which two strings differ, or returns 0 if there is no difference.  
COMPBL Function 
Removes multiple blanks from a character string.  
COMPGED Function 
Returns the generalized edit distance between two strings.  
COMPLEV Function 
Returns the Levenshtein edit distance between two strings.  
COMPRESS Function 
Returns a character string with specified characters removed from the original string.  
COUNT Function 
Counts the number of times that a specified substring appears within a character string.  
COUNTC Function 
Counts the number of characters in a string that appear or do not appear in a list of characters.  
COUNTW Function 
Counts the number of words in a character string.  
DEQUOTE Function 
Removes matching quotation marks from a character string that begins with a quotation mark, and deletes all characters to the right of the closing quotation mark.  
FIND Function 
Searches for a specific substring of characters within a character string.  
FINDC Function 
Searches a string for any character in a list of characters.  
FINDW Function 
Returns the character position of a word in a string, or returns the number of the word in a string.  
FIRST Function 
Returns the first character in a character string.  
IFC Function 
Returns a character value based on whether an expression is true, false, or missing.  
INDEX Function 
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.  
INDEXC Function 
Searches a character expression for any of the specified characters, and returns the position of that character.  
INDEXW Function 
Searches a character expression for a string that is specified as a word, and returns the position of the first character in the word.  
LEFT Function 
Leftaligns a character string.  
LENGTH Function 
Returns the length of a nonblank character string, excluding trailing blanks, and returns 1 for a blank character string.  
LENGTHC Function 
Returns the length of a character string, including trailing blanks.  
LENGTHM Function 
Returns the amount of memory (in bytes) that is allocated for a character string.  
LENGTHN Function 
Returns the length of a character string, excluding trailing blanks.  
LOWCASE Function 
Converts all letters in an argument to lowercase.  
MD5 Function 
Returns the result of the message digest of a specified string.  
MISSING Function 
Returns a numeric result that indicates whether the argument contains a missing value.  
NLITERAL Function 
Converts a character string that you specify to a SAS name literal.  
NOTALNUM Function 
Searches a character string for a nonalphanumeric character, and returns the first position at which the character is found.  
NOTALPHA Function 
Searches a character string for a nonalphabetic character, and returns the first position at which the character is found.  
NOTCNTRL Function 
Searches a character string for a character that is not a control character, and returns the first position at which that character is found.  
NOTDIGIT Function 
Searches a character string for any character that is not a digit, and returns the first position at which that character is found.  
NOTFIRST Function 
Searches a character string for an invalid first character in a SAS variable name under VALIDVARNAME=V7, and returns the first position at which that character is found.  
NOTGRAPH Function 
Searches a character string for a nongraphical character, and returns the first position at which that character is found.  
NOTLOWER Function 
Searches a character string for a character that is not a lowercase letter, and returns the first position at which that character is found.  
NOTNAME Function 
Searches a character string for an invalid character in a SAS variable name under VALIDVARNAME=V7, and returns the first position at which that character is found.  
NOTPRINT Function 
Searches a character string for a nonprintable character, and returns the first position at which that character is found.  
NOTPUNCT Function 
Searches a character string for a character that is not a punctuation character, and returns the first position at which that character is found.  
NOTSPACE Function 
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 position at which that character is found.  
NOTUPPER Function 
Searches a character string for a character that is not an uppercase letter, and returns the first position at which that character is found.  
NOTXDIGIT Function 
Searches a character string for a character that is not a hexadecimal character, and returns the first position at which that character is found.  
NVALID Function 
Checks the validity of a character string for use as a SAS variable name.  
PROPCASE Function 
Converts all words in an argument to proper case.  
QUOTE Function 
Adds double quotation marks to a character value.  
RANK Function 
Returns the position of a character in the ASCII or EBCDIC collating sequence.  
REPEAT Function 
Returns a character value that consists of the first argument repeated n+1 times.  
REVERSE Function 
Reverses a character string.  
RIGHT Function 
Right aligns a character expression.  
SCAN Function 
Returns the nth word from a character string.  
SOUNDEX Function 
Encodes a string to facilitate searching.  
SPEDIS Function 
Determines the likelihood of two words matching, expressed as the asymmetric spelling distance between the two words.  
STRIP Function 
Returns a character string with all leading and trailing blanks removed.  
SUBPAD Function 
Returns a substring that has a length you specify, using blank padding if necessary.  
SUBSTR (left of =) Function 
Replaces character value contents.  
SUBSTR (right of =) Function 
Extracts a substring from an argument.  
SUBSTRN Function 
Returns a substring, allowing a result with a length of zero.  
TRANSLATE Function 
Replaces specific characters in a character string.  
TRANSTRN Function 
Replaces or removes all occurrences of a substring in a character string.  
TRANWRD Function 
Replaces all occurrences of a substring in a character string.  
TRIM Function 
Removes trailing blanks from a character string, and returns one blank if the string is missing.  
TRIMN Function 
Removes trailing blanks from character expressions, and returns a string with a length of zero if the expression is missing.  
UPCASE Function 
Converts all letters in an argument to uppercase.  
VERIFY Function 
Returns the position of the first character in a string that is not in any of several other strings.  
Combinatorial 
ALLCOMB Function 
Generates all combinations of the values of n variables taken k at a time in a minimal change order. 
ALLPERM Function 
Generates all permutations of the values of several variables in a minimal change order.  
CALL ALLCOMB Routine 
Generates all combinations of the values of n variables taken k at a time in a minimal change order.  
CALL ALLCOMBI Routine 
Generates all combinations of the indices of n objects taken k at a time in a minimal change order.  
CALL ALLPERM Routine 
Generates all permutations of the values of several variables in a minimal change order.  
CALL GRAYCODE Routine 
Generates all subsets of n items in a minimal change order.  
CALL LEXCOMB Routine 
Generates all distinct combinations of the nonmissing values of n variables taken k at a time in lexicographic order.  
CALL LEXCOMBI Routine 
Generates all combinations of the indices of n objects taken k at a time in lexicographic order.  
CALL LEXPERK Routine 
Generates all distinct permutations of the nonmissing values of n variables taken k at a time in lexicographic order.  
CALL LEXPERM Routine 
Generates all distinct permutations of the nonmissing values of several variables in lexicographic order.  
CALL RANPERK Routine 
Randomly permutes the values of the arguments, and returns a permutation of k out of n values.  
CALL RANPERM Routine 
Randomly permutes the values of the arguments.  
COMB Function 
Computes the number of combinations of n elements taken r at a time.  
GRAYCODE Function 
Generates all subsets of n items in a minimal change order.  
LCOMB Function 
Computes the logarithm of the COMB function which is the logarithm of the number of combinations of n objects taken r at a time.  
LEXCOMB Function 
Generates all distinct combinations of the nonmissing values of n variables taken k at a time in lexicographic order.  
LEXCOMBI Function 
Generates all combinations of the indices of n objects taken k at a time in lexicographic order.  
LEXPERK Function 
Generates all distinct permutations of the nonmissing values of n variables taken k at a time in lexicographic order.  
LEXPERM Function 
Generates all distinct permutations of the nonmissing values of several variables in lexicographic order.  
LFACT Function 
Computes the logarithm of the FACT (factorial) function.  
LPERM Function 
Computes the logarithm of the PERM function which is the logarithm of the number of permutations of n objects, with the option of including r number of elements.  
PERM Function 
Computes the number of permutations of n items that are taken r at a time.  
Date and Time 
CALL IS8601_CONVERT Routine 
Converts an ISO 8601 interval to datetime and duration values, or converts datetime and duration values to an ISO 8601 interval. 
DATDIF Function 
Returns the number of days between two dates after computing the difference between the dates according to specified day count conventions.  
DATE Function 
Returns the current date as a SAS date value.  
DATEJUL Function 
Converts a Julian date to a SAS date value.  
DATEPART Function 
Extracts the date from a SAS datetime value.  
DATETIME Function 
Returns the current date and time of day as a SAS datetime value.  
DAY Function 
Returns the day of the month from a SAS date value.  
DHMS Function 
Returns a SAS datetime value from date, hour, minute, and second values.  
HMS Function 
Returns a SAS time value from hour, minute, and second values.  
HOLIDAY Function 
Returns a SAS date value of a specified holiday for a specified year.  
HOUR Function 
Returns the hour from a SAS time or datetime value.  
INTCINDEX Function 
Returns the cycle index when a date, time, or datetime interval and value are specified.  
INTCK Function 
Returns the count of the number of interval boundaries between two dates, two times, or two datetime values.  
INTCYCLE Function 
Returns the date, time, or datetime interval at the next higher seasonal cycle when a date, time, or datetime interval is specified.  
INTFIT Function 
Returns a time interval that is aligned between two dates.  
INTFMT Function 
Returns a recommended SAS format when a date, time, or datetime interval is specified.  
INTGET Function 
Returns a time interval based on three date or datetime values.  
INTINDEX Function 
Returns the seasonal index when a date, time, or datetime interval and value are specified.  
INTNX Function 
Increments a date, time, or datetime value by a given time interval, and returns a date, time, or datetime value.  
INTSEAS Function 
Returns the length of the seasonal cycle when a date, time, or datetime interval is specified.  
INTSHIFT Function 
Returns the shift interval that corresponds to the base interval.  
INTTEST Function 
Returns 1 if a time interval is valid, and returns 0 if a time interval is invalid.  
JULDATE Function 
Returns the Julian date from a SAS date value.  
JULDATE7 Function 
Returns a sevendigit Julian date from a SAS date value.  
MDY Function 
Returns a SAS date value from month, day, and year values.  
MINUTE Function 
Returns the minute from a SAS time or datetime value.  
MONTH Function 
Returns the month from a SAS date value.  
NWKDOM Function 
Returns the date for the nth occurrence of a weekday for the specified month and year.  
QTR Function 
Returns the quarter of the year from a SAS date value.  
SECOND Function 
Returns the second from a SAS time or datetime value.  
TIME Function 
Returns the current time of day as a numeric SAS time value.  
TIMEPART Function 
Extracts a time value from a SAS datetime value.  
TODAY Function 
Returns the current date as a numeric SAS date value.  
WEEK Function 
Returns the weeknumber value.  
WEEKDAY Function 
From a SAS date value, returns an integer that corresponds to the day of the week.  
YEAR Function 
Returns the year from a SAS date value.  
YRDIF Function 
Returns the difference in years between two dates.  
YYQ Function 
Returns a SAS date value from year and quarter year values.  
Descriptive Statistics 
CMISS Function 
Counts the number of missing arguments. 
CSS Function 
Returns the corrected sum of squares.  
CV Function 
Returns the coefficient of variation.  
EUCLID Function 
Returns the Euclidean norm of the nonmissing arguments.  
GEOMEAN Function 
Returns the geometric mean.  
GEOMEANZ Function 
Returns the geometric mean, using zero fuzzing.  
HARMEAN Function 
Returns the harmonic mean.  
HARMEANZ Function 
Returns the harmonic mean, using zero fuzzing.  
IQR Function 
Returns the interquartile range.  
KURTOSIS Function 
Returns the kurtosis.  
LARGEST Function 
Returns the kth largest nonmissing value.  
LPNORM Function 
Returns the Lp norm of the second argument and subsequent nonmissing arguments.  
MAD Function 
Returns the median absolute deviation from the median.  
MAX Function 
Returns the largest value.  
MEAN Function 
Returns the arithmetic mean (average).  
MEDIAN Function 
Returns the median value.  
MIN Function 
Returns the smallest value.  
MISSING Function 
Returns a numeric result that indicates whether the argument contains a missing value.  
N Function 
Returns the number of nonmissing numeric values.  
NMISS Function 
Returns the number of missing numeric values.  
ORDINAL Function 
Returns the kth smallest of the missing and nonmissing values.  
PCTL Function 
Returns the percentile that corresponds to the percentage.  
RANGE Function 
Returns the range of the nonmissing values.  
RMS Function 
Returns the root mean square of the nonmissing arguments.  
SKEWNESS Function 
Returns the skewness of the nonmissing arguments.  
SMALLEST Function 
Returns the kth smallest nonmissing value.  
STD Function 
Returns the standard deviation of the nonmissing arguments.  
STDERR Function 
Returns the standard error of the mean of the nonmissing arguments.  
SUM Function 
Returns the sum of the nonmissing arguments.  
SUMABS Function 
Returns the sum of the absolute values of the nonmissing arguments.  
USS Function 
Returns the uncorrected sum of squares of the nonmissing arguments.  
VAR Function 
Returns the variance of the nonmissing arguments.  
Distance 
GEODIST Function 
Returns the geodetic distance between two latitude and longitude coordinates. 
ZIPCITYDISTANCE Function 
Returns the geodetic distance between two ZIP code locations.  
External Files 
DCLOSE Function 
Closes a directory that was opened by the DOPEN function. 
DCREATE Function 
Returns the complete pathname of a new, external directory.  
DINFO Function 
Returns information about a directory.  
DNUM Function 
Returns the number of members in a directory.  
DOPEN Function 
Opens a directory, and returns a directory identifier value.  
DOPTNAME Function 
Returns directory attribute information.  
DOPTNUM Function 
Returns the number of information items that are available for a directory.  
DREAD Function 
Returns the name of a directory member.  
DROPNOTE Function 
Deletes a note marker from a SAS data set or an external file.  
FAPPEND Function 
Appends the current record to the end of an external file.  
FCLOSE Function 
Closes an external file, directory, or directory member.  
FCOL Function 
Returns the current column position in the File Data Buffer (FDB).  
FDELETE Function 
Deletes an external file or an empty directory.  
FEXIST Function 
Verifies the existence of an external file that is associated with a fileref.  
FGET Function 
Copies data from the File Data Buffer (FDB) into a variable.  
FILEEXIST Function 
Verifies the existence of an external file by its physical name.  
FILENAME Function 
Assigns or deassigns a fileref to an external file, directory, or output device.  
FILEREF Function 
Verifies whether a fileref has been assigned for the current SAS session.  
FINFO Function 
Returns the value of a file information item.  
FNOTE Function 
Identifies the last record that was read, and returns a value that the FPOINT function can use.  
FOPEN Function 
Opens an external file and returns a file identifier value.  
FOPTNAME Function 
Returns the name of an item of information about a file.  
FOPTNUM Function 
Returns the number of information items that are available for an external file.  
FPOINT Function 
Positions the read pointer on the next record to be read.  
FPOS Function 
Sets the position of the column pointer in the File Data Buffer (FDB).  
FPUT Function 
Moves data to the File Data Buffer (FDB) of an external file, starting at the FDB's current column position.  
FREAD Function 
Reads a record from an external file into the File Data Buffer (FDB).  
FREWIND Function 
Positions the file pointer to the start of the file.  
FRLEN Function 
Returns the size of the last record that was read, or, if the file is opened for output, returns the current record size.  
FSEP Function 
Sets the token delimiters for the FGET function.  
FWRITE Function 
Writes a record to an external file.  
MOPEN Function 
Opens a file by directory ID and member name, and returns either the file identifier or a 0.  
PATHNAME Function 
Returns the physical name of an external file or a SAS library, or returns a blank.  
RENAME Function 
Renames a member of a SAS library, an entry in a SAS catalog, an external file, or a directory.  
SYSMSG Function 
Returns error or warning message text from processing the last data set or external file function.  
SYSRC Function 
Returns a system error number.  
External Routines 
CALL MODULE Routine 
Calls an external routine without any return code. 
MODULEC Function 
Calls an external routine and returns a character value.  
MODULEN Function 
Calls an external routine and returns a numeric value.  
Financial 
BLACKCLPRC Function 
Calculates call prices for European options on futures, based on the Black model. 
BLACKPTPRC Function 
Calculates put prices for European options on futures, based on the Black model.  
BLKSHCLPRC Function 
Calculates call prices for European options on stocks, based on the BlackScholes model.  
BLKSHPTPRC Function 
Calculates put prices for European options on stocks, based on the BlackScholes model.  
COMPOUND Function 
Returns compound interest parameters.  
CONVX Function 
Returns the convexity for an enumerated cash flow.  
CONVXP Function 
Returns the convexity for a periodic cash flow stream, such as a bond.  
DACCDB Function 
Returns the accumulated declining balance depreciation.  
DACCDBSL Function 
Returns the accumulated declining balance with conversion to a straightline depreciation.  
DACCSL Function 
Returns the accumulated straightline depreciation.  
DACCSYD Function 
Returns the accumulated sumofyearsdigits depreciation.  
DACCTAB Function 
Returns the accumulated depreciation from specified tables.  
DEPDB Function 
Returns the declining balance depreciation.  
DEPDBSL Function 
Returns the declining balance with conversion to a straightline depreciation.  
DEPSL Function 
Returns the straightline depreciation.  
DEPSYD Function 
Returns the sumofyearsdigits depreciation.  
DEPTAB Function 
Returns the depreciation from specified tables.  
DUR Function 
Returns the modified duration for an enumerated cash flow.  
DURP Function 
Returns the modified duration for a periodic cash flow stream, such as a bond.  
FINANCE Function 
Computes financial calculations such as depreciation, maturation, accrued interest, net present value, periodic savings, and internal rates of return.  
GARKHCLPRC Function 
Calculates call prices for European options on stocks, based on the GarmanKohlhagen model.  
GARKHPTPRC Function 
Calculates put prices for European options on stocks, based on the GarmanKohlhagen model.  
INTRR Function 
Returns the internal rate of return as a fraction.  
IRR Function 
Returns the internal rate of return as a percentage.  
MARGRCLPRC Function 
Calculates call prices for European options on stocks, based on the Margrabe model.  
MARGRPTPRC Function 
Calculates put prices for European options on stocks, based on the Margrabe model.  
MORT Function 
Returns amortization parameters.  
NETPV Function 
Returns the net present value as a fraction.  
NPV Function 
Returns the net present value with the rate expressed as a percentage.  
PVP Function 
Returns the present value for a periodic cash flow stream (such as a bond), with repayment of principal at maturity.  
SAVING Function 
Returns the future value of a periodic saving.  
YIELDP Function 
Returns the yieldtomaturity for a periodic cash flow stream, such as a bond.  
Hyperbolic 
ARCOSH Function 
Returns the inverse hyperbolic cosine. 
ARSINH Function 
Returns the inverse hyperbolic sine.  
ARTANH Function 
Returns the inverse hyperbolic tangent.  
COSH Function 
Returns the hyperbolic cosine.  
SINH Function 
Returns the hyperbolic sine.  
TANH Function 
Returns the hyperbolic tangent.  
Macro 
CALL EXECUTE Routine 
Resolves the argument, and issues the resolved value for execution at the next step boundary. 
CALL SYMPUT Routine 
Assigns DATA step information to a macro variable.  
CALL SYMPUTX Routine 
Assigns a value to a macro variable, and removes both leading and trailing blanks.  
RESOLVE Function 
Returns the resolved value of the argument after it has been processed by the macro facility.  
SYMEXIST Function 
Returns an indication of the existence of a macro variable.  
SYMGET Function 
Returns the value of a macro variable during DATA step execution.  
SYMGLOBL Function 
Returns an indication of whether a macro variable is in global scope to the DATA step during DATA step execution.  
SYMLOCAL Function 
Returns an indication of whether a macro variable is in local scope to the DATA step during DATA step execution.  
Mathematical 
ABS Function 
Returns the absolute value. 
AIRY Function 
Returns the value of the Airy function.  
BETA Function 
Returns the value of the beta function.  
CALL LOGISTIC Routine 
Applies the logistic function to each argument.  
CALL SOFTMAX Routine 
Returns the softmax value.  
CALL STDIZE Routine 
Standardizes the values of one or more variables.  
CALL TANH Routine 
Returns the hyperbolic tangent.  
CNONCT Function 
Returns the noncentrality parameter from a chisquare distribution.  
COALESCE Function 
Returns the first nonmissing value from a list of numeric arguments.  
CONSTANT Function 
Computes machine and mathematical constants.  
DAIRY Function 
Returns the derivative of the AIRY function.  
DEVIANCE Function 
Returns the deviance based on a probability distribution.  
DIGAMMA Function 
Returns the value of the digamma function.  
ERF Function 
Returns the value of the (normal) error function.  
ERFC Function 
Returns the value of the complementary (normal) error function.  
EXP Function 
Returns the value of the exponential function.  
FACT Function 
Computes a factorial.  
FNONCT Function 
Returns the value of the noncentrality parameter of an F distribution.  
GAMMA Function 
Returns the value of the gamma function.  
GCD Function 
Returns the greatest common divisor for one or more integers.  
IBESSEL Function 
Returns the value of the modified Bessel function.  
JBESSEL Function 
Returns the value of the Bessel function.  
LCM Function 
Returns the least common multiple.  
LGAMMA Function 
Returns the natural logarithm of the Gamma function.  
LOG Function 
Returns the natural (base e) logarithm.  
LOG1PX Function 
Returns the log of 1 plus the argument.  
LOG10 Function 
Returns the logarithm to the base 10.  
LOG2 Function 
Returns the logarithm to the base 2.  
LOGBETA Function 
Returns the logarithm of the beta function.  
MOD Function 
Returns the remainder from the division of the first argument by the second argument, fuzzed to avoid most unexpected floatingpoint results.  
MODZ Function 
Returns the remainder from the division of the first argument by the second argument, using zero fuzzing.  
MSPLINT Function 
Returns the ordinate of a monotonicitypreserving interpolating spline.  
SIGN Function 
Returns the sign of a value.  
SQRT Function 
Returns the square root of a value.  
TNONCT Function 
Returns the value of the noncentrality parameter from the Student's t distribution.  
TRIGAMMA Function 
Returns the value of the trigamma function.  
Numeric 
IFN Function 
Returns a numeric value based on whether an expression is true, false, or missing. 
Probability 
CDF Function 
Returns a value from a cumulative probability distribution. 
LOGCDF Function 
Returns the logarithm of a left cumulative distribution function.  
LOGPDF Function 
Returns the logarithm of a probability density (mass) function.  
LOGSDF Function 
Returns the logarithm of a survival function.  
PDF Function 
Returns a value from a probability density (mass) distribution.  
POISSON Function 
Returns the probability from a Poisson distribution.  
PROBBETA Function 
Returns the probability from a beta distribution.  
PROBBNML Function 
Returns the probability from a binomial distribution.  
PROBBNRM Function 
Returns a probability from a bivariate normal distribution.  
PROBCHI Function 
Returns the probability from a chisquare distribution.  
PROBF Function 
Returns the probability from an F distribution.  
PROBGAM Function 
Returns the probability from a gamma distribution.  
PROBHYPR Function 
Returns the probability from a hypergeometric distribution.  
PROBMC Function 
Returns a probability or a quantile from various distributions for multiple comparisons of means.  
PROBNEGB Function 
Returns the probability from a negative binomial distribution.  
PROBNORM Function 
Returns the probability from the standard normal distribution.  
PROBT Function 
Returns the probability from a t distribution.  
SDF Function 
Returns a survival function.  
Quantile 
BETAINV Function 
Returns a quantile from the beta distribution. 
CINV Function 
Returns a quantile from the chisquare distribution.  
FINV Function 
Returns a quantile from the F distribution.  
GAMINV Function 
Returns a quantile from the gamma distribution.  
PROBIT Function 
Returns a quantile from the standard normal distribution.  
QUANTILE Function 
Returns the quantile from a distribution that you specify.  
TINV Function 
Returns a quantile from the t distribution.  
Random Number 
CALL RANBIN Routine 
Returns a random variate from a binomial distribution. 
CALL RANCAU Routine 
Returns a random variate from a Cauchy distribution.  
CALL RANEXP Routine 
Returns a random variate from an exponential distribution.  
CALL RANGAM Routine 
Returns a random variate from a gamma distribution.  
CALL RANNOR Routine 
Returns a random variate from a normal distribution.  
CALL RANPOI Routine 
Returns a random variate from a Poisson distribution.  
CALL RANTBL Routine 
Returns a random variate from a tabled probability distribution.  
CALL RANTRI Routine 
Returns a random variate from a triangular distribution.  
CALL RANUNI Routine 
Returns a random variate from a uniform distribution.  
CALL STREAMINIT Routine 
Specifies a seed value to use for subsequent random number generation by the RAND function.  
NORMAL Function 
Returns a random variate from a normal, or Gaussian, distribution.  
RANBIN Function 
Returns a random variate from a binomial distribution.  
RANCAU Function 
Returns a random variate from a Cauchy distribution.  
RAND Function 
Generates random numbers from a distribution that you specify.  
RANEXP Function 
Returns a random variate from an exponential distribution.  
RANGAM Function 
Returns a random variate from a gamma distribution.  
RANNOR Function 
Returns a random variate from a normal distribution.  
RANPOI Function 
Returns a random variate from a Poisson distribution.  
RANTBL Function 
Returns a random variate from a tabled probability distribution.  
RANTRI Function 
Returns a random variate from a triangular distribution.  
RANUNI Function 
Returns a random variate from a uniform distribution.  
UNIFORM Function 
Returns a random variate from a uniform distribution.  
SAS File I/O 
ATTRC Function 
Returns the value of a character attribute for a SAS data set. 
ATTRN Function 
Returns the value of a numeric attribute for a SAS data set.  
CEXIST Function 
Verifies the existence of a SAS catalog or SAS catalog entry.  
CLOSE Function 
Closes a SAS data set.  
CUROBS Function 
Returns the observation number of the current observation.  
DROPNOTE Function 
Deletes a note marker from a SAS data set or an external file.  
DSNAME Function 
Returns the SAS data set name that is associated with a data set identifier.  
ENVLEN Function 
Returns the length of an environment variable.  
EXIST Function 
Verifies the existence of a SAS library member.  
FETCH Function 
Reads the next nondeleted observation from a SAS data set into the Data Set Data Vector (DDV).  
FETCHOBS Function 
Reads a specified observation from a SAS data set into the Data Set Data Vector (DDV).  
GETVARC Function 
Returns the value of a SAS data set character variable.  
GETVARN Function 
Returns the value of a SAS data set numeric variable.  
IORCMSG Function 
Returns a formatted error message for _IORC_.  
LIBNAME Function 
Assigns or deassigns a libref for a SAS library.  
LIBREF Function 
Verifies that a libref has been assigned.  
NOTE Function 
Returns an observation ID for the current observation of a SAS data set.  
OPEN Function 
Opens a SAS data set.  
PATHNAME Function 
Returns the physical name of an external file or a SAS library, or returns a blank.  
POINT Function 
Locates an observation that is identified by the NOTE function.  
RENAME Function 
Renames a member of a SAS library, an entry in a SAS catalog, an external file, or a directory.  
REWIND Function 
Positions the data set pointer at the beginning of a SAS data set.  
SYSMSG Function 
Returns error or warning message text from processing the last data set or external file function.  
SYSRC Function 
Returns a system error number.  
VARFMT Function 
Returns the format that is assigned to a SAS data set variable.  
VARINFMT Function 
Returns the informat that is assigned to a SAS data set variable.  
VARLABEL Function 
Returns the label that is assigned to a SAS data set variable.  
VARLEN Function 
Returns the length of a SAS data set variable.  
VARNAME Function 
Returns the name of a SAS data set variable.  
VARNUM Function 
Returns the number of a variable's position in a SAS data set.  
VARTYPE Function 
Returns the data type of a SAS data set variable.  
Search 
WHICHC Function 
Searches for a character value that is equal to the first argument, and returns the index of the first matching value. 
WHICHN Function 
Searches for a numeric value that is equal to the first argument, and returns the index of the first matching value.  
Sort 
CALL SORTC Routine 
Sorts the values of character arguments. 
CALL SORTN Routine 
Sorts the values of numeric arguments.  
Special 
ADDR Function 
Returns the memory address of a variable on a 32bit platform. 
ADDRLONG Function 
Returns the memory address of a variable on 32bit and 64bit platforms.  
CALL POKE Routine 
Writes a value directly into memory on a 32bit platform.  
CALL POKELONG Routine 
Writes a value directly into memory on 32bit and 64bit platforms.  
CALL SLEEP Routine 
For a specified period of time, suspends the execution of a program that invokes this CALL routine.  
CALL SYSTEM Routine 
Submits an operating environment command for execution.  
DIF Function 
Returns differences between an argument and its nth lag.  
GETOPTION Function 
Returns the value of a SAS system or graphics option.  
INPUT Function 
Returns the value that is produced when SAS converts an expression using the specified informat.  
INPUTC Function 
Enables you to specify a character informat at run time.  
INPUTN Function 
Enables you to specify a numeric informat at run time.  
LAG Function 
Returns values from a queue.  
PEEK Function 
Stores the contents of a memory address in a numeric variable on a 32bit platform.  
PEEKC Function 
Stores the contents of a memory address in a character variable on a 32bit platform.  
PEEKCLONG Function 
Stores the contents of a memory address in a character variable on 32bit and 64bit platforms.  
PEEKLONG Function 
Stores the contents of a memory address in a numeric variable on 32bit and 64bit platforms.  
PTRLONGADD Function 
Returns the pointer address as a character variable on 32bit and 64bit platforms.  
PUT Function 
Returns a value using a specified format.  
PUTC Function 
Enables you to specify a character format at run time.  
PUTN Function 
Enables you to specify a numeric format at run time.  
SLEEP Function 
For a specified period of time, suspends the execution of a program that invokes this function.  
SYSGET Function 
Returns the value of the specified operating environment variable.  
SYSPARM Function 
Returns the system parameter string.  
SYSPROCESSID Function 
Returns the process ID of the current process.  
SYSPROCESSNAME Function 
Returns the process name that is associated with a given process ID, or returns the name of the current process.  
SYSPROD Function 
Determines whether a product is licensed.  
SYSTEM Function 
Issues an operating environment command during a SAS session, and returns the system return code.  
UUIDGEN Function 
Returns the short or binary form of a Universal Unique Identifier (UUID).  
State and ZIP Code 
FIPNAME Function 
Converts twodigit FIPS codes to uppercase state names. 
FIPNAMEL Function 
Converts twodigit FIPS codes to mixed case state names.  
FIPSTATE Function 
Converts twodigit FIPS codes to twocharacter state postal codes.  
STFIPS Function 
Converts state postal codes to FIPS state codes.  
STNAME Function 
Converts state postal codes to uppercase state names.  
STNAMEL Function 
Converts state postal codes to mixed case state names.  
ZIPCITY Function 
Returns a city name and the twocharacter postal code that corresponds to a ZIP code.  
ZIPCITYDISTANCE Function 
Returns the geodetic distance between two ZIP code locations.  
ZIPFIPS Function 
Converts ZIP codes to twodigit FIPS codes.  
ZIPNAME Function 
Converts ZIP codes to uppercase state names.  
ZIPNAMEL Function 
Converts ZIP codes to mixed case state names.  
ZIPSTATE Function 
Converts ZIP codes to twocharacter state postal codes.  
Trigonometric 
ARCOS Function 
Returns the arccosine. 
ARSIN Function 
Returns the arcsine.  
ATAN Function 
Returns the arc tangent.  
ATAN2 Function 
Returns the arc tangent of the ratio of two numeric variables.  
COS Function 
Returns the cosine.  
SIN Function 
Returns the sine.  
TAN Function 
Returns the tangent.  
Truncation 
CEIL Function 
Returns the smallest integer that is greater than or equal to the argument, fuzzed to avoid unexpected floatingpoint results. 
CEILZ Function 
Returns the smallest integer that is greater than or equal to the argument, using zero fuzzing.  
FLOOR Function 
Returns the largest integer that is less than or equal to the argument, fuzzed to avoid unexpected floatingpoint results.  
FLOORZ Function 
Returns the largest integer that is less than or equal to the argument, using zero fuzzing.  
FUZZ Function 
Returns the nearest integer if the argument is within 1E12 of that integer.  
INT Function 
Returns the integer value, fuzzed to avoid unexpected floatingpoint results.  
INTZ Function 
Returns the integer portion of the argument, using zero fuzzing.  
ROUND Function 
Rounds the first argument to the nearest multiple of the second argument, or to the nearest integer when the second argument is omitted.  
ROUNDE Function 
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.  
ROUNDZ Function 
Rounds the first argument to the nearest multiple of the second argument, using zero fuzzing.  
TRUNC Function 
Truncates a numeric value to a specified number of bytes.  
Variable Control 
CALL LABEL Routine 
Assigns a variable label to a specified character variable. 
CALL SET Routine 
Links SAS data set variables to DATA step or macro variables that have the same name and data type.  
CALL VNAME Routine 
Assigns a variable name as the value of a specified variable.  
Variable Information 
CALL VNEXT Routine 
Returns the name, type, and length of a variable that is used in a DATA step. 
VARRAY Function 
Returns a value that indicates whether the specified name is an array.  
VARRAYX Function 
Returns a value that indicates whether the value of the specified argument is an array.  
VFORMAT Function 
Returns the format that is associated with the specified variable.  
VFORMATD Function 
Returns the decimal value of the format that is associated with the specified variable.  
VFORMATDX Function 
Returns the decimal value of the format that is associated with the value of the specified argument.  
VFORMATN Function 
Returns the format name that is associated with the specified variable.  
VFORMATNX Function 
Returns the format name that is associated with the value of the specified argument.  
VFORMATW Function 
Returns the format width that is associated with the specified variable.  
VFORMATWX Function 
Returns the format width that is associated with the value of the specified argument.  
VFORMATX Function 
Returns the format that is associated with the value of the specified argument.  
VINARRAY Function 
Returns a value that indicates whether the specified variable is a member of an array.  
VINARRAYX Function 
Returns a value that indicates whether the value of the specified argument is a member of an array.  
VINFORMAT Function 
Returns the informat that is associated with the specified variable.  
VINFORMATD Function 
Returns the decimal value of the informat that is associated with the specified variable.  
VINFORMATDX Function 
Returns the decimal value of the informat that is associated with the value of the specified variable.  
VINFORMATN Function 
Returns the informat name that is associated with the specified variable.  
VINFORMATNX Function 
Returns the informat name that is associated with the value of the specified argument.  
VINFORMATW Function 
Returns the informat width that is associated with the specified variable.  
VINFORMATWX Function 
Returns the informat width that is associated with the value of the specified argument.  
VINFORMATX Function 
Returns the informat that is associated with the value of the specified argument.  
VLABEL Function 
Returns the label that is associated with the specified variable.  
VLABELX Function 
Returns the label that is associated with the value of the specified argument.  
VLENGTH Function 
Returns the compiletime (allocated) size of the specified variable.  
VLENGTHX Function 
Returns the compiletime (allocated) size for the variable that has a name that is the same as the value of the argument.  
VNAME Function 
Returns the name of the specified variable.  
VNAMEX Function 
Validates the value of the specified argument as a variable name.  
VTYPE Function 
Returns the type (character or numeric) of the specified variable.  
VTYPEX Function 
Returns the type (character or numeric) for the value of the specified argument.  
VVALUE Function 
Returns the formatted value that is associated with the variable that you specify.  
VVALUEX Function 
Returns the formatted value that is associated with the argument that you specify.  
Web Tools 
HTMLDECODE Function 
Decodes a string that contains HTML numeric character references or HTML character entity references, and returns the decoded string. 
HTMLENCODE Function 
Encodes characters using HTML character entity references, and returns the encoded string.  
URLDECODE Function 
Returns a string that was decoded using the URL escape syntax.  
URLENCODE Function 
Returns a string that was encoded using the URL escape syntax. 
Copyright © 2011 by SAS Institute Inc., Cary, NC, USA. All rights reserved.