Language Reference |
Character and Formatting Functions |
ANYALNUM |
searches a character string for an alphanumeric character and returns the first position at which it is found |
ANYALPHA |
searches a character string for an alphabetic character and returns the first position at which it is found |
ANYCNTRL |
searches a character string for a control character and returns the first position at which it is found |
ANYDIGIT |
searches a character string for a digit and returns the first position at which it is found |
ANYFIRST |
searches a character string for a character that is valid as the first character in a SAS variable name under VALIDVARNAME=V7, and returns the first position at which that character is found |
ANYGRAPH |
searches a character string for a graphical character and returns the first position at which it is found |
ANYLOWER |
searches a character string for a lowercase letter and returns the first position at which it is found |
ANYNAME |
searches a character string for a character that is valid in a SAS variable name under VALIDVARNAME=V7, and returns the first position at which that character is found |
ANYPRINT |
searches a character string for a printable character and returns the first position at which it is found |
ANYPUNCT |
searches a character string for a punctuation character and returns the first position at which it is found |
ANYSPACE |
searches a character string for a white-space character (blank, horizontal and vertical tab, carriage return, line feed, form feed) and returns the first position at which it is found |
ANYUPPER |
searches a character string for an uppercase letter and returns the first position at which it is found |
ANYXDIGIT |
searches a character string for a hexadecimal character that represents a digit and returns the first position at which that character is found |
returns one character in the ASCII or EBCDIC collating sequence |
|
CAT |
concatenates character strings without removing leading or trailing blanks |
CATS |
concatenates character strings and removes leading and trailing blanks |
CALL CATS |
concatenates character strings and removes leading and trailing blanks |
CATT |
concatenates character strings and removes trailing blanks |
CALL CATT |
concatenates character strings and removes trailing blanks |
CATX |
concatenates character strings, removes leading and trailing blanks, and inserts separators |
CALL CATX |
concatenates character strings, removes leading and trailing blanks, and inserts separators |
CHOOSEC |
returns a character value that represents the results of choosing from a list of arguments |
CHOOSEN |
returns a numeric value that represents the results of choosing from a list of arguments |
COLLATE |
returns an ASCII or EBCDIC collating sequence character string |
COMPARE |
returns the position of the left-most character by which two strings differ, or returns 0 if there is no difference |
COMPBL |
removes multiple blanks from a character string |
CALL COMPCOST |
sets the costs of operations for later use by the COMPGED function |
COMPGED |
compares two strings by computing the generalized edit distance |
COMPLEV |
compares two strings by computing the Levenshtein edit distance |
COMPRESS |
removes specific characters from a character string |
COUNT |
counts the number of times that a specific substring of characters appears within a character string that you specify |
COUNTC |
counts the number of specific characters that either appear or do not appear within a character string that you specify |
COUNTQ |
counts the number of "words" and quoted strings in a character expression |
COUNTW |
counts the number of words in a character expression |
FIND |
searches for a specific substring of characters within a character string that you specify |
FINDC |
searches for specific characters that either appear or do not appear within a character string that you specify |
IFC |
returns a character value that matches an expression |
IFN |
returns a numeric value that matches an expression |
INDEX |
searches a character expression for a string of characters |
INDEXC |
searches a character expression for specific characters |
INDEXW |
searches a character expression for a specified string as a word |
INPUTC |
applies a character informat at run time |
INPUTN |
applies a numeric informat at run time |
LEFT |
left aligns a character expression |
returns the length of a character string |
|
LENGTHC |
returns the length of a character string, including trailing blanks |
LENGTHM |
returns the amount of memory (in bytes) that is allocated for a character string |
LENGTHN |
returns the length of a nonblank character string, excluding trailing blanks, and returns 0 for a blank character string |
LOWCASE |
converts all letters in an argument to lowercase |
CALL MISSING |
assigns a missing value to the specified character or numeric variable |
NLITERAL |
converts a character string that you specify to a SAS name literal (N-literal) |
NOTALNUM |
searches a character string for a nonalphanumeric character and returns the first position at which it is found |
NOTALPHA |
searches a character string for a nonalphabetic character and returns the first position at which it is found |
NOTCNTRL |
searches a character string for a character that is not a control character and returns the first position at which it is found |
NOTDIGIT |
searches a character string for any character that is not a digit and returns the first position at which that character is found |
NOTFIRST |
searches a character string for an invalid first character in a SAS variable name under VALIDVARNAME=V7, and returns the first position at which that character is found |
NOTGRAPH |
searches a character string for a nongraphical character and returns the first position at which it is found |
NOTLOWER |
searches a character string for a character that is not a lowercase letter and returns the first position at which that character is found |
NOTNAME |
searches a character string for an invalid character in a SAS variable name under VALIDVARNAME=V7, and returns the first position at which that character is found |
NOTPRINT |
searches a character string for a nonprintable character and returns the first position at which it is found |
NOTPUNCT |
searches a character string for a character that is not a punctuation character and returns the first position at which it is found |
NOTSPACE |
searches a character string for a character that is not a white-space character (blank, horizontal and vertical tab, carriage return, line feed, form feed) and returns the first position at which it is found |
NOTUPPER |
searches a character string for a character that is not an uppercase letter and returns the first position at which that character is found |
NOTXDIGIT |
searches a character string for a character that is not a hexadecimal digit and returns the first position at which that character is found |
NVALID |
checks a character string for validity for use as a SAS variable name in a SAS statement |
PROPCASE |
converts all words in an argument to proper case |
PUTC |
applies a character format at run time |
PUTN |
applies a numeric format at run time |
repeats a character expression |
|
REVERSE |
reverses a character expression |
RIGHT |
right aligns a character expression |
SCAN |
selects a given word from a character expression |
CALL SCAN |
returns the position and length of a given word from a character expression |
CALL SCANQ |
returns the position and length of a given word from a character expression, and ignores delimiters that are inside quotation marks |
ROUNDEX |
encodes a string to facilitate searching |
SPEDIS |
determines the likelihood of two words matching, expressed as the asymmetric spelling distance between the two words |
STRIP |
returns a character string with all leading and trailing blanks removed |
SUBPAD |
returns a substring that has specified length and is padded with blanks, if necessary |
SUBSTRN |
returns a substring, allowing a result with a length of zero |
extracts substrings of character expressions |
|
TRANSLATE |
replaces specific characters in a character expression |
TRANWRD |
replaces or removes all occurrences of a word in a character string |
TRIM |
removes trailing blanks from character expressions and returns one blank if the expression is missing |
TRIMN |
removes trailing blanks from character expressions and returns a null string (zero blanks) if the expression is missing |
UPCASE |
converts all letters in an argument to uppercase |
UUIDGEN |
returns the short or binary form of a Universal Unique Identifier (UUID) |
VERIFY |
returns the position of the first character that is unique to an |
Copyright © SAS Institute, Inc. All Rights Reserved.