SAS Certified Professional Prep Guide

Using SAS Macro Functions to Manipulate Character Strings

Macro Character Functions

Often when working with macro variables, you need to manipulate character strings. Here are ways you can do this by using macro character functions:

• change lowercase letters to uppercase
• produce a substring of a character string
• extract a word from a character string
• determine the length of a character string

Macro character functions have the same basic syntax as the corresponding DATA step functions, and they yield similar results. However, it is important to remember that although they might be similar, macro character functions are distinct from DATA step functions. As part of the macro language, macro functions enable you to communicate ...