General Functions Syntax Listed by Category

Arithmetic

Name
Syntax and Description
DIVIDE(x, y)
Returns the result of a division that handles special missing values for ODS output.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference

Array

D H L

Name
Syntax and Description
DIM < n > (array-name)
DIM(array-name,bound-n)
Returns the number of elements in an array.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
HBOUND < n > (array-name)
HBOUND(array-name,bound-n)
Returns the upper bound of an array.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
LBOUND < n > (array-name)
LBOUND(array-name,bound-n)
Returns the lower bound of an array.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference

Bitwise Logical Operations

B

Name
Syntax and Description
band(argument-1,argument-2)
Returns the bitwise logical AND of two arguments.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
BLSHIFT(argument-1,argument-2)
Returns the bitwise logical left shift of two arguments.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
BNOT(argument)
Returns the bitwise logical NOT of an argument.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
BOR(argument-1,argument-2)
Returns the bitwise logical OR of two arguments.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
BRSHIFT(argument-1,argument-2)
Returns the bitwise logical right shift of two arguments.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
BXOR(argument-1, argument-2)
Returns the bitwise logical EXCLUSIVE OR of two arguments.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference

Character

A B C D F I K L M N P Q R S T U V

Name
Syntax and Description
ANYALNUM(string <,start > )
Searches a character string for an alphanumeric character, and returns the first position at which the character is found.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
ANYALPHA(string <,start > )
Searches a character string for an alphabetic character, and returns the first position at which the character is found.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
ANYCNTRL(string <,start > )
Searches a character string for a control character, and returns the first position at which that character is found.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
ANYDIGIT(string <,start > )
Searches a character string for a digit, and returns the first position at which the digit is found.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
ANYFIRST(string <,start > )
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.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
ANYGRAPH(string <,start > )
Searches a character string for a graphical character, and returns the first position at which that character is found.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
ANYLOWER(string <,start > )
Searches a character string for a lowercase letter, and returns the first position at which the letter is found.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
ANYNAME(string <,start > )
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.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
ANYPRINT(string <,start > )
Searches a character string for a printable character, and returns the first position at which that character is found.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
ANYPUNCT(string <,start > )
Searches a string for a punctuation character and returns the first position at which that character is found.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
ANYPUNCT(string <,start > )
Searches a character string for a punctuation character, and returns the first position at which that character is found.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
ANYSPACE(string <,start > )
Searches a character string for a white-space character (blank, horizontal and vertical tab, carriage return, line feed, and form feed), and returns the first position at which that character is found.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
ANYUPPER(string <,start > )
Searches a character string for an uppercase letter, and returns the first position at which the letter is found.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
ANYXDIGIT(string <,start > )
Searches a character string for a hexadecimal character that represents a digit, and returns the first position at which that character is found.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
BYTE(n)
Returns one character in the ASCII collating sequence.
Product: Base SAS
Document: SAS 9.3 Companion for UNIX Environments
BYTE(n)
Returns one character in the ASCII collating sequence.
Product: Base SAS
Document: SAS 9.3 Companion for Windows
BYTE (n)
Returns one character in the ASCII or the EBCDIC collating sequence.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
CAT(item-1 <, …, item-n > )
Does not remove leading or trailing blanks, and returns a concatenated character string.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
CATQ(modifiers <, delimiter > , item-1 <, …, item-n > )
Concatenates character or numeric values by using a delimiter to separate items and by adding quotation marks to strings that contain the delimiter.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
CATS(item-1 <, …, item-n > )
Removes leading and trailing blanks, and returns a concatenated character string.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
CATT(item-1 <, … item-n > )
Removes trailing blanks, and returns a concatenated character string.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
CATX(delimiter, item-1 <, … item-n > )
Removes leading and trailing blanks, inserts delimiters, and returns a concatenated character string.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
CHAR(string, position)
Returns a single character from a specified position in a character string.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
CHOOSEC (index-expression, selection-1 <,…selection-n > )
Returns a character value that represents the results of choosing from a list of arguments.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
CHOOSEN (index-expression, selection-1 <,…selection-n > )
Returns a numeric value that represents the results of choosing from a list of arguments.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
COALESCEC(argument-1 < ..., argument-n > )
Returns the first non-missing value from a list of character arguments.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
COLLATE(start-position <,end-position > ) | (start-position <,,length > )
Returns a character string in an ASCII collating sequence.
Product: Base SAS
Document: SAS 9.3 Companion for UNIX Environments
COLLATE (start-position < ,end-position > )|(start-position <,,length > )
Returns an ASCII collating sequence character string.
Product: Base SAS
Document: SAS 9.3 Companion for Windows
COLLATE (start-position <,end-position > ) | (start-position <,,length > )
Returns a character string in ASCII or EBCDIC collating sequence.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
COMPARE(string–1, string–2 <,modifiers > )
Returns the position of the leftmost character by which two strings differ, or returns 0 if there is no difference.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
COMPBL(source)
Removes multiple blanks from a character string.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
COMPGED(string-1, string-2 <,cutoff > <,modifiers > )
Returns the generalized edit distance between two strings.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
COMPLEV(string-1, string-2 <,cutoff > <,modifiers > )
Returns the Levenshtein edit distance between two strings.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
COMPRESS(< source > <, chars > <, modifiers > )
Returns a character string with specified characters removed from the original string.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
COUNT(string,substring <,modifiers > )
Counts the number of times that a specified substring appears within a character string.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
COUNTC(string, charlist <,modifiers > )
Counts the number of characters in a string that appear or do not appear in a list of characters.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
COUNTW(< string > <, chars > <, modifiers > )
Counts the number of words in a character string.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
DEQUOTE(string)
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.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
FIND(string,substring <,modifiers > <,startpos > )
FIND(string,substring <,startpos > <,modifiers > )
Searches for a specific substring of characters within a character string.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
FINDC(string <, charlist > )
FINDC(string, charlist <,modifiers > )
FINDC(string, charlist, modifier(s) <, startpos > )
FINDC(string, charlist, < startpos > , < modifiers)>
Searches a string for any character in a list of characters.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
FINDW(string, word <, chars > )
FINDW(string, word, chars, modifiers <, startpos > )
FINDW(string, word, chars, startpos <, modifiers > )
FINDW(string, word, startpos <, chars <, modifiers > > )
Returns the character position of a word in a string, or returns the number of the word in a string.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
FIRST(string)
Returns the first character in a character string.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
IFC(logical-expression, value-returned-when-true, value-returned-when-false
<,value-returned-when-missing > )
Returns a character value based on whether an expression is true, false, or missing.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
INDEX(source,excerpt)
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.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
INDEXC(source,excerpt-1 <,… excerpt-n > )
Searches a character expression for any of the specified characters, and returns the position of that character.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
INDEXW(source,excerpt <,delimiters > )
Searches a character expression for a string that is specified as a word, and returns the position of the first character in the word.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
KCVT(text, intype, outtype, < options,…> )
Converts data from one type of encoding data to another encoding data.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
LEFT(argument)
Left-aligns a character string.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
LENGTH(string)
Returns the length of a non-blank character string, excluding trailing blanks, and returns 1 for a blank character string.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
LENGTHC(string)
Returns the length of a character string, including trailing blanks.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
LENGTHM(string)
Returns the amount of memory (in bytes) that is allocated for a character string.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
LENGTHN(string)
Returns the length of a character string, excluding trailing blanks.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
LOWCASE(argument)
Converts all letters in an argument to lowercase.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
MD5(string)
Returns the result of the message digest of a specified string.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
MISSING( numeric-expression | character-expression )
Returns a numeric result that indicates whether the argument contains a missing value.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
MVALID(libname, string, memtype <,validmemname >)
Checks the validity of a character string for use as a SAS member name.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
NLITERAL(string)
Converts a character string that you specify to a SAS name literal.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
NOTALNUM(string <,start > )
Searches a character string for a nonalphanumeric character, and returns the first position at which the character is found.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
NOTALPHA(string <,start > )
Searches a character string for a nonalphabetic character, and returns the first position at which the character is found.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
NOTCNTRL(string <,start > )
Searches a character string for a character that is not a control character, and returns the first position at which that character is found.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
NOTDIGIT(string <,start > )
Searches a character string for any character that is not a digit, and returns the first position at which that character is found.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
NOTFIRST(string <,start > )
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.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
NOTGRAPH(string <,start > )
Searches a character string for a non-graphical character, and returns the first position at which that character is found.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
NOTLOWER(string <,start > )
Searches a character string for a character that is not a lowercase letter, and returns the first position at which that character is found.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
NOTNAME(string <,start > )
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.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
NOTPRINT(string <,start > )
Searches a character string for a nonprintable character, and returns the first position at which that character is found.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
NOTPUNCT(string <,start > )
Searches a character string for a character that is not a punctuation character, and returns the first position at which that character is found.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
NOTSPACE(string <,start > )
Searches a character string for a character that is not a white-space character (blank, horizontal and vertical tab, carriage return, line feed, and form feed), and returns the first position at which that character is found.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
NOTUPPER(string <,start > )
Searches a character string for a character that is not an uppercase letter, and returns the first position at which that character is found.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
NOTXDIGIT(string <,start > )
Searches a character string for a character that is not a hexadecimal character, and returns the first position at which that character is found.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
NVALID(string <,validvarname > )
Checks the validity of a character string for use as a SAS variable name.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
PROPCASE(argument <,delimiters > )
Converts all words in an argument to proper case.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
QUOTE(argument)
Adds double quotation marks to a character value.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
RANK(x)
Returns the position of a character in the ASCII collating sequence.
Product: Base SAS
Document: SAS 9.3 Companion for Windows
RANK(x)
Returns the position of a character in the ASCII collating sequence.
Product: Base SAS
Document: SAS 9.3 Companion for UNIX Environments
RANK(x)
Returns the position of a character in the ASCII or EBCDIC collating sequence.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
REPEAT(argument,n)
Returns a character value that consists of the first argument repeated n+1 times.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
REVERSE(argument)
Reverses a character string.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
RIGHT(argument)
Right aligns a character expression.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
SCAN(string, count <,charlist <,modifiers > > )
Returns the th word from a character string.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
SOUNDEX(argument)
Encodes a string to facilitate searching.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
SPEDIS(query,keyword)
Determines the likelihood of two words matching, expressed as the asymmetric spelling distance between the two words.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
STPSRV_HEADER( Header Name , Header Value )
Adds or modifies a header
Product: SAS Integration Technologies
Document: SAS 9.3 Stored Processes: Developer's Guide
STPSRV_SESSION(' command ',< timeout >)
Creates or deletes a session
Product: SAS Integration Technologies
Document: SAS 9.3 Stored Processes: Developer's Guide
STPSRV_UNQUOTE2( paramname )
Unmasks quotation mark characters in an input parameter
Product: SAS Integration Technologies
Document: SAS 9.3 Stored Processes: Developer's Guide
STPSRVGETC( valuecode )
Returns the character value of a server property
Product: SAS Integration Technologies
Document: SAS 9.3 Stored Processes: Developer's Guide
STPSRVSET( valuecode , newvalue )
Sets the value of a server property
Product: SAS Integration Technologies
Document: SAS 9.3 Stored Processes: Developer's Guide
STRIP(string)
Returns a character string with all leading and trailing blanks removed.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
SUBPAD(string, position <, length > )
Returns a substring that has a length you specify, using blank padding if necessary.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
SUBSTR(variable, position <,length >)=characters-to-replace
Replaces character value contents.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
< variable=> SUBSTR(string,position <,length > )
Extracts a substring from an argument.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
SUBSTRN(string, position <, length >)
Returns a substring, allowing a result with a length of zero.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
TRANSLATE(source,to-1,from-1 <,…to-n, from-n > )
Replaces specific characters in a character expression.
Product: Base SAS
Document: SAS 9.3 Companion for Windows
TRANSLATE(source,to-1,from-1 <,…to-n,from-n > )
Replaces specific characters in a character expression.
Product: Base SAS
Document: SAS 9.3 Companion for UNIX Environments
TRANSLATE(source, to-1, from-1, <... to-n, from-n > )
Replaces specific characters in a character expression.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
TRANSLATE(source,to-1,from-1 <,…to-n,from-n > )
Replaces specific characters in a character string.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
TRANSTRN(source,target,replacement)
Replaces or removes all occurrences of a substring in a character string.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
TRANTAB(string,trantab_name)
Transcodes data by using the specified translation table.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
TRANWRD(source,target,replacement)
Replaces all occurrences of a substring in a character string.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
TRIM(argument)
Removes trailing blanks from a character string, and returns one blank if the string is missing.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
TRIMN(argument)
Removes trailing blanks from character expressions, and returns a string with a length of zero if the expression is missing.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
STR=UNICODE(< instr > (,<Unicode type> ))
converts Unicode characters to the current SAS session encoding.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
STR=UNICODEC(< instr > (,<Unicode type> ))
converts characters in the current SAS session encoding to Unicode characters.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
UNICODELEN()
specifies the length of the character unit for the Unicode data.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
UNICODEWIDTH()
specifies the length of a display unit for the Unicode data.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
UPCASE(argument)
Converts all letters in an argument to uppercase.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
VERIFY(source,excerpt-1 <, …, excerpt-n > )
Returns the position of the first character in a string that is not in any of several other strings.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference

