SAS Tip: Use the CONTAINS Operator as an Alternative to the INDEX Function

SAS_Tipster — Thu, 05 Jul 2018 17:42:20 GMT

The CONTAINS or ? operator can be used to search a character variable for a user-specified string. This operator is case-sensitive, and can only be used within a WHERE statement. CONTAINS is similar to the index function, however, it does not provide the position of the character string within the variable.

The data steps below are equivalent. CONTAINS and ? are interchangeable.

data check;
    set sashelp.zipcode;
    where countynm contains 'z';
run;
 
data check;
    set sashelp.zipcode;
    where countynm ? 'z';
run;

Thanks to Mary Rosenbloom for posting this tip on sasCommunity.org!

topic SAS Tip: Use the CONTAINS Operator as an Alternative to the INDEX Function in SAS Tips from the Community

SAS Tip: Use the CONTAINS Operator as an Alternative to the INDEX Function