SAS(R) 9.2 Language Reference by Name, Product, and Category
Functions Syntax Sorted by Category
Array
|
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 Language Reference: Dictionary
|
|
|
HBOUND
<
n
>
(array-name)
HBOUND(array-name,bound-n)
Returns the upper bound of an array.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
LBOUND
<
n
>
(array-name)
LBOUND(array-name,bound-n)
Returns the lower bound of an array.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
Bitwise Logical Operations
|
Name
|
Syntax and Description
|
|---|---|
|
band(argument-1,argument-2)
Returns the bitwise logical AND of two arguments.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
BLSHIFT(argument-1,argument-2)
Returns the bitwise logical left shift of two arguments.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
BNOT(argument)
Returns the bitwise logical NOT of an argument.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
BOR(argument-1,argument-2)
Returns the bitwise logical OR of two arguments.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
BRSHIFT(argument-1, argument-2)
Returns the bitwise logical right shift of two arguments.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
BXOR(argument-1, argument-2)
Returns the bitwise logical EXCLUSIVE OR of two arguments.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
Character
|
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 Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
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 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 Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
BYTE(n)
Returns one character in the ASCII collating sequence.
Product: Base SAS
Document: SAS Companion for the UNIX Environments
|
|
|
BYTE(n)
Returns one character in the ASCII collating sequence.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
|
|
|
BYTE(n)
Returns one character in the ASCII collating sequence.
Product: Base SAS
Document: SAS Companion for Windows
|
|
|
BYTE (n)
Returns one character in the ASCII or the EBCDIC collating sequence.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
CAT(item-1
<, …, item-n
>
)
Does not remove leading or trailing blanks, and returns a concatenated
character string.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
CATS(item-1
<, …, item-n
>
)
Removes leading and trailing blanks, and returns a concatenated
character string.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
CATT(item-1
<, … item-n
>
)
Removes trailing blanks, and returns a concatenated character
string.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
CATX(delimiter, item-1
<, … item-n
>
)
Removes leading and trailing blanks, inserts delimiters, and returns
a concatenated character string.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
CHAR(string, position)
Returns a single character from a specified position in a character
string.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
COALESCEC(argument-1
<
..., argument-n
>
)
Returns the first non-missing value from a list of character arguments.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
COLLATE(start-position
<,end-position
>
) | (start-position
<,,length
>
)
Returns a character string in an ASCII collating sequence.
Product: Base SAS
Document: SAS Companion for the UNIX Environments
|
|
|
COLLATE(start-position
<
,end-position
>
) | (start-position
<
,,length
>
)
Returns an ASCII collating sequence character string.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
|
|
|
COLLATE (start-position
< ,end-position
>
)|(start-position
<,,length
>
)
Returns an ASCII collating sequence character string.
Product: Base SAS
Document: SAS 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 Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
COMPBL(source)
Removes multiple blanks from a character string.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
COMPGED(string-1, string-2
<,cutoff
>
<,modifiers
>
)
Returns the generalized edit distance between two strings.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
COMPLEV(string-1, string-2
<,cutoff
>
<,modifiers
>
)
Returns the Levenshtein edit distance between two strings.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
COMPRESS(<
source
>
<, chars
>
<, modifiers
>
)
Returns a character string with specified characters removed from
the original string.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
COUNT(string, substring
<
,modifiers
>
)
Counts the number of times that a specified substring appears
within a character string.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
COUNTW(<
string
>
<, chars
>
<, modifiers
>
)
Counts the number of words in a character string.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
FIRST(string)
Returns the first character in a character string.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
KCVT(text, intype, outtype, <
options,…>
)
Converts data from one type of encoding data to another encoding
data.
Product: Base SAS
Document: SAS National Language Support: Reference Guide
|
|
|
LEFT(argument)
Left-aligns a character string.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
LENGTHC(string)
Returns the length of a character string, including trailing blanks.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
LENGTHM(string)
Returns the amount of memory (in bytes) that is allocated for
a character string.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
LENGTHN(string)
Returns the length of a character string, excluding trailing blanks.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
LOWCASE(argument)
Converts all letters in an argument to lowercase.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
MD5(string)
Returns the result of the message digest of a specified string.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
MISSING(numeric-expression | character-expression)
Returns a numeric result that indicates whether the argument contains
a missing value.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
NLITERAL(string)
Converts a character string that you specify to a SAS name literal.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
NOTALNUM(string
<,start
>
)
Searches a character string for a non-alphanumeric character,
and returns the first position at which the character is found.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
NVALID(string
<
,validvarname
>
)
Checks the validity of a character string for use as a SAS variable
name.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
PROPCASE(argument
<,delimiters
>
)
Converts all words in an argument to proper case.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
QUOTE(argument)
Adds double quotation marks to a character value.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
RANK(x)
Returns the position of a character in the ASCII collating sequence.
Product: Base SAS
Document: SAS Companion for Windows
|
|
|
RANK(x)
Returns the position of a character in the ASCII collating sequence.
Product: Base SAS
Document: SAS Companion for the UNIX Environments
|
|
|
RANK(x)
Returns the position of a character in the ASCII collating sequence.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
|
|
|
RANK(x)
Returns the position of a character in the ASCII or EBCDIC collating
sequence.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
REPEAT(argument,n)
Returns a character value that consists of the first argument
repeated n+1 times.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
REVERSE(argument)
Reverses a character string.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
RIGHT(argument)
Right aligns a character expression.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
SCAN(string, count
<,charlist
<,modifiers
>
>
)
Returns the nth word from a character string.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
SOUNDEX(argument)
Encodes a string to facilitate searching.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
STRIP(string)
Returns a character string with all leading and trailing blanks
removed.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
SUBPAD(string, position
<, length
>
)
Returns a substring that has a length you specify, using blank
padding if necessary.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
SUBSTR(variable, position
<,length
>
)=characters-to-replace
Replaces character value contents.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
<
variable=>
SUBSTR(string, position
<,length
>
)
Extracts a substring from an argument.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
SUBSTRN(string, position
<, length
>
)
Returns a substring, allowing a result with a length of zero.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
TRANSLATE(source,to-1,from-1
<,…to-n,
from-n
>
)
Replaces specific characters in a character expression.
Product: Base SAS
Document: SAS 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 Companion for z/OS
|
|
|
TRANSLATE(source,to-1,from-1
<,…to-n,from-n
>
)
Replaces specific characters in a character expression.
Product: Base SAS
Document: SAS Companion for the UNIX Environments
|
|
|
TRANSLATE(source,to-1,from-1
<,…to-n,from-n
>
)
Replaces specific characters in a character expression.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
|
|
|
TRANSLATE(source,to-1,from-1
<,…to-n,from-n
>
)
Replaces specific characters in a character string.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
TRANSTRN(source,target,replacement)
Replaces or removes all occurrences of a substring in a character
string.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
TRANTAB(string,trantab_name)
Transcodes data by using the specified translation table.
Product: Base SAS
Document: SAS National Language Support: Reference Guide
|
|
|
TRANWRD(source,target,replacement)
Replaces all occurrences of a substring in a character string.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
TRIM(argument)
Removes trailing blanks from a character string, and returns one
blank if the string is missing.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
STR=UNICODE(<
instr
>
(,<Unicode type>
))
converts Unicode characters to the current SAS session encoding.
Product: Base SAS
Document: SAS National Language Support: Reference Guide
|
|
|
STR=UNICODEC(<
instr
>
(,<Unicode type>
))
converts characters in the current SAS session encoding to Unicode
characters.
Product: Base SAS
Document: SAS National Language Support: Reference Guide
|
|
|
UNICODELEN()
specifies the length of the character unit for the Unicode data.
Product: Base SAS
Document: SAS National Language Support: Reference Guide
|
|
|
UNICODEWIDTH()
specifies the length of a display unit for the Unicode data.
Product: Base SAS
Document: SAS National Language Support: Reference Guide
|
|
|
UPCASE(argument)
Converts all letters in an argument to uppercase.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
Character String Matching
|
Name
|
Syntax and Description
|
|---|---|
|
PRXCHANGE(perl-regular-expression | regular-expression-id, times, source)
Performs a pattern-matching replacement.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
PRXPAREN (regular-expression-id)
Returns the last bracket match for which there is a match in a
pattern.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
PRXPOSN(regular-expression-id, capture-buffer, source)
Returns a character string that contains the value for a capture
buffer.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
Character-String Translation
|
Name
|
Syntax and Description
|
|---|---|
|
ASCEBC (in-string)
Converts an input character string from ASCII to EBCDIC.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
|
|
|
EBCASC(in-string)
Converts an input character string from EBCDIC to ASCII.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
|
Combinatorial
|
Name
|
Syntax and Description
|
|---|---|
|
ALLCOMB(count, k, variable-1, … ,
variable-n)
Generates all combinations of the values of n variables
taken k at a time in a minimal change order.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
COMB(n, r)
Computes the number of combinations of n elements
taken r at a time.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
GRAYCODE(k, numeric-variable-1, ..., numeric-variable-n)
GRAYCODE(k, character-variable
<, n
<, in-out
>
>
)
Generates all subsets of n items in a minimal change
order.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
LCOMB(n,r)
Computes the logarithm of the COMB function; that is, the logarithm
of the number of combinations of n objects taken r
at a time.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
LEXCOMB(count, k, variable-1, …, variable-n)
Generates all distinct combinations of the non-missing values
of n variables taken k at a time in lexicographic
order.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
LEXCOMBI(n, k, index-1, …,
k)
Generates all combinations of the indices of n objects
taken k at a time in lexicographic order.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
LEXPERK(count, k, variable-1, …, variable-n)
Generates all distinct permutations of the non-missing values
of n variables taken k at a time in lexicographic
order.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
LFACT(n)
Computes the logarithm of the FACT (factorial) function.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
LPERM(n
<,r
>
)
Computes the logarithm of the PERM function; that is, the logarithm
of the number of permutations of n objects, with the option of
including r number of elements.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
PERM(n
<,r
>
)
Computes the number of permutations of n items that
are taken r at a time.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
DBCS
|
Name
|
Syntax and Description
|
|---|---|
|
KCOMPARE(source,<
pos, <
count,>
>
findstr)
Returns the result of a comparison of character expressions.
Product: Base SAS
Document: SAS National Language Support: Reference Guide
|
|
|
KCOMPRESS(source,<
characters-to-remove
>
)
Removes specified characters from a character expression.
Product: Base SAS
Document: SAS National Language Support: Reference Guide
|
|
|
KCOUNT(source)
Returns the number of double-byte characters in an expression.
Product: Base SAS
Document: SAS National Language Support: Reference Guide
|
|
|
KINDEX(source, excerpt)
Searches a character expression for a string of characters.
Product: Base SAS
Document: SAS National Language Support: Reference Guide
|
|
|
KINDEXC(source,excerpt-1
<,… excerpt-n
>
)
Searches a character expression for specified characters.
Product: Base SAS
Document: SAS National Language Support: Reference Guide
|
|
|
KLEFT(argument)
Left-aligns a character expression by removing unnecessary leading
DBCS blanks and SO/SI.
Product: Base SAS
Document: SAS National Language Support: Reference Guide
|
|
|
KLENGTH(argument)
Returns the length of an argument.
Product: Base SAS
Document: SAS National Language Support: Reference Guide
|
|
|
KLOWCASE(argument)
Converts all letters in an argument to lowercase.
Product: Base SAS
Document: SAS National Language Support: Reference Guide
|
|
|
str=KPROPCASE(<
instr
>
,
(<options>
))
Converts Chinese, Japanese, Korean, Taiwanese (CJKT) characters.
Product: Base SAS
Document: SAS National Language Support: Reference Guide
|
|
|
str=KPROPCHAR(<
instr
>
)
Converts special characters to normal characters.
Product: Base SAS
Document: SAS National Language Support: Reference Guide
|
|
|
str=KPROPDATA(<
instr
>
(<option, input encode name, output encode name>
))
Removes or converts unprintable characters.
Product: Base SAS
Document: SAS National Language Support: Reference Guide
|
|
|
KREVERSE(argument)
Reverses a character expression.
Product: Base SAS
Document: SAS National Language Support: Reference Guide
|
|
|
KRIGHT(argument)
Right-aligns a character expression by trimming trailing DBCS
blanks and SO/SI.
Product: Base SAS
Document: SAS National Language Support: Reference Guide
|
|
|
KSCAN(argument,n
<, delimiters
>
)
Selects a specified word from a character expression.
Product: Base SAS
Document: SAS National Language Support: Reference Guide
|
|
|
KSTRCAT(argument-1, argument-2
<, … argument-n
>
)
Concatenates two or more character expressions.
Product: Base SAS
Document: SAS National Language Support: Reference Guide
|
|
|
KSUBSTR(argument,position
<,n
>
)
Extracts a substring from an argument.
Product: Base SAS
Document: SAS National Language Support: 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 National Language Support: Reference Guide
|
|
|
KTRANSLATE(source, to-1, from-1<...to-n, from-n>)
Replaces specific characters in a character expression.
Product: Base SAS
Document: SAS 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 National Language Support: Reference Guide
|
|
|
KTRIM(argument)
Removes trailing DBCS blanks and SO/SI from character expressions.
Product: Base SAS
Document: SAS National Language Support: Reference Guide
|
|
|
KTRUNCATE(argument, number, length)
Truncates a numeric value to a specified length.
Product: Base SAS
Document: SAS National Language Support: Reference Guide
|
|
|
KUPCASE(argument)
Converts all letters in an argument to uppercase.
Product: Base SAS
Document: SAS National Language Support: 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 National Language Support: 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 National Language Support: 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 National Language Support: Reference Guide
|
Date and Time
|
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 Language Reference: Dictionary
|
|
|
DATE()
Returns the current date as a SAS date value.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
DATEJUL(julian-date)
Converts a Julian date to a SAS date value.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
DATEPART(datetime)
Extracts the date from a SAS datetime value.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
DATETIME()
Returns the current date and time of day as a SAS datetime value.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
DAY(date)
Returns the day of the month from a SAS date value.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
DHMS(date,hour,minute,second)
Returns a SAS datetime value from date, hour, minute, and second
values.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
HMS(hour,minute,second)
Returns a SAS time value from hour, minute, and second values.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
HOLIDAY('holiday', year)
Returns a SAS date value of a specified holiday for a specified
year.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
HOUR(<
time | datetime
>
)
Returns the hour from a SAS time or datetime value.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
INTCK(interval
<
multiple
>
<
.shift-index
>
, start-from, increment, <'alignment'>
)
INTCK(custom-interval, start-from, increment, <'alignment'>
)
Returns the count of the number of interval boundaries between
two dates, two times, or two datetime values.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
INTCYCLE(interval
<
<
multiple.<
shift-index
>
>
>
)
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 Language Reference: Dictionary
|
|
|
INTFIT(argument-1, argument-2, 'type')
Returns a time interval that is aligned between two dates.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
INTGET(date-1, date-2, date-3)
Returns a time interval based on three date or datetime values.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
INTINDEX(interval
<
<
multiple.<
shift-index
>
>
>
, date-value)
Returns the seasonal index when a date, time, or datetime interval
and value are specified.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
INTSEAS(interval
<
<
multiple.<
shift-index
>
>
>
)
Returns the length of the seasonal cycle when a date, time, or
datetime interval is specified.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
INTSHIFT(interval
<
<
multiple.<
shift-index
>
>
>
)
Returns the shift interval that corresponds to the base interval.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
JULDATE(date)
Returns the Julian date from a SAS date value.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
JULDATE7(date)
Returns a seven-digit Julian date from a SAS date value.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
MDY(month,day,year)
Returns a SAS date value from month, day, and year values.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
MINUTE(time | datetime)
Returns the minute from a SAS time or datetime value.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
MONTH(date)
Returns the month from a SAS date value.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
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 National Language Support: 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 National Language Support: 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 National Language Support: Reference Guide
|
|
|
NWKDOM(n, weekday, month, year)
Returns the date for the nth occurrence of a weekday
for the specified month and year.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
QTR(date)
Returns the quarter of the year from a SAS date value.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
SECOND(time | datetime)
Returns the second from a SAS time or datetime value.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
TIME()
Returns the current time of day as a numeric SAS time value.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
TIMEPART(datetime)
Extracts a time value from a SAS datetime value.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
TODAY()
Returns the current date as a numeric SAS date value.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
WEEK(<
sas-date
>
, <
'descriptor'
>
)
Returns the week-number value.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
WEEKDAY(date)
From a SAS date value, returns an integer that corresponds to
the day of the week.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
YEAR(date)
Returns the year from a SAS date value.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
YRDIF(sdate,edate,basis)
Returns the difference in years between two dates.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
YYQ(year,quarter)
Returns a SAS date value from year and quarter year values.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
Descriptive Statistics
|
Name
|
Syntax and Description
|
|---|---|
|
CMISS(argument-1
<, argument-2,…>
)
Counts the number of missing arguments.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
CSS(argument-1
<,...argument-n
>
)
Returns the corrected sum of squares.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
CV(argument-1,argument-2
<,...argument-n
>
)
Returns the coefficient of variation.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
EUCLID(value-1
<,value-2 ...
>
)
Returns the Euclidean norm of the non-missing arguments.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
GEOMEAN(argument
<,argument,…>
)
Returns the geometric mean.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
GEOMEANZ(argument
<,argument,…>
)
Returns the geometric mean, using zero fuzzing.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
HARMEAN(argument
<,argument,…>
)
Returns the harmonic mean.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
HARMEANZ(argument
<,argument,…>
)
Returns the harmonic mean, using zero fuzzing.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
IQR(value-1
<, value-2...
>
)
Returns the interquartile range.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
KURTOSIS(argument-1,argument-2,argument-3,argument-4
<,…,argument-n
>
)
Returns the kurtosis.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
LARGEST (k, value-1
<, value-2 ...>
)
Returns the kth largest non-missing value.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
LPNORM(p, value-1
<,value-2 …
>
)
Returns the Lp norm of the second argument and subsequent
non-missing arguments.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
MAD(value-1
<, value-2...
>
)
Returns the median absolute deviation from the median.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
MAX(argument-1,argument-2
<,...argument-n
>
)
Returns the largest value.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
MEAN(argument-1
<,...argument-n
>
)
Returns the arithmetic mean (average).
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
MEDIAN(value1
<, value2, ...
>
)
Returns the median value.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
MIN(argument-1,argument-2
<,...argument-n
>
)
Returns the smallest value.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
MISSING(numeric-expression | character-expression)
Returns a numeric result that indicates whether the argument contains
a missing value.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
N(argument-1
<,...argument-n
>
)
Returns the number of non-missing numeric values.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
NMISS(argument-1
<,...argument-n
>
)
Returns the number of missing numeric values.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
ORDINAL(k,argument-1,argument-2
<,...argument-n
>
)
Returns the kth smallest of the missing and nonmissing
values.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
PCTL
<
n
>
(percentage, value1
<, value2, ...
>
)
Returns the percentile that corresponds to the percentage.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
RANGE(argument-1
<,...argument-n
>
)
Returns the range of the nonmissing values.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
RMS(argument
<,argument,…>
)
Returns the root mean square of the nonmissing arguments.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
SKEWNESS(argument-1,argument-2,argument-3
<,...argument-n
>
)
Returns the skewness of the nonmissing arguments.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
SMALLEST (k, value-1
<, value-2 ...>
)
Returns the kth smallest nonmissing value.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
STD(argument-1,argument-2
<,...argument-n
>
)
Returns the standard deviation of the nonmissing arguments.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
STDERR(argument-1,argument-2
<,...argument-n
>
)
Returns the standard error of the mean of the nonmissing arguments.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
SUM(argument,
argument,
...)
Returns the sum of the nonmissing arguments.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
SUMABS(value-1
<,value-2 ...
>
)
Returns the sum of the absolute values of the non-missing arguments.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
USS(argument-1
<,...argument-n
>
)
Returns the uncorrected sum of squares of the nonmissing arguments.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
VAR(argument-1,argument-2
<,...argument-n
>
)
Returns the variance of the nonmissing arguments.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
Distance
|
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 Language Reference: Dictionary
|
|
|
ZIPCITYDISTANCE(zip-code-1, zip-code-2)
Returns the geodetic distance between two zip code locations.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
External Files
|
Name
|
Syntax and Description
|
|---|---|
|
DCLOSE(directory-id)
Closes a directory that was opened by the DOPEN function.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
DCREATE(directory-name
<,parent-directory
>
)
Returns the complete pathname of a new, external directory.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
DINFO(directory-id, info-item)
Returns information about a directory.
Product: Base SAS
Document: SAS Companion for z/OS
|
|
|
DINFO(directory-id, info-item)
Returns information about a directory.
Product: Base SAS
Document: SAS Companion for the UNIX Environments
|
|
|
DINFO(directory-id,info-item)
Returns information about a directory.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
|
|
|
DINFO(directory-id, info-item)
Returns information about a directory.
Product: Base SAS
Document: SAS Companion for Windows
|
|
|
DINFO(directory-id,info-item)
Returns information about a directory.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
DNUM(directory-id)
Returns the number of members in a directory.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
DOPEN(fileref)
Opens a directory and returns a directory identifier value.
Product: Base SAS
Document: SAS Companion for z/OS
|
|
|
DOPEN(fileref)
Opens a directory, and returns a directory identifier value.
Product: Base SAS
Document: SAS Companion for the UNIX Environments
|
|
|
DOPEN('fileref')
Opens a directory and returns a directory identifier value.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
|
|
|
DOPEN(“fileref”)
Opens a directory and returns a directory identifier value.
Product: Base SAS
Document: SAS Companion for Windows
|
|
|
DOPEN(fileref)
Opens a directory, and returns a directory identifier value.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
DOPTNAME(directory-id,nval)
Returns the name of a directory information item.
Product: Base SAS
Document: SAS Companion for z/OS
|
|
|
DOPTNAME(directory-id, nval)
Returns directory attribute information.
Product: Base SAS
Document: SAS Companion for the UNIX Environments
|
|
|
DOPTNAME(directory-id,nval)
Returns the name of a directory information item.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
|
|
|
DOPTNAME(directory-id, nval
)
Returns the name of a directory information item.
Product: Base SAS
Document: SAS Companion for Windows
|
|
|
DOPTNAME(directory-id,nval)
Returns directory attribute information.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
DOPTNUM(directory-id)
Returns the number of information items that are available for
a directory.
Product: Base SAS
Document: SAS Companion for z/OS
|
|
|
DOPTNUM(directory-id)
Returns the number of information items that are available for
a directory.
Product: Base SAS
Document: SAS Companion for the UNIX Environments
|
|
|
DOPTNUM(directory-id)
Returns the number of information items that are available for
a directory.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
|
|
|
DOPTNUM(directory-id)
Returns the number of information items that are available for
a directory.
Product: Base SAS
Document: SAS Companion for Windows
|
|
|
DOPTNUM(directory-id)
Returns the number of information items that are available for
a directory.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
DREAD(directory-id,nval)
Returns the name of a directory member.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
DSNCATLGD(filename)
Verifies the existence of an external file in the z/OS system
catalog by its physical name.
Product: Base SAS
Document: SAS Companion for z/OS
|
|
|
FAPPEND(file-id
<,cc
>
)
Appends the current record to the end of an external file.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
FCLOSE(file-id)
Closes an external file, a directory, or a directory member.
Product: Base SAS
Document: SAS Companion for z/OS
|
|
|
FCLOSE(file-id)
Closes an external file, directory, or directory member.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
FCOL(file-id)
Returns the current column position in the File Data Buffer (FDB).
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
FDELETE (fileref)
Deletes an external file or an empty directory.
Product: Base SAS
Document: SAS Companion for z/OS
|
|
|
FDELETE(“fileref”)
Deletes an external file or an empty directory.
Product: Base SAS
Document: SAS Companion for the UNIX Environments
|
|
|
FDELETE('fileref')
Deletes an external file or an empty directory.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
|
|
|
FDELETE(“fileref”)
Deletes an external file or an empty directory.
Product: Base SAS
Document: SAS Companion for Windows
|
|
|
FDELETE(fileref | directory)
Deletes an external file or an empty directory.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
FEXIST(fileref)
Verifies the existence of an external file associated with a fileref.
Product: Base SAS
Document: SAS Companion for z/OS
|
|
|
FEXIST(fileref)
Verifies the existence of an external file that is associated
with a fileref.
Product: Base SAS
Document: SAS Companion for the UNIX Environments
|
|
|
FEXIST(“fileref”)
Verifies the existence of an external file associated with a fileref.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
|
|
|
FEXIST(“fileref”)
Verifies the existence of an external file by its fileref.
Product: Base SAS
Document: SAS Companion for Windows
|
|
|
FEXIST(fileref)
Verifies the existence of an external file that is associated
with a fileref.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
FGET(file-id,variable
<,length
>
)
Copies data from the File Data Buffer (FDB) into a variable.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
FILEEXIST(filename)
Verifies the existence of an external file by its physical name.
Product: Base SAS
Document: SAS Companion for z/OS
|
|
|
FILEEXIST(filename)
Verifies the existence of an external file by its physical name.
Product: Base SAS
Document: SAS Companion for the UNIX Environments
|
|
|
FILEEXIST(“filename”)
Verifies the existence of an external file by its physical name.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
|
|
|
FILEEXIST(“filename”)
Verifies the existence of an external file by its physical name.
Product: Base SAS
Document: SAS Companion for Windows
|
|
|
FILEEXIST(file-name)
Verifies the existence of an external file by its physical name.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
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 Companion for z/OS
|
|
|
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 Companion for the UNIX Environments
|
|
|
FILENAME(fileref, filename
<, device-type
<,host-options
<,dir-ref
>
>
>
)
Assigns or deassigns a SAS fileref for an external file, directory,
or an output device.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
|
|
|
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 Companion for Windows
|
|
|
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 Language Reference: Dictionary
|
|
|
FILEREF(fileref)
Verifies that a fileref has been assigned for the current SAS
session.
Product: Base SAS
Document: SAS Companion for z/OS
|
|
|
FILEREF(fileref)
Verifies whether a fileref has been assigned for the current SAS
session.
Product: Base SAS
Document: SAS Companion for the UNIX Environments
|
|
|
FILEREF(fileref)
Verifies that a fileref has been assigned for the current SAS
session.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
|
|
|
FILEREF(“fileref”)
Verifies that a fileref has been assigned for the current SAS
session.
Product: Base SAS
Document: SAS Companion for Windows
|
|
|
FILEREF(fileref)
Verifies whether a fileref has been assigned for the current SAS
session.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
FINFO(file-id,info-item)
Returns the value of a file information item for an external file.
Product: Base SAS
Document: SAS Companion for z/OS
|
|
|
FINFO(file-id, info-item)
Returns the value of a file information item for an external file.
Product: Base SAS
Document: SAS Companion for the UNIX Environments
|
|
|
FINFO(file-id,info-item)
Returns the value of an information item for an external file.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
|
|
|
FINFO(file-id, info-item)
Returns the value of an information item for an external file.
Product: Base SAS
Document: SAS Companion for Windows
|
|
|
FINFO(file-id,info-item)
Returns the value of a file information item.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
FOPEN(fileref
<,open-mode
<,record-length
<,record-format
>
>
>
)
Opens an external file and returns a file identifier value.
Product: Base SAS
Document: SAS 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 Companion for OpenVMS on HP Integrity Servers
|
|
|
FOPEN(fileref
<,open-mode
<,record-length
<,record-format
>
>
>
)
Opens an external file and returns a file identifier value.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
FOPTNAME(file-id,nval)
Returns the name of an information item for an external file.
Product: Base SAS
Document: SAS Companion for z/OS
|
|
|
FOPTNAME(file-id, nval)
Returns the name of an item of information about an external file.
Product: Base SAS
Document: SAS Companion for the UNIX Environments
|
|
|
FOPTNAME(file-id,nval)
Returns the name of an information item for an external file.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
|
|
|
FOPTNAME(file-id, nval)
Returns the name of an information item for an external file.
Product: Base SAS
Document: SAS Companion for Windows
|
|
|
FOPTNAME(file-id,nval)
Returns the name of an item of information about a file.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
FOPTNUM(file-id)
Returns the number of information items that are available for
an external file.
Product: Base SAS
Document: SAS 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 Companion for the UNIX Environments
|
|
|
FOPTNUM(file-id)
Returns the number of information items available for an external
file.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
|
|
|
FOPTNUM(file-id)
Returns the number of information items that are available for
a file.
Product: Base SAS
Document: SAS Companion for Windows
|
|
|
FOPTNUM(file-id)
Returns the number of information items that are available for
an external file.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
FPOINT(file-id,note-id)
Positions the read pointer on the next record to be read.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
FPOS(file-id,nval)
Sets the position of the column pointer in the File Data Buffer
(FDB).
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
FREAD(file-id)
Reads a record from an external file into the File Data Buffer
(FDB).
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
FREWIND(file-id)
Positions the file pointer to the start of the file.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
FSEP(file-id,characters
<,'x' |'X'>
)
Sets the token delimiters for the FGET function.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
FWRITE(file-id
<,cc
>
)
Writes a record to an external file.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
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 image that
can be shared.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
|
|
|
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 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 Companion for the UNIX Environments
|
|
|
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 Companion for OpenVMS on HP Integrity Servers
|
|
|
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 Language Reference: Dictionary
|
|
|
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 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 Language Reference: Dictionary
|
|
|
RENAME(old-name,new-name)
Renames a file.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
|
|
|
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 Language Reference: Dictionary
|
|
|
SYSMSG()
Returns error or warning message text from processing the last
data set or external file function.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
SYSRC()
Returns a system error number.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
External Routines
|
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 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 Language Reference: Dictionary
|
|
|
MODULEN(<
cntl-string,>
module-name
<,argument-1,
..., argument-n
>
)
Calls an external routine and returns a numeric value.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
Financial
|
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 Language Reference: Dictionary
|
|
|
BLACKPTPRC(E, t, F, r, sigma)
Calculates put prices for European options on futures, based on
the Black model.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
COMPOUND(a,f,r,n)
Returns compound interest parameters.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
CONVX(y,f,c(1), ... ,c(k))
Returns the convexity for an enumerated cash flow.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
CONVXP(A,c,n,K,k,y)
Returns the convexity for a periodic cash flow stream, such as
a bond.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
DACCDB(p,v,y,r)
Returns the accumulated declining balance depreciation.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
DACCDBSL(p,v,y,r)
Returns the accumulated declining balance with conversion to a
straight-line depreciation.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
DACCSL(p,v,y)
Returns the accumulated straight-line depreciation.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
DACCSYD(p,v,y)
Returns the accumulated sum-of-years-digits depreciation.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
DACCTAB(p,v,t1, . . . ,tn)
Returns the accumulated depreciation from specified tables.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
DEPDB(p,v,y,r)
Returns the declining balance depreciation.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
DEPDBSL(p,v,y,r)
Returns the declining balance with conversion to a straight-line
depreciation.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
DEPSL(p,v,y)
Returns the straight-line depreciation.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
DEPSYD(p,v,y)
Returns the sum-of-years-digits depreciation.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
DEPTAB(p,v,t1,...,tn)
Returns the depreciation from specified tables.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
DUR(y,f,c(1), ... ,c(k))
Returns the modified duration for an enumerated cash flow.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
DURP(A,c,n,K,k,y)
Returns the modified duration for a periodic cash flow stream,
such as a bond.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|
|
|
GARKHCLPRC(E, t, S, R, R, sigma)
Calculates call prices for European options on stocks, based on
the Garman-Kohlhagen model.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
GARKHPTPRC(E, t, S, R, R, sigma)
|