Chapter 5. Sorting and Filtering Data

  • 5.1 Filtering Data in a Task 224

  • 5.2 Using the Filter and Sort Task 226

  • 5.3 Sorting Using the Sort Task 228

  • 5.4 Sorting Data in a Query 230

  • 5.5 Filtering Data in a Query 232

  • 5.6 Creating Compound Filters in a Query 234

  • 5.7 Creating a Filter with Advanced Expressions 236

5.1 Filtering Data in a Task

Sometimes you don't want to use all the rows in a data table. There are several ways to subset or filter data in SAS Enterprise Guide. If you want to create a new data table, then use the Filter and Sort task or the Query Builder as shown later in this chapter. However, if you simply want to run a task and do not need to create a new data table, then you can filter data directly in the task.

Here is the TourDates data table. ...

Get The Little SAS Book for Enterprise Guide 4.2 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.