Note: SAS functions used in a WHERE expression that can be optimized by an index are the SUBSTR function and the TRIM function. For more information on SAS functions, see Functions and CALL Routines ...

For example, the %SUBSTR function creates a substring of another string, while the %UPCASE function converts characters to uppercase. A special category of macro functions, the macro quoting functions ...