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.



Leave a Reply

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

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s