As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.


Here are some tips for How to share your SAS knowledge with your professional network.


Tips:Use the CONTAINS Operator as an Alternative to the INDEX Function

From sasCommunity
Revision as of 12:21, 11 September 2017 by Paulkaefer (Talk | contribs)

Jump to: navigation, search

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;


....see also

....read more

....see also

....read more

Submitted By Otterm1