The Little SAS® Book for Enterprise Guide® 4.1

4.10. Creating Compound Filters

When you create a filter condition, sometimes it’s not enough to base the filter on only one condition. If you want to create a filter based on two or more conditions, you can do this in the Query Builder. You can add conditions to a filter using either AND logic or OR logic. If you use AND logic, rows must meet both conditions of the filter to be included in the result. If you use OR logic, rows need to meet only one condition or the other.

In the previous section, the Volcanoes data were filtered so that only the volcanoes in North America and South America appeared in the result. Suppose you also want the volcanoes that are in Japan. For this result, you need to select rows where the region is North America ...