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.11. Filtering Based on Grouped Data

In the Query Builder, you can summarize data by group. Once the data are summarized, you can subset the data based on the summarized values. To do this, use the Filter the summarized data area of the Filter Data tab.

Summarizing the Data

To filter your data based on summarized values in a group, you first need to create the summarized values. Click the desired 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 the columns for the query. In this example, ...

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