SAS Certification Prep Guide, 4th Edition

Using Macro Functions to Manipulate Character Strings

Macro Character Functions

Often when working with macro variables, you need to manipulate character strings. You can do this by using macro character functions. With macro character functions, you can do the following:

• 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, and more.

Macro character functions have the same basic syntax as the corresponding DATA step functions, and they yield similar results. 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, ...