Example 1: Creating a Simple Filter

This example creates an output data set that contains salaries less than $750,000.
  1. In the Tasks section, expand the Data folder, and then double-click Filter Data. The user interface for the Filter Data task opens.
  2. For the input data source, select SASHELP.BASEBALL.
  3. To the Variable 1 role, assign Salary.
  4. From the Comparison drop-down list, select Less than.
  5. From the Value type drop-down list, select Enter a value.
  6. In the Value box, enter 750.
  7. Under the Output Data Set heading, select Show output data to view the output data set in the results. From the Show drop-down list, select Show all output data.
  8. To run the task, click Submit SAS Code.
Here is a subset of the results, which lists the players who have a salary less than $750,000.
Filtered Data Set—WORK.filter
Copyright © SAS Institute Inc. All rights reserved.