UPCASE()
Convert text to uppercase.
Open →SAS String Functions
SAS text processing and formatting equivalents with line-by-line commented examples. Open each dedicated function page for automatic live output and exampchini.
Viewer Index · Tools Index · 68 functions
LOWCASE()
Convert text to lowercase.
Open →STRIP()/TRIM()
Trim leading and trailing whitespace or chosen characters.
Open →LEFT()
Trim the left side of input text.
Open →TRIMN()/TRIM()
Trim the right side of input text.
Open →LENGTH()/LENGTHN()
Return the length of text input.
Open →SCAN()
Split text using a delimiter and optional limit.
Open →CATX()
Join list-style input using a delimiter.
Open →TRANWRD()/PRXCHANGE()
Replace target text with another value.
Open →SUBSTR()
Extract a substring using start and optional length.
Open →INDEX()/FIND()
Find first index of a substring.
Open →FIND(...,-length)
Find last index of a substring.
Open →SUBSTR(...)=...
Compare text prefix using a target value and length.
Open →Substring From Match
Return text from first case-sensitive match.
Open →Substring From Match (Case-Insensitive)
Return text from first case-insensitive match.
Open →Substring Count
Count occurrences of a substring.
Open →Kamba ya Kamba
Pad text left/right/both to a target width.
Open →Pad Anza
Pad the start of a string.
Open →Pad End
Pad the end of a string.
Open →Lowercase First Character
Lowercase the first character.
Open →Capitalize First Character
Uppercase the first character.
Open →Title Case
Uppercase first letter of each word.
Open →Sentence Case
Convert words to sentence case.
Open →Camel Case
Convert input to camelCase.
Open →Snake Case
Convert input to snake_case.
Open →Kebab Case
Convert input to kebab-case.
Open →Translate Map
Apply character/string mapping replacements.
Open →Kufunga Neno
Wrap long text to a fixed width.
Open →Chunk Split
Split text into fixed-length chunks.
Open →Count Characters
Count character/code point frequencies.
Open →Character From Code Point
Create text from numeric code points.
Open →Code Point Of First Character
Get code point of first character.
Open →Text To Hex
Convert text bytes to hexadecimal.
Open →Hex To Text
Decode hexadecimal input to text/bytes.
Open →Hex To Decimal
Convert hexadecimal input to decimal text.
Open →Base64 Encode
Encode UTF-8 text as Base64.
Open →Base64 Decode
Decode Base64 input to UTF-8 text.
Open →URL Encode Component
URL-encode a URI component.
Open →URL Decode Component
URL-decode a URI component.
Open →Encode URI
Encode a full URI.
Open →Decode URI
Decode a full URI.
Open →Parse Query String
Parse query-string text into key/value output.
Open →PRXMATCH()
Run regex match and show groups.
Open →Regex Match All
Run regex global match and return all matches.
Open →PRXCHANGE()
Replace regex matches in input.
Open →JSON libname/FILENAME JSON
Parse JSON text and pretty-print output.
Open →Kamba ya Umbizo
Apply printf-style placeholders to arguments.
Open →Muundo wa Nambari
Format decimal values with separators.
Open →PUT(date, format.)
Format date/timestamp values using tokens.
Open →MD5()
Generate MD5 hash for text input.
Open →Levenshtein Distance
Compute edit distance to a target string.
Open →String Similarity
Estimate similarity ratio with a target string.
Open →Soundex
Generate soundex phonetic code.
Open →ROT13
Apply ROT13 substitution cipher.
Open →Ukanda Tags
Remove HTML/XML tags from input.
Open →Escape HTML
Escape text for safe HTML display.
Open →Unescape HTML
Decode HTML entities to text.
Open →Split Lines
Split text into lines with optional line endings.
Open →Expand Tabs
Replace tab characters with spaces.
Open →Zero Fill
Left-pad numeric text with zeros.
Open →Left Justify
Left-justify text to fixed width.
Open →Right Justify
Right-justify text to fixed width.
Open →Kituo
Center text with fill characters.
Open →Remove Prefix
Remove a prefix if it exists.
Open →Ondoa Kiambishi
Remove a suffix if it exists.
Open →Sehemu
Split into (before, separator, after) at first separator.
Open →Reverse Partition
Split into (before, separator, after) at last separator.
Open →Syllable Division (Heuristic)
Approximate syllable splitting for words.
Open →