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. This example uses the List Data task to demonstrate how to filter data in a task. To open the List Data task, click the data icon in the Project Tree or Process Flow to make it active. Then select Tasks Describe List Data from the menu bar. The List Data window will open, displaying the Data page. For this example, all the columns in the table are assigned to the List variables role.