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.9. Filtering Data

Sometimes you don’t want to use all the rows in your data table for your reports or analyses. If you need to exclude certain rows based on the value of a column, then filter your data before you run your report or analysis.

Here are the first 10 rows of the Volcanoes data table. The goal is to create a subset of the data containing only volcanoes in North America and South America. To filter the data, click the data icon in the Project Explorer or Project Designer to make it active, and then select Data Filter and Query from the menu bar. This opens the Query Builder window, with the Select Data tab on top.

Select all the ...

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