For example, the following WHERE expression returns all values ... SAS functions used in a WHERE expression that can be optimized by an index are the SUBSTR function and the TRIM function. A constant ...

Let’s look at a quick example using the sample data shown in Figure A. The MID() function returns a substring from the middle of a source string. Specifically, let’s return the first character ...

You can use SAS functions in a WHERE expression. Also, note that a DATA or a PROC step attempts to use an available index to optimize the selection of data when an indexed variable is used in ...

The syntax for the FIND function is: Here, search_text is the character or substring you want to locate, and ...