CONTAINS Operator and Compound WHERE Expressions

WHERE statement was introduced in Creating a Simple Report in SAS. In this post I will cover CONTAINS Operator and different types of Compound WHERE Expressions.

CONTAINS Operator helps to identify and select the observations that include a particular substring. ‘?’ symbol can be used in place of the CONTAINS Operator.




SAS_compound controlled where_parentheses

SAS_compound controlled where_parentheses

Note: The last three results images do not display the actual number of observations due to aesthetic reasons.

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s