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.


Difference between revisions of "Tip of the Day:September 13"

From sasCommunity
Jump to: navigation, search
(Scheduled Use the CONTAINS Operator as an Alternative to the INDEX Function)
m
Line 31: Line 31:
 
[[Tip of the Day:Submitting a Tip|Submit a Tip]]
 
[[Tip of the Day:Submitting a Tip|Submit a Tip]]
 
</div>
 
</div>
</noinclude>
+
<noinclude>

Revision as of 21:49, 8 September 2013

sasCommunity Tip of the Day


As part of the decommissioning effort for sasCommunity.org this article/tip has been migrated to communities.sas.com.

The new home for this article/tip is September 13 (https://communities.sas.com/t5/SAS-Tips-from-the-Community/SAS-Tip-Use-the-CONTAINS-Operator-as-an-Alternative-to-the-INDEX/m-p/475750#M174)



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;


Submitted By Otterm1



Feel free to comment on this tip.


Prior tip - Next tip - Random Tip

Submit a Tip