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 ...
Get The Little SAS® Book for Enterprise Guide® 4.1 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