Character String Matching

P

Name
Syntax and Description
PRXCHANGE( perl-regular-expression regular-expression-id , times, source)
Performs a pattern-matching replacement.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
PRXMATCH ( regular-expression-id | perl-regular-expression , source)
Searches for a pattern match and returns the position at which the pattern is found.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
PRXPAREN (regular-expression-id)
Returns the last bracket match for which there is a match in a pattern.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
regular-expression-id=PRXPARSE (perl-regular-expression)
Compiles a Perl regular expression (PRX) that can be used for pattern matching of a character value.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
PRXPOSN(regular-expression-id, capture-buffer, source)
Returns a character string that contains the value for a capture buffer.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference

Combinatorial

A C G L P

Name
Syntax and Description
ALLCOMB(count, k, variable-1, … , variable-n)
Generates all combinations of the values of variables taken at a time in a minimal change order.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
ALLPERM(count, variable-1 <,variable-2 …> )
Generates all permutations of the values of several variables in a minimal change order.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
COMB(n,r)
Computes the number of combinations of elements taken at a time.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
GRAYCODE(k, numeric-variable-1, ..., numeric-variable-n)
GRAYCODE(k, character-variable <, n <, in-out > > )
Generates all subsets of items in a minimal change order.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
LCOMB(n,r)
Computes the logarithm of the COMB function, which is the logarithm of the number of combinations of objects taken at a time.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
LEXCOMB(count, k, variable-1, …, variable-n)
Generates all distinct combinations of the non-missing values of variables taken at a time in lexicographic order.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
LEXCOMBI(n, k, index-1, …, k)
Generates all combinations of the indices of objects taken at a time in lexicographic order.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
LEXPERK(count, k, variable-1, …, variable-n)
Generates all distinct permutations of the non-missing values of variables taken at a time in lexicographic order.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
LEXPERM(count, variable-1 <, …, variable-N > )
Generates all distinct permutations of the non-missing values of several variables in lexicographic order.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
LFACT(n)
Computes the logarithm of the FACT (factorial) function.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
LPERM(n <,r > )
Computes the logarithm of the PERM function, which is the logarithm of the number of permutations of objects, with the option of including number of elements.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
PERM(n <,r > )
Computes the number of permutations of items that are taken at a time.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference

Currency Conversion

Name
Syntax and Description
EUROCURR(from-currency-amount, from-currency-code, to-currency-code)
Converts one European currency to another.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide

DBCS

K

