O'Reilly logo

The Little SAS® Book for Enterprise Guide® 4.1 by Lora D. Delwiche, Susan J. Slaughter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required