The Little SAS® Book for Enterprise Guide® 4.1

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