Name
Syntax and Description
KCOMPARE(source,< pos, < count,> > findstr)
Returns the result of a comparison of character expressions.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
KCOMPRESS(source,< characters-to-remove > )
Removes specified characters from a character expression.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
KCOUNT(source)
Returns the number of double-byte characters in an expression.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
KINDEX(source, excerpt)
Searches a character expression for a string of characters.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
KINDEXC(source,excerpt-1 <,… excerpt-n > )
Searches a character expression for specified characters.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
KLEFT(argument)
Left-aligns a character expression by removing unnecessary leading DBCS blanks and SO/SI.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
KLENGTH(argument)
Returns the length of an argument.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
KLOWCASE(argument)
Converts all letters in an argument to lowercase.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
str=KPROPCASE(< instr > , (<options> ))
Converts Chinese, Japanese, Korean, Taiwanese (CJKT) characters.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
str=KPROPCHAR(< instr > )
Converts special characters to normal characters.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
str=KPROPDATA(< instr > (<option, input encode name, output encode name> ))
Removes or converts unprintable characters.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
KREVERSE(argument)
Reverses a character expression.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
KRIGHT(argument)
Right-aligns a character expression by trimming trailing DBCS blanks and SO/SI.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
KSCAN(argument,n <, delimiters > )
Selects a specified word from a character expression.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
KSTRCAT(argument-1, argument-2 <, … argument-n > )
Concatenates two or more character expressions.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
KSUBSTR(argument,position <,n > )
Extracts a substring from an argument.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
KSUBSTRB(argument,position <,n > )
Extracts a substring from an argument according to the byte position of the substring in the argument.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
KTRANSLATE(source, to-1, from-1 <...to-n, from-n >)
Replaces specific characters in a character expression.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
KTRANSLATE(source,to-1,from-1 <,…to-n,from-n > )
Replaces specific characters in a character expression.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
KTRIM(argument)
Removes trailing DBCS blanks and SO/SI from character expressions.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
KTRUNCATE(argument, number, length)
Truncates a string to a specified length in byte unit without breaking multibyte characters.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
KUPCASE(argument)
Converts all letters in an argument to uppercase.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
KUPDATE(argument,position,n <, characters-to-replace > )
KUPDATE(argument,position <,n > , characters-to-replace)
Inserts, deletes, and replaces character value contents.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
KUPDATEB(argument,position,n <,characters-to-replace > )
KUPDATEB(argument,position <, n > , characters-to-replace)
Inserts, deletes, and replaces the contents of the character value according to the byte position of the character value in the argument.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
KVERIFY(source,excerpt-1 <,…excerpt-n > )
Returns the position of the first character that is unique to an expression.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide

Date and Time

D H I J M N Q S T W Y

Name
Syntax and Description
DATDIF(sdate,edate,basis)
Returns the number of days between two dates after computing the difference between the dates according to specified day count conventions.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
DATE()
Returns the current date as a SAS date value.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
DATEJUL(julian-date)
Converts a Julian date to a SAS date value.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
DATEPART(datetime)
Extracts the date from a SAS datetime value.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
DATETIME()
Returns the current date and time of day as a SAS datetime value.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
DAY(date)
Returns the day of the month from a SAS date value.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
DHMS(date,hour,minute,second)
Returns a SAS datetime value from date, hour, minute, and second values.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
HMS(hour,minute,second)
Returns a SAS time value from hour, minute, and second values.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
HOLIDAY('holiday', year)
Returns a SAS date value of a specified holiday for a specified year.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
HOUR( time | datetime )
Returns the hour from a SAS time or datetime value.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
INTCINDEX(interval < < multiple.< shift-index > > > , date-time-value)
Returns the cycle index when a date, time, or datetime interval and value are specified.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
INTCK(interval < multiple > < .shift-index >, start-date, end-date, <'method'> )
INTCK(custom-interval, start-date, end-date, <'method'> )
Returns the number of interval boundaries of a given kind that lie between two dates, times, or datetime values.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
INTCYCLE(interval < < multiple.< shift-index > > >, < seasonality >)
Returns the date, time, or datetime interval at the next higher seasonal cycle when a date, time, or datetime interval is specified.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
INTFIT(argument-1, argument-2, 'type')
Returns a time interval that is aligned between two dates.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
INTFMT(interval < < multiple.< .shift-index > > > , 'size')
Returns a recommended SAS format when a date, time, or datetime interval is specified.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
INTGET(date-1, date-2, date-3)
Returns a time interval based on three date or datetime values.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
INTINDEX(interval < < multiple.< shift-index > > >, date-value, < seasonality >)
Returns the seasonal index when a date, time, or datetime interval and value are specified.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
INTNX(interval < multiple > < .shift-index > , start-from, increment <, 'alignment'> )
INTNX(custom-interval, start-from, increment <, 'alignment'> )
Increments a date, time, or datetime value by a given time interval, and returns a date, time, or datetime value.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
INTSEAS(interval < < multiple.< shift-index > > > < seasonality >)
Returns the length of the seasonal cycle when a date, time, or datetime interval is specified.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
INTSHIFT(interval < < multiple.< shift-index > > > )
Returns the shift interval that corresponds to the base interval.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
INTTEST(interval < < multiple.< shift-index > > > )
Returns 1 if a time interval is valid, and returns 0 if a time interval is invalid.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
JULDATE(date)
Returns the Julian date from a SAS date value.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
JULDATE7(date)
Returns a seven-digit Julian date from a SAS date value.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
MDY(month,day,year)
Returns a SAS date value from month, day, and year values.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
MINUTE(time | datetime)
Returns the minute from a SAS time or datetime value.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
MONTH(date)
Returns the month from a SAS date value.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
NLDATE(date,descriptor)
Converts the SAS date value to the date value of the specified locale by using the date format descriptors.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
NLDATM(datetime,descriptor)
Converts the SAS datetime value to the time value of the specified locale by using the datetime-format descriptors.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
NLTIME(time|datetime,descriptor,startpos)
Converts the SAS time or the datetime value to the time value of the specified locale by using the NLTIME descriptors.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
NWKDOM(n, weekday, month, year)
Returns the date for the th occurrence of a weekday for the specified month and year.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
QTR(date)
Returns the quarter of the year from a SAS date value.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
SECOND( time | datetime )
Returns the second from a SAS time or datetime value.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
TIME()
Returns the current time of day as a numeric SAS time value.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
TIMEPART(datetime)
Extracts a time value from a SAS datetime value.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
TODAY()
Returns the current date as a numeric SAS date value.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
WEEK(< sas-date > , < 'descriptor' > )
Returns the week-number value.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
WEEKDAY(date)
From a SAS date value, returns an integer that corresponds to the day of the week.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
YEAR(date)
Returns the year from a SAS date value.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
YRDIF(start-date,end-date,< basis >)
Returns the difference in years between two dates according to specified day count conventions; returns a person’s age.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
YYQ(year,quarter)
Returns a SAS date value from year and quarter year values.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference

Descriptive Statistics

C E G H I K L M N O P R S U V

Name
Syntax and Description
CMISS(argument-1 <, argument-2,…> )
Counts the number of missing arguments.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
CSS(argument-1 <,...argument-n > )
Returns the corrected sum of squares.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
CV(argument-1,argument-2 <,...argument-n > )
Returns the coefficient of variation.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
EUCLID(value-1 <,value-2 ... > )
Returns the Euclidean norm of the nonmissing arguments.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
GEOMEAN(argument <,argument,…> )
Returns the geometric mean.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
GEOMEANZ(argument <,argument,…> )
Returns the geometric mean, using zero fuzzing.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
HARMEAN(argument <,argument,…> )
Returns the harmonic mean.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
HARMEANZ(argument <,argument,…> )
Returns the harmonic mean, using zero fuzzing.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
IQR(value-1 <,value-2...> )
Returns the interquartile range.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
KURTOSIS(argument-1,argument-2,argument-3,argument-4 <,…,argument-n > )
Returns the kurtosis.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
LARGEST (k, value-1 <, value-2 ...> )
Returns theth largest non-missing value.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
LPNORM(p, value-1 <,value-2 …> )
Returns the L norm of the second argument and subsequent non-missing arguments.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
MAD(value-1 <, value-2...> )
Returns the median absolute deviation from the median.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
MAX(argument-1,argument-2 <,...argument-n > )
Returns the largest value.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
MEAN(argument-1 <,...argument-n > )
Returns the arithmetic mean (average).
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
MEDIAN(value1 <, value2, ...> )
Returns the median value.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
MIN(argument-1,argument-2 <,...argument-n > )
Returns the smallest value.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
MISSING( numeric-expression | character-expression )
Returns a numeric result that indicates whether the argument contains a missing value.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
N(argument-1 <,...argument-n > )
Returns the number of nonmissing numeric values.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
NMISS(argument-1 <,...argument-n > )
Returns the number of missing numeric values.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
ORDINAL(k,argument-1,argument-2 <,... argument-n > )
Returns the k smallest of the missing and nonmissing values.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
PCTL < n > (percentage, value1 <,value2,... > )
Returns the percentile that corresponds to the percentage.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
RANGE(argument-1 <,...argument-n > )
Returns the range of the nonmissing values.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
RMS(argument <,argument,... > )
Returns the root mean square of the nonmissing arguments.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
SKEWNESS(argument-1,argument-2,argument-3 <,... argument-n > )
Returns the skewness of the nonmissing arguments.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
SMALLEST (k, value-1 <, value-2 ... > )
Returns the th smallest nonmissing value.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
STD(argument-1,argument-2 <,...argument-n > )
Returns the standard deviation of the nonmissing arguments.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
STDERR(argument-1,argument-2 <,... argument-n > )
Returns the standard error of the mean of the nonmissing arguments.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
SUM(argument,argument,... )
Returns the sum of the nonmissing arguments.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
SUMABS(value-1 <,value-2 ... > )
Returns the sum of the absolute values of the non-missing arguments.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
USS(argument-1 <,...argument-n > )
Returns the uncorrected sum of squares of the nonmissing arguments.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
VAR(argument-1,argument-2 <,...argument-n > )
Returns the variance of the nonmissing arguments.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference

