Using a Filter

Suppose that you have a worldwide telemarketing data file that contains the name, country, yearly salary, and age of potential contacts, as the following example shows:

To create a database that includes people who earn over $100,000 a year, are over the age of 50, and live outside the United States

Use the match condition discard salary < 100,000 to exclude people who earn less than $100,000 a year. The selected records are as follows:

John Brown       US       125,000   57
Larry Little     US       118,000   42
Ann South        Canada   220,000   53
David Peterson   France   175,000   72
Richard North    Spain    350,000   39
Nancy Richards   Japan    150,000   54
William Parker   Egypt    200,000   64

Use the match condition keep age > 50 to include people over the age of 50. The remaining records are as follows:

John Brown       US       125,000   57
Ann South        Canada   220,000   53
David Peterson   France   175,000   72
Nancy Richards   Japan    150,000   54
William Parker   Egypt    200,000   64

Use the match condition discard country = US to exclude people living in the United States. The remaining records are the records that match all of the restrictions:
```
Ann South        Canada   220,000   53
David Peterson   France   175,000   72
Nancy Richards   Japan    150,000   54
William Parker   Egypt    200,000   64
```

If you want to use the same data file to create a database of only those people who live in the United States, or only those people under the age of 30, simply define another filter. There is no limit to the number of filters that you can define for a data file.