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

Filtering the Data

Now that the Tours data table and the Volcanoes data table have been joined together, it is possible to create a data table of tours for volcanoes in Europe. To do this, you create a filter as part of the same query that you used to join the data tables.

Right-click the query icon in the Project Explorer or Project Designer and select Open to reopen the query. The Query Builder window opens with the Select Data tab on top. Click Filter Data to open the Filter Data tab. The Region column in the Volcanoes data table gives the general location of the volcano: North America, South America, Europe, Asia, Australia Pacific, Africa, or Antarctica.

To create a filter based on the Region column, click Region ...

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