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 ...

The %SUBSTR and %QSUBSTR functions produce a substring of argument, beginning at position, for length number of characters. %SUBSTR does not mask special characters or mnemonic operators in its result ...