Distance

G Z

Name
Syntax and Description
GEODIST(latitude-1, longitude-1, latitude-2, longitude-2 <,options > )
Returns the geodetic distance between two latitude and longitude coordinates.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
ZIPCITYDISTANCE(zip-code-1, zip-code-2)
Returns the geodetic distance between two ZIP code locations.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference

Encoding

E

Name
Syntax and Description
ENCODCOMPAT(source1,<source2>)
Verifies the transcoding compatibility between two encodings.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
ENCODISVALID(source)
specifies a valid encoding name.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide

External Files

D F M P R S Z

Name
Syntax and Description
DCLOSE(directory-id)
Closes a directory that was opened by the DOPEN function.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
DCREATE(directory-name <,parent-directory > )
Returns the complete pathname of a new, external directory.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
DINFO(directory-id, info-item)
Returns information about a directory.
Product: Base SAS
Document: SAS 9.3 Companion for UNIX Environments
DINFO(directory-id, info-item)
Returns information about a directory.
Product: Base SAS
Document: SAS 9.3 Companion for Windows
DINFO(directory-id, info-item)
Returns information about a directory.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
DINFO(directory-id,info-item)
Returns information about a directory.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
DNUM(directory-id)
Returns the number of members in a directory.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
DOPEN(fileref)
Opens a directory, and returns a directory identifier value.
Product: Base SAS
Document: SAS 9.3 Companion for UNIX Environments
DOPEN(“fileref”)
Opens a directory and returns a directory identifier value.
Product: Base SAS
Document: SAS 9.3 Companion for Windows
DOPEN(fileref)
Opens a directory and returns a directory identifier value.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
DOPEN(fileref)
Opens a directory, and returns a directory identifier value.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
DOPTNAME(directory-id, nval)
Returns directory attribute information.
Product: Base SAS
Document: SAS 9.3 Companion for UNIX Environments
DOPTNAME(directory-id, nval )
Returns the name of a directory information item.
Product: Base SAS
Document: SAS 9.3 Companion for Windows
DOPTNAME(directory-id,nval)
Returns the name of a directory information item.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
DOPTNAME(directory-id,nval)
Returns directory attribute information.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
DOPTNUM(directory-id)
Returns the number of information items that are available for a directory.
Product: Base SAS
Document: SAS 9.3 Companion for UNIX Environments
DOPTNUM(directory-id)
Returns the number of information items that are available for a directory.
Product: Base SAS
Document: SAS 9.3 Companion for Windows
DOPTNUM(directory-id)
Returns the number of information items that are available for a directory.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
DOPTNUM(directory-id)
Returns the number of information items that are available for a directory.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
DREAD(directory-id,nval)
Returns the name of a directory member.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
DROPNOTE( data-set-id | file-id ,note-id)
Deletes a note marker from a SAS data set or an external file.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
DSNCATLGD(filename)
Verifies the existence of an external file in the z/OS system catalog by its physical name.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
FAPPEND(file-id <,cc > )
Appends the current record to the end of an external file.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
FCLOSE(file-id)
Closes an external file, a directory, or a directory member.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
FCLOSE(file-id)
Closes an external file, directory, or directory member.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
FCOL(file-id)
Returns the current column position in the File Data Buffer (FDB).
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
FDELETE(“fileref”)
Deletes an external file or an empty directory.
Product: Base SAS
Document: SAS 9.3 Companion for UNIX Environments
FDELETE(“fileref”)
Deletes an external file or an empty directory.
Product: Base SAS
Document: SAS 9.3 Companion for Windows
FDELETE (fileref)
Deletes an external file or an empty directory.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
FDELETE( fileref | directory )
Deletes an external file or an empty directory.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
FEXIST(fileref)
Verifies the existence of an external file that is associated with a fileref.
Product: Base SAS
Document: SAS 9.3 Companion for UNIX Environments
FEXIST(“fileref”)
Verifies the existence of an external file by its fileref.
Product: Base SAS
Document: SAS 9.3 Companion for Windows
FEXIST(fileref)
Verifies the existence of an external file associated with a fileref.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
FEXIST(fileref)
Verifies the existence of an external file that is associated with a fileref.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
FGET(file-id,variable <,length > )
Copies data from the File Data Buffer (FDB) into a variable.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
FILEEXIST(filename)
Verifies the existence of an external file by its physical name.
Product: Base SAS
Document: SAS 9.3 Companion for UNIX Environments
FILEEXIST(“filename”)
Verifies the existence of an external file by its physical name.
Product: Base SAS
Document: SAS 9.3 Companion for Windows
FILEEXIST(filename)
Verifies the existence of an external file by its physical name.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
FILEEXIST(file-name)
Verifies the existence of an external file by its physical name.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
FILENAME(fileref, filename <,device-type<,“host-options”<,dir-ref>>>)
Assigns or deassigns a fileref for an external file, directory, or output device.
Product: Base SAS
Document: SAS 9.3 Companion for UNIX Environments
FILENAME (“fileref”, “filename” <,device-type<,host-options<,dir-ref>>>)
Assigns or deassigns a fileref for an external file, directory, or output device.
Product: Base SAS
Document: SAS 9.3 Companion for Windows
FILENAME(fileref,filename <,device <,host-options > > )
Assigns or deassigns a fileref for an external file, a directory, or an output device.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
FILENAME(fileref <,file-name > <,device-type > <,'host-options'> <,dir-ref > )
Assigns or deassigns a fileref to an external file, directory, or output device.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
FILEREF(fileref)
Verifies whether a fileref has been assigned for the current SAS session.
Product: Base SAS
Document: SAS 9.3 Companion for UNIX Environments
FILEREF(“fileref”)
Verifies that a fileref has been assigned for the current SAS session.
Product: Base SAS
Document: SAS 9.3 Companion for Windows
FILEREF(fileref)
Verifies that a fileref has been assigned for the current SAS session.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
FILEREF(fileref)
Verifies whether a fileref has been assigned for the current SAS session.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
FINFO(file-id, info-item)
Returns the value of a file information item for an external file.
Product: Base SAS
Document: SAS 9.3 Companion for UNIX Environments
FINFO(file-id, info-item)
Returns the value of an information item for an external file.
Product: Base SAS
Document: SAS 9.3 Companion for Windows
FINFO(file-id,info-item)
Returns the value of a file information item for an external file.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
FINFO(file-id,info-item)
Returns the value of a file information item.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
FNOTE(file-id)
Identifies the last record that was read, and returns a value that the FPOINT function can use.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
FOPEN(fileref <,open-mode <,record-length <,record-format > > > )
Opens an external file and returns a file identifier value.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
FOPEN(fileref <,open-mode <,record-length <,record-format > > > )
Opens an external file and returns a file identifier value.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
FOPTNAME(file-id, nval)
Returns the name of an item of information about an external file.
Product: Base SAS
Document: SAS 9.3 Companion for UNIX Environments
FOPTNAME(file-id, nval)
Returns the name of an information item for an external file.
Product: Base SAS
Document: SAS 9.3 Companion for Windows
FOPTNAME(file-id,nval)
Returns the name of an information item for an external file.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
FOPTNAME(file-id,nval)
Returns the name of an item of information about a file.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
FOPTNUM(file-id)
Returns the number of information items that are available for an external file.
Product: Base SAS
Document: SAS 9.3 Companion for UNIX Environments
FOPTNUM(file-id)
Returns the number of information items that are available for a file.
Product: Base SAS
Document: SAS 9.3 Companion for Windows
FOPTNUM(file-id)
Returns the number of information items that are available for an external file.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
FOPTNUM(file-id)
Returns the number of information items that are available for an external file.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
FPOINT(file-id,note-id)
Positions the read pointer on the next record to be read.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
FPOS(file-id,nval)
Sets the position of the column pointer in the File Data Buffer (FDB).
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
FPUT(file-id,cval)
Moves data to the File Data Buffer (FDB) of an external file, starting at the FDB's current column position.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
FREAD(file-id)
Reads a record from an external file into the File Data Buffer (FDB).
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
FREWIND(file-id)
Positions the file pointer to the start of the file.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
FRLEN(file-id)
Returns the size of the last record that was read, or, if the file is opened for output, returns the current record size.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
FSEP(file-id,characters <,'x' | 'X' > )
Sets the token delimiters for the FGET function.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
FWRITE(file-id <,cc > )
Writes a record to an external file.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
MOPEN(directory-id,member-name<,open-mode<,record-length<,record-format>>>)
Opens a file by directory ID and member name, and returns either the file identifier or a 0.
Product: Base SAS
Document: SAS 9.3 Companion for UNIX Environments
MOPEN(directory-id,member-name <,open-mode <,record-length <,record-format > > > )
Opens a file by directory ID and by member name, and returns either the file identifier or a 0.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
MOPEN(directory-id,member-name < ,open-mode <,record-length <,record-format > > > )
Opens a file by directory ID and member name, and returns either the file identifier or a 0.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
PATHNAME(( fileref | libref ) <,search-level > )
Returns the physical name of a SAS library or of an external file or returns a blank.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
PATHNAME((fileref | libref) <,search-ref > )
Returns the physical name of an external file or a SAS library, or returns a blank.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
RENAME(old-name, new-name <, type <, description <, password <, generation > > > > )
Renames a member of a SAS library, an entry in a SAS catalog, an external file, or a directory.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
SYSMSG()
Returns error or warning message text from processing the last data set or external file function.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
SYSRC()
Returns a system error number.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
zdsattr( variable name , < option >);
Returns the attributes for the data set name that is specified in the input variable according to the type of request.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
zdsidnm( variable name , index );
Returns individual data set names from the variable that the ZDSLIST function created based on an index.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
zdslist( category , data set filter , volume filter , < option >);
Returns a list of data set names.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
zdsnum(variable name);
Returns a count of the number of data set names that are returned from the ZDSLIST function.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
zdsxatt( variable name );
Returns the number of attributes retrieved by a previous ZDSATTR request.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
zdsyatt( variable name , indexj );
Displays each attribute that is created by .
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
ZVOLLIST( category , < volume filter >, < option >);
Returns a list of volume serial numbers.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS

