Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 5. Sorting and Filtering Data > 5.1 Filtering Data in a Task

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.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint