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 following example illustrates using a WHERE statement with the DOWNLOAD procedure. The downloaded data set contains only the observations that meet the WHERE condition.

-- Note: The position of the first character in the string is 1. -- Note: The position of the last character in the string is -1. -- Note: The SUBSTR() and MID() functions equals to the SUBSTRING() ...

Substr Substr is a Statamic (v1) variable modifier that exposes PHP's substr function in your templates.