1.
Select Rows > Data Filter.
Initial Data Filter Window
Detach it temporarily by deselecting the Use Floating Window option from the Data Filter red triangle menu.
Detach it persistently by selecting File > Preferences > Tables and deselecting the Use a Floating Window for Data Filters option.
There are three modes of filtering: Select, Show, and Include. You can set and clear these modes using the corresponding check boxes in the Data Filter.
You can turn on the automatic selection of this option using the Data Filter Show Check preference. For details about row states, see the Row State Columns in The Column Info Window.
You can turn on the automatic selection of this option using the Data Filter Include Check preference. For details about row states, see the Row State Columns in The Column Info Window.
There are two additional options when filtering: Auto clear and Conditional. These options are available from the red triangle menu for the Data Filter. For more information, see Red Triangle Options for the Data Filter.
Data Filter Control Panel
The AND button opens the Add Filter Columns list. The and operator restricts the selection. You can add variables to the filter process at any time.
The OR button opens the OR Add Filter Columns list. The or operator extends the selection. You can add variables to the filter process at any time.
1.
Open the Big Class.jmp sample data table.
2.
Select Analyze > Distribution.
3.
Select age and sex and click Y, Columns.
4.
5.
Select Rows > Data Filter.
6.
Select sex and click Add.
Rows Containing Males Highlighted in Data Table and Histograms
Now the selection does not match the Data Filter selection. A warning message and a Reset selection button appear in the Data Filter window.
Data Filter Warning Message and Reset Button
If you have more than one nominal or ordinal column selected in the Data Filter, this option clears any other selections before making a new selection. For example, using Big Class.jmp, suppose that you have the columns sex (nominal) and age (ordinal) in your Data Filter. If you have males (M) selected for sex, and you click on an age group, say age 12, your selection of males will be automatically cleared. This means that selecting age 12 is not conditional on selecting males. Conversely, if you turn off Auto clear, you can then select both males and age 12 at the same time. Auto clear is on by default.
This option is similar to the Tables > Subset command, only without subsetting options.
For filter columns with hierarchy, you can use the Conditional option to filter what appears in the column lists. For example, you could filter by region so that only the states in the selected region appear in the list.
The following example illustrates how the Conditional option helps show the subcategories clearly, without the extra categories that do not belong.
1.
Open the Cities.jmp sample data table.
2.
Select Rows > Data Filter.
3.
In the Data Filter window, select city, State, and Region, and then click Add.
4.
Select Conditional from the Data Filter red triangle menu.
5.
Select MW in the Region list.
6.
Select OH from the State list.
Using the Conditional Option
The bracketed number in front of the column name indicates the order in which the column values were selected. In Using the Conditional Option, Region was selected first, so it has a [1] in front of the column name. State was selected second, so it has a [2] in front of the column name.
To use the animation feature, from the red triangle menu next to Data Filter, select Animation. Then select the variable that you want to animate. The highlighted frame around the variable indicates which variable is selected for animation.
Animation Control Panel in the Data Filter
The square button () hides the Animation Control section on the Data Filter Window. Select Animation from the menu on the Data Filter title bar again to see the Animation Control.
The options in the Save Where Clause menu include the following:
1.
Open the Big Class.jmp sample data table.
2.
Select Rows > Data Filter.
3.
Select age, sex, and height and click Add.
7.
From the red triangle menu next to Data Filter, select Save Where Clause > to Script Window.
The Select Missing option highlights any missing values in the data table.
Blocks Display shows each level as a block.
List Display shows each level as a member of a list, followed by its frequency.
Single Category Display shows each level, followed by its frequency, in a menu.
Check Box Display adds a check box next to each value. To make this the default setting, select the Data Filter Check Box Display option in File > Preferences > Tables.
Clear Find clears the results of the Find operation and returns the window to its original state.
Match Case uses the case of the search string to return the correct results.
Contains searches the data for values that includes the search string.
Does not contain searches the data for values that do not include the search string.
Starts with searches the data for values that start with the search string.
Ends with searches the data for values that end with the search string.
Selects at least n of the selected values.
Selects a maximum of n of the selected values.
Selects between n and m of the selected values.