External Routines

M

Name
Syntax and Description
CALL MODULE(< cntl > ,module,arg-1,arg-2. . . ,arg-n);
num=MODULEN(< cntl > ,module,arg-1,arg-2…,arg-n);
char=MODULEC(< cntl > ,module,arg-1…,arg-2,arg-n);
CALL MODULEI < cntl > ,module arg-1,arg-2. . . ,arg-n);
num=MODULEIN(< cntl > ,module,arg-1,arg-2. . .,arg-n)
char=MODULEIC(< cntl > ,module,arg-1,arg-2. . .,arg-n);
Calls a specific routine or module that resides in an external dynamic link library (DLL).
Product: Base SAS
Document: SAS 9.3 Companion for Windows
MODULEC(< cntl-string,> module-name <,argument-1, ..., argument-n >)
Calls an external routine and returns a character value.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
MODULEN(< cntl-string,> module-name <,argument-1, ..., argument-n >)
Calls an external routine and returns a numeric value.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference

Financial

B C D E F G I M N P S T Y

Name
Syntax and Description
BLACKCLPRC(E, t, F, r, sigma)
Calculates call prices for European options on futures, based on the Black model.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
BLACKPTPRC(E, t, F, r, sigma)
Calculates put prices for European options on futures, based on the Black model.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
BLKSHCLPRC(E, t, S, r, sigma)
Calculates call prices for European options on stocks, based on the Black-Scholes model.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
BLKSHPTPRC(E, t, S, r, sigma)
Calculates put prices for European options on stocks, based on the Black-Scholes model.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
COMPOUND(a,f,r,n)
Returns compound interest parameters.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
CONVX(y,f,c(1), ... ,c(k))
Returns the convexity for an enumerated cash flow.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
CONVXP(A,c,n,K,k0 ,y)
Returns the convexity for a periodic cash flow stream, such as a bond.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
CUMIPMT (rate, number-of-periods, principal-amount, < start-period >, < end-period >, < type >)
Returns the cumulative interest paid on a loan between the start and end period.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
CUMPRINC (rate, number-of-periods, principal-amount, < start-period >, < end-period >, < type >)
Returns the cumulative principal paid on a loan between the start and end period.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
DACCDB(p,v,y,r)
Returns the accumulated declining balance depreciation.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
DACCDBSL(p,v,y,r)
Returns the accumulated declining balance with conversion to a straight-line depreciation.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
DACCSL(p,v,y)
Returns the accumulated straight-line depreciation.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
DACCSYD(p,v,y)
Returns the accumulated sum-of-years-digits depreciation.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
DACCTAB(p,v,t1, . . . ,tn)
Returns the accumulated depreciation from specified tables.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
DEPDB(p,v,y,r)
Returns the declining balance depreciation.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
DEPDBSL(p,v,y,r)
Returns the declining balance with conversion to a straight-line depreciation.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
DEPSL(p,v,y)
Returns the straight-line depreciation.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
DEPSYD(p,v,y)
Returns the sum-of-years-digits depreciation.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
DEPTAB(p,v,t1,...,tn)
Returns the depreciation from specified tables.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
DUR(y,f,c(1), ... ,c(k))
Returns the modified duration for an enumerated cash flow.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
DURP(A,c,n,K,k0 ,y)
Returns the modified duration for a periodic cash flow stream, such as a bond.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
EFFRATE(compounding-interval, rate)
Returns the effective annual interest rate.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
FINANCE(string-identifier, parm1, parm2,…)
Computes financial calculations such as depreciation, maturation, accrued interest, net present value, periodic savings, and internal rates of return.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
GARKHCLPRC(E, t, S, Rd , Rf , sigma)
Calculates call prices for European options on stocks, based on the Garman-Kohlhagen model.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
GARKHPTPRC(E, t, S, Rd , Rf , sigma)
Calculates put prices for European options on stocks, based on the Garman-Kohlhagen model.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
INTRR(freq,c0, c1,..., cn)
Returns the internal rate of return as a fraction.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
IPMT (rate, period, number-of-periods, principal-amount, < future-amount >, < type >)
Returns the interest payment for a given period for a constant payment loan or the periodic savings for a future balance.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
IRR(freq c0,c1,…,cn)
Returns the internal rate of return as a percentage.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
MARGRCLPRC(X1 , t, X2 , sigma1, sigma2, rho12)
Calculates call prices for European options on stocks, based on the Margrabe model.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
MARGRPTPRC(X1 , t, X2 , sigma1, sigma2, rho12)
Calculates put prices for European options on stocks, based on the Margrabe model.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
MORT(a,p,r,n)
Returns amortization parameters.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
NETPV(r,freq,c0,c1,...,cn)
Returns the net present value as a fraction.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
NOMRATE(compounding-interval, rate)
Returns the nominal annual interest rate.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
NPV(r,freq,c0,c1,...,cn)
Returns the net present value with the rate expressed as a percentage.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
PMT (rate, number-of-periods, principal-amount, < future-amount >, < type >)
Returns the periodic payment for a constant payment loan or the periodic savings for a future balance.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
PPMT (rate, period, number-of-periods, principal-amount, < future-amount >, < type >)
Returns the principal payment for a given period for a constant payment loan or the periodic savings for a future balance.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
PVP(A,c,n,K,k0 ,y)
Returns the present value for a periodic cash flow stream (such as a bond), with repayment of principal at maturity.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
SAVING(f,p,r,n)
Returns the future value of a periodic saving.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
SAVINGS(base-date, initial-deposit-date, deposit-amount, deposit-number,
deposit-interval, compounding-interval, date-1, rate-2 <,date-2, rate-2,...>)
Returns the balance of a periodic savings by using variable interest rates.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
TIMEVALUE(base-date, reference-date, reference-amount, compounding-interval,
date-1, rate-1 <,date-2, rate-2,...>)
Returns the equivalent of a reference amount at a base date by using variable interest rates.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
YIELDP(A,c,n,K,k0 ,p)
Returns the yield-to-maturity for a periodic cash flow stream, such as a bond.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference

Grid

G

Name
Syntax and Description
grdsvc_enable(identifier <,option-1; ... option-n > )
grdsvc_enable(identifier,"" | " )
Enables or disables one or all SAS sessions on a grid.
Product: SAS Grid Computing
Document: Grid Computing in SAS 9.3
grdsvc_getaddr(identifier)
Reports the IP address of the grid node on which the SAS session was chosen to execute.
Product: SAS Grid Computing
Document: Grid Computing in SAS 9.3
grdsvc_getinfo(identifier)
Reports information about the grid environment.
Product: SAS Grid Computing
Document: Grid Computing in SAS 9.3
grdsvc_getname(identifier)
Reports the name of the grid node on which the SAS grid server session was chosen to execute.
Product: SAS Grid Computing
Document: Grid Computing in SAS 9.3
grdsvc_nnodes(argument;option)
Reports the total number of job slots that are available for use on a grid.
Product: SAS Grid Computing
Document: Grid Computing in SAS 9.3

Hyperbolic

A C S T

Name
Syntax and Description
ARCOSH(x)
Returns the inverse hyperbolic cosine.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
ARSINH(x)
Returns the inverse hyperbolic sine.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
ARTANH(x)
Returns the inverse hyperbolic tangent.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
COSH(argument)
Returns the hyperbolic cosine.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
SINH(argument)
Returns the hyperbolic sine.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
TANH(argument)
Returns the hyperbolic tangent.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference

Locale

G S

Name
Syntax and Description
GETLOCENV( )
Returns the current locale/language environment.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
GETPXLANGUAGE()
Returns the current two-letter language code.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
GETPXLOCALE(<source>)
Returns the POSIX locale value for a SAS locale.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
GETPXREGION()
Returns the current two-letter region code.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
SASMSG (BASENAME", "KEY", <<"QUOTE"|"DQUOTE"|"NOQUOTE">
<, "substitution 1", ..., "substitution 7">>)
Specifies a message from a data set. The returned message is based on the current locale and a specified key.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
SASMSGL(("BASENAME", "KEY", "LOCALE", <<"Q"|"D"|"N">
<, "substitution 1", ..., "substitution 6">>)
Specifies a message from a data set. The message is based on a specified locale value and a specified key value.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
Setting SAS Locale
SETLOCALE(sas_locale)
Customize single locale elements
SETLOCALE(key, value)
Customize single locale elements
SETLOCALE(category_name, sas_locale)
Specifies the locale keys for the current SAS locale.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
sortKey(string, <locale, strength, case, numeric, order> )
creates a linguistic sort key.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide

Logging

L

Name
Syntax and Description
LOG4SAS_APPENDER("name", "FileRefAppender", 'options')
Creates a fileref appender that can be referenced by a logger.
Product: Base SAS
Document: SAS 9.3 Logging: Configuration and Programming Reference
Log4SAS_logevent(name, level, message)
Logs a message by using a specific logger.
Product: Base SAS
Document: SAS 9.3 Logging: Configuration and Programming Reference
LOG4SAS_LOGGER("name", <"options"> )
Creates a logger.
Product: Base SAS
Document: SAS 9.3 Logging: Configuration and Programming Reference

Macro

R S

Name
Syntax and Description
RESOLVE(argument)
Returns the resolved value of the argument after it has been processed by the macro facility.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
SYMEXIST (argument)
Returns an indication of the existence of a macro variable.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
SYMGET(argument)
Returns the value of a macro variable during DATA step execution.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
SYMGLOBL (argument)
Returns an indication of whether a macro variable is in global scope to the DATA step during DATA step execution.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
SYMLOCAL (argument)
Returns an indication of whether a macro variable is in local scope to the DATA step during DATA step execution.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference

Mathematical

A B C D E F G I J L M S T

Name
Syntax and Description
ABS (argument)
Returns the absolute value.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
AIRY(x)
Returns the value of the Airy function.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
BETA(a,b)
Returns the value of the beta function.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
CNONCT(x,df,prob)
Returns the noncentrality parameter from a chi-square distribution.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
COALESCE(argument-1<..., argument-n>)
Returns the first non-missing value from a list of numeric arguments.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
COMPFUZZ(value1, value2 <, fuzz <, scale > > )
Performs a fuzzy comparison of two numeric values.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
CONSTANT(constant <, parameter > )
Computes machine and mathematical constants.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
DAIRY(x)
Returns the derivative of the AIRY function.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
DEVIANCE(distribution, variable, shape-parameters <,ε > )
Returns the deviance based on a probability distribution.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
DIGAMMA(argument)
Returns the value of the digamma function.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
ERF(argument)
Returns the value of the (normal) error function.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
ERFC(argument)
Returns the value of the complementary (normal) error function.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
EXP(argument)
Returns the value of the exponential function.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
FACT(n)
Computes a factorial.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
FNONCT(x,ndf,ddf,prob)
Returns the value of the noncentrality parameter of an F distribution.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
GAMMA(argument)
Returns the value of the gamma function.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
GCD(x1, x2, x3, …, xn)
Returns the greatest common divisor for one or more integers.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
IBESSEL(nu,x,kode)
Returns the value of the modified Bessel function.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
JBESSEL(nu,x)
Returns the value of the Bessel function.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
LCM(x1,x2,x3, …, xn)
Returns the least common multiple.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
LGAMMA(argument)
Returns the natural logarithm of the Gamma function.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
LOG(argument)
Returns the natural (base e) logarithm.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
LOG10(argument)
Returns the logarithm to the base 10.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
LOG1PX(x)
Returns the log of 1 plus the argument.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
LOG2(argument)
Returns the logarithm to the base 2.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
LOGBETA(a,b)
Returns the logarithm of the beta function.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
MOD (argument-1,argument-2)
Returns the remainder from the division of the first argument by the second argument, fuzzed to avoid most unexpected floating-point results.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
MODZ (argument-1, argument-2)
Returns the remainder from the division of the first argument by the second argument, using zero fuzzing.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
MSPLINT(X, n, X1 <, X2 , …, Xn > , Y1 <,Y2 , …, Yn > <,D1 ,Dn > )
Returns the ordinate of a monotonicity-preserving interpolating spline.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
SIGN(argument)
Returns the sign of a value.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
SQRT(argument)
Returns the square root of a value.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
TNONCT(x,df,prob)
Returns the value of the noncentrality parameter from the Student's distribution.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
TRIGAMMA(argument)
Returns the value of the trigamma function.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference

Numeric

I M S

Name
Syntax and Description
IFN(logical-expression, value-returned-when-true, value-returned-when-false
<,value-returned-when-missing > )
Returns a numeric value based on whether an expression is true, false, or missing.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
MODEXIST ('product-name' | 'pathname')
Determines whether a product image exists in the release of SAS that you have installed.
Product: Base SAS
Document: SAS 9.3 Companion for UNIX Environments
MODEXIST('product-name')
Determines whether a software image exists in the version of SAS that you have installed.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
STPSRVGETN( valuecode )
Returns the numeric value of a server property
Product: SAS Integration Technologies
Document: SAS 9.3 Stored Processes: Developer's Guide

Probability

C L P S

Name
Syntax and Description
CDF (distribution,quantile <,parm-1, … ,parm-k > )
Returns a value from a cumulative probability distribution.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
LOGCDF('dist',quantile <,parm-1,...,parm-k > )
Returns the logarithm of a left cumulative distribution function.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
LOGPDF('dist',quantile,parm-1,...,parm-k)
Returns the logarithm of a probability density (mass) function.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
LOGSDF('dist',quantile,parm-1,...,parm-k)
Returns the logarithm of a survival function.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
PDF (dist,quantile <,parm-1, ... ,parm-k > )
Returns a value from a probability density (mass) distribution.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
POISSON(m,n)
Returns the probability from a Poisson distribution.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
PROBBETA(x,a,b)
Returns the probability from a beta distribution.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
PROBBNML(p,n,m)
Returns the probability from a binomial distribution.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
PROBBNRM(x,y,r)
Returns a probability from a bivariate normal distribution.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
PROBCHI(x,df <,nc > )
Returns the probability from a chi-square distribution.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
PROBF(x,ndf,ddf <,nc > )
Returns the probability from an distribution.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
PROBGAM(x,a)
Returns the probability from a gamma distribution.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
PROBHYPR(N,K,n,x <,r > )
Returns the probability from a hypergeometric distribution.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
PROBMC(distribution,q,prob,df,nparms <, parameters >)
Returns a probability or a quantile from various distributions for multiple comparisons of means.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
PROBNEGB(p,n,m)
Returns the probability from a negative binomial distribution.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
PROBNORM(x)
Returns the probability from the standard normal distribution.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
PROBT(x,df <,nc > )
Returns the probability from a distribution.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
SDF(dist,quantile,parm-1,...,parm-k)
Returns a survival function.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference

Quantile

B C F G P Q S T

Name
Syntax and Description
BETAINV (p,a,b)
Returns a quantile from the beta distribution.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
CINV (p,df <,nc > )
Returns a quantile from the chi-square distribution.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
FINV (p, ndf, ddf <,nc > )
Returns a quantile from the distribution.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
GAMINV(p,a)
Returns a quantile from the gamma distribution.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
PROBIT(p)
Returns a quantile from the standard normal distribution.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
QUANTILE(dist,probability,parm-1,…,parm-k)
Returns the quantile from a distribution when you specify the left probability (CDF).
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
SQUANTILE(dist, probability, parm-1, ... , parm-k)
Returns the quantile from a distribution when you specify the right probability (SDF).
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
TINV(p,df <,nc > )
Returns a quantile from the distribution.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference

Random Number

N R U

Name
Syntax and Description
Returns a random variate from a normal, or Gaussian, distribution.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
RANBIN(seed,n,p)
Returns a random variate from a binomial distribution.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
RANCAU(seed)
Returns a random variate from a Cauchy distribution.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
RAND (dist, parm-1,…,parm-k)
Generates random numbers from a distribution that you specify.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
RANEXP(seed)
Returns a random variate from an exponential distribution.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
RANGAM(seed,a)
Returns a random variate from a gamma distribution.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
RANNOR(seed)
Returns a random variate from a normal distribution.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
RANPOI(seed,m)
Returns a random variate from a Poisson distribution.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
RANTBL(seed,p1,... pi ... ,pn )
Returns a random variate from a tabled probability distribution.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
RANTRI(seed,h)
Returns a random variate from a triangular distribution.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
RANUNI(seed)
Returns a random variate from a uniform distribution.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
Returns a random variate from a uniform distribution.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference

SAS File I/O

A C D E F G I L N O P R S V

Name
Syntax and Description
ATTRC(data-set-id,attr-name)
Returns the value of a character attribute for a SAS data set.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
ATTRN(data-set-id,attr-name)
Returns the value of a numeric attribute for a SAS data set.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
CEXIST(entry <,'U'> )
Verifies the existence of a SAS catalog or SAS catalog entry.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
CLOSE(data-set-id)
Closes a SAS data set.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
CUROBS(data-set-id)
Returns the observation number of the current observation.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
DROPNOTE( data-set-id | file-id ,note-id)
Deletes a note marker from a SAS data set or an external file.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
DSNAME(data-set-id)
Returns the SAS data set name that is associated with a data set identifier.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
ENVLEN(argument)
Returns the length of an environment variable.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
EXIST(member-name <,member-type <, generation > > )
Verifies the existence of a SAS library member.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
FETCH(data-set-id <,'NOSET'> )
Reads the next non-deleted observation from a SAS data set into the Data Set Data Vector (DDV).
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
FETCHOBS(data-set-id,obs-number <,options > )
Reads a specified observation from a SAS data set into the Data Set Data Vector (DDV).
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
GETVARC(data-set-id,var-num)
Returns the value of a SAS data set character variable.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
GETVARN(data-set-id,var-num)
Returns the value of a SAS data set numeric variable.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
IORCMSG()
Returns a formatted error message for _IORC_.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
LIBNAME(libref<,SAS-data-library<,engine<,options>>>)
Assigns or clears a libref for a SAS library.
Product: Base SAS
Document: SAS 9.3 Companion for Windows
LIBNAME(libref <,SAS-library <,engine <,options > > > )
Assigns or deassigns a libref for a SAS library.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
LIBREF(libref)
Verifies that a libref has been assigned.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
NOTE(data-set-id)
Returns an observation ID for the current observation of a SAS data set.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
OPEN(< data-set-name <,mode <,generation-number <,type > > > > )
Opens a SAS data set.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
PATHNAME((fileref | libref) < ,search-ref > )
Returns the physical name of a SAS library or an external file, or returns a blank.
Product: Base SAS
Document: SAS 9.3 Companion for UNIX Environments
PATHNAME(( fileref | libref ) <,search-level > )
Returns the physical name of a SAS library or of an external file or returns a blank.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
PATHNAME((fileref | libref) <,search-ref > )
Returns the physical name of an external file or a SAS library, or returns a blank.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
POINT(data-set-id,note-id)
Locates an observation that is identified by the NOTE function.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
RENAME(old-name, new-name <, type <, description <, password <, generation > > > > )
Renames a member of a SAS library, an entry in a SAS catalog, an external file, or a directory.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
REWIND(data-set-id)
Positions the data set pointer at the beginning of a SAS data set.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
SYSEXIST (argument)
Returns a value that indicates whether an operating-environment variable exists in your environment.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
SYSMSG()
Returns error or warning message text from processing the last data set or external file function.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
SYSRC()
Returns a system error number.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
VARFMT(data-set-id,var-num)
Returns the format that is assigned to a SAS data set variable.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
VARINFMT(data-set-id,var-num)
Returns the informat that is assigned to a SAS data set variable.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
VARLABEL(data-set-id,var-num)
Returns the label that is assigned to a SAS data set variable.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
VARLEN(data-set-id,var-num)
Returns the length of a SAS data set variable.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
VARNAME(data-set-id,var-num)
Returns the name of a SAS data set variable.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
VARNUM(data-set-id,var-name)
Returns the number of a variable's position in a SAS data set.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
VARTYPE(data-set-id,var-num)
Returns the data type of a SAS data set variable.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference

Search

W

Name
Syntax and Description
WHICHC(string, value-1 <, value-2, …> )
Searches for a character value that is equal to the first argument, and returns the index of the first matching value.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
WHICHN(argument, value-1 <, value-2, …> )
Searches for a numeric value that is equal to the first argument, and returns the index of the first matching value.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference

Special

A C D G I L M P S U W

Name
Syntax and Description
ADDR(variable)
Returns the memory address of a variable on a 32-bit platform.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
ADDRLONG(variable)
Returns the memory address of a variable on 32-bit and 64-bit platforms.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
CALL SOUND(frequency,duration);
Generates a sound with a specific frequency and duration.
Product: Base SAS
Document: SAS 9.3 Companion for Windows
CALL SYSTEM(command);
Submits an operating system command or a Windows application for execution.
Product: Base SAS
Document: SAS 9.3 Companion for Windows
DIF < n > (argument)
Returns differences between an argument and its th lag.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
GETOPTION(option-name <, return-value-option > < return-value-formatting-options >)
Returns the value of a SAS system or graphics option.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
GETOPTION(option-name <, return-value-option > < return-value-formatting-options >)
Returns the value of a SAS system or graphics option.
Product: Base SAS
Document: SAS 9.3 System Options: Reference
INPUT(source,< ? | ?? >,informat.)
Returns the value that is produced when SAS converts an expression using the specified informat.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
INPUTC(source, informat <,w > )
Enables you to specify a character informat at run time.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
INPUTN(source, informat <,w <,d > > )
Enables you to specify a numeric informat at run time.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
LAG < n > (argument)
Returns values from a queue.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
MCIPISLP(number-of-seconds)
Causes SAS to wait for a piece of multimedia equipment to become active.
Product: Base SAS
Document: SAS 9.3 Companion for Windows
MCIPISTR(MCI-string-command)
Submits an MCI string command to a piece of multimedia equipment.
Product: Base SAS
Document: SAS 9.3 Companion for Windows
PEEK(address <,length > )
Stores the contents of a memory address in a numeric variable on a 32-bit platform.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
PEEKC(address <,length > )
Stores the contents of a memory address in a character variable on a 32-bit platform.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
PEEKCLONG(address <,length > )
Stores the contents of a memory address in a character variable.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
PEEKCLONG(address <,length > )
Stores the contents of a memory address in a character variable on 32-bit and 64-bit platforms.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
PEEKCLONG(address,length);
PEEKLONG(address,length);
Stores the contents of a memory address in a numeric variable on 32-bit and 64-bit platforms.
Product: Base SAS
Document: SAS 9.3 Companion for UNIX Environments
PEEKLONG(address <,length)>
Stores the contents of a memory address in a numeric variable on 32-bit and 64-bit platforms.
Product: Base SAS
Document: SAS 9.3 Companion for Windows
PEEKLONG(address <,length > )
Stores the contents of a memory address in a numeric variable.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
PEEKLONG(address <,length > )
Stores the contents of a memory address in a numeric variable on 32-bit and 64-bit platforms.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
PTRLONGADD(pointer <,amount > )
Returns the pointer address as a character variable on 32-bit and 64-bit platforms.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
PUT(source, format.)
Returns a value using a specified format.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
PUTC(source, format.<,w > )
Enables you to specify a character format at run time.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
PUTN(source, format.<,w <,d > > )
Enables you to specify a numeric format at run time.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
SLEEP(n<,unit>)
Suspends execution of a SAS DATA step for a specified period of time.
Product: Base SAS
Document: SAS 9.3 Companion for Windows
SLEEP(n <, unit > )
For a specified period of time, suspends the execution of a program that invokes this function.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
SYSEXIST (argument)
Returns a value that indicates whether an operating-environment variable exists in your environment.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
SYSGET('environment-variable')
Returns the value of the specified operating environment variable.
Product: Base SAS
Document: SAS 9.3 Companion for UNIX Environments
SYSGET(operating-environment-variable)
Returns the value of the specified operating-environment variable.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
SYSGET(operating-environment-variable)
Returns the value of the specified operating environment variable.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
SYSPARM()
Returns the system parameter string.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
SYSPROCESSID()
Returns the process ID of the current process.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
SYSPROCESSNAME(< process_id > )
Returns the process name that is associated with a given process ID, or returns the name of the current process.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
SYSPROD(product-name)
Determines whether a product is licensed.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
SYSTEM(command)
Issues an operating environment command during a SAS session and returns the system return code.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
SYSTEM(command)
Issues an operating environment command during a SAS session, and returns the system return code.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
UUIDGEN(< max-warnings <,binary-result > > )
Returns the short or binary form of a Universal Unique Identifier (UUID).
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
WAKEUP(until-when)
Specifies the time a SAS DATA step continues execution.
Product: Base SAS
Document: SAS 9.3 Companion for Windows

State and ZIP Code

F S Z

Name
Syntax and Description
FIPNAME(expression)
Converts two-digit FIPS codes to uppercase state names.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
FIPNAMEL(expression)
Converts two-digit FIPS codes to mixed case state names.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
FIPSTATE(expression)
Converts two-digit FIPS codes to two-character state postal codes.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
STFIPS(postal-code)
Converts state postal codes to FIPS state codes.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
STNAME(postal-code)
Converts state postal codes to uppercase state names.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
STNAMEL(postal-code)
Converts state postal codes to mixed case state names.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
ZIPCITY(zip-code)
Returns a city name and the two-character postal code that corresponds to a ZIP code.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
ZIPCITYDISTANCE(zip-code-1, zip-code-2)
Returns the geodetic distance between two ZIP code locations.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
ZIPFIPS(zip-code)
Converts ZIP codes to two-digit FIPS codes.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
ZIPNAME(zip-code)
Converts ZIP codes to uppercase state names.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
ZIPNAMEL(zip-code)
Converts zip codes to mixed case state names.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
ZIPSTATE(zip-code)
Converts ZIP codes to two-character state postal codes.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference

Trigonometric

A C S T

Name
Syntax and Description
ARCOS (argument)
Returns the arccosine.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
ARSIN (argument)
Returns the arcsine.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
ATAN (argument)
Returns the arc tangent.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
ATAN2(argument-1, argument-2)
Returns the arc tangent of the ratio of two numeric variables.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
COS (argument)
Returns the cosine.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
SIN(argument)
Returns the sine.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
TAN(argument)
Returns the tangent.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference

Truncation

C F I R T

Name
Syntax and Description
CEIL (argument)
Returns the smallest integer that is greater than or equal to the argument, fuzzed to avoid unexpected floating-point results.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
CEILZ (argument)
Returns the smallest integer that is greater than or equal to the argument, using zero fuzzing.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
FLOOR (argument)
Returns the largest integer that is less than or equal to the argument, fuzzed to avoid unexpected floating-point results.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
FLOORZ (argument)
Returns the largest integer that is less than or equal to the argument, using zero fuzzing.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
FUZZ(argument)
Returns the nearest integer if the argument is within 1E−12 of that integer.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
INT(argument)
Returns the integer value, fuzzed to avoid unexpected floating-point results.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
INTZ (argument)
Returns the integer portion of the argument, using zero fuzzing.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
ROUND (argument <,rounding-unit > )
Rounds the first argument to the nearest multiple of the second argument, or to the nearest integer when the second argument is omitted.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
ROUNDE (argument <,rounding-unit > )
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.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
ROUNDZ (argument <,rounding-unit > )
Rounds the first argument to the nearest multiple of the second argument, using zero fuzzing.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
TRUNC(number,length)
Truncates a numeric value to a specified number of bytes.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference

Variable Information

V

Name
Syntax and Description
VARRAY (name)
Returns a value that indicates whether the specified name is an array.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
VARRAYX (expression)
Returns a value that indicates whether the value of the specified argument is an array.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
VARTRANSCODE(data-set-id, var-num)
Returns the transcode attribute of a SAS data set variable.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
VFORMAT (var)
Returns the format that is associated with the specified variable.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
VFORMATD (var)
Returns the decimal value of the format that is associated with the specified variable.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
VFORMATDX (expression)
Returns the decimal value of the format that is associated with the value of the specified argument.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
VFORMATN (var)
Returns the format name that is associated with the specified variable.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
VFORMATNX (expression)
Returns the format name that is associated with the value of the specified argument.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
VFORMATW (var)
Returns the format width that is associated with the specified variable.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
VFORMATWX (expression)
Returns the format width that is associated with the value of the specified argument.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
VFORMATX (expression)
Returns the format that is associated with the value of the specified argument.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
VINARRAY (var)
Returns a value that indicates whether the specified variable is a member of an array.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
VINARRAYX (expression)
Returns a value that indicates whether the value of the specified argument is a member of an array.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
VINFORMAT (var)
Returns the informat that is associated with the specified variable.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
VINFORMATD (var)
Returns the decimal value of the informat that is associated with the specified variable.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
VINFORMATDX (expression)
Returns the decimal value of the informat that is associated with the value of the specified variable.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
VINFORMATN (var)
Returns the informat name that is associated with the specified variable.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
VINFORMATNX (expression)
Returns the informat name that is associated with the value of the specified argument.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
VINFORMATW (var)
Returns the informat width that is associated with the specified variable.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
VINFORMATWX (expression)
Returns the informat width that is associated with the value of the specified argument.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
VINFORMATX (expression)
Returns the informat that is associated with the value of the specified argument.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
VLABEL (var)
Returns the label that is associated with the specified variable.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
VLABELX (expression)
Returns the label that is associated with the value of the specified argument.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
VLENGTH (var)
Returns the compile-time (allocated) size of the specified variable.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
VLENGTHX (expression)
Returns the compile-time (allocated) size for the variable that has a name that is the same as the value of the argument.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
VNAME (var)
Returns the name of the specified variable.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
VNAMEX (expression)
Validates the value of the specified argument as a variable name.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
VTRANSCODE (var)
Returns a value that indicates whether transcoding is enabled for the specified character variable.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
VTRANSCODEX (var)
Returns a value that indicates whether transcoding is enabled for the specified argument.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
VTYPE (var)
Returns the type (character or numeric) of the specified variable.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
VTYPEX (expression)
Returns the type (character or numeric) for the value of the specified argument.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
VVALUE(var)
Returns the formatted value that is associated with the variable that you specify.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
VVALUEX(expression)
Returns the formatted value that is associated with the argument that you specify.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference

Web Service

S

Name
Syntax and Description
SOAPWEB (IN, URL <,options >)
Calls a Web service by using basic Web authentication; credentials are provided in the arguments.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
SOAPWEBMETA (IN, URL <,options >)
Calls a Web service by using basic Web authentication; credentials for the authentication domain are retrieved from metadata.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
SOAPWIPSERVICE (IN, SERVICE <,options >)
Calls a SAS registered Web service by using WS-Security authentication; credentials are provided in the arguments.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
SOAPWIPSRS (IN, URL, SRSURL <,options >)
Calls a SAS registered Web service by using WS-Security authentication; credentials are provided in the arguments.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
SOAPWS (IN, URL <,options >)
Calls a Web service by using WS-Security authentication; credentials are provided in the arguments.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
SOAPWSMETA (IN, URL <,options >)
Calls a Web service by using WS-Security authentication; credentials for the provided authentication domain are retrieved from metadata.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference

Web Tools

H U

Name
Syntax and Description
HTMLDECODE(expression)
Decodes a string that contains HTML numeric character references or HTML character entity references, and returns the decoded string.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
HTMLENCODE(expression, < options >)
Encodes characters using HTML character entity references, and returns the encoded string.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
URLDECODE(argument)
Returns a string that was decoded using the URL escape syntax.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference
URLENCODE(argument)
Returns a string that was encoded using the URL escape syntax.
Product: Base SAS
Document: SAS 9.3 Functions and CALL Routines: Reference