Create Subsets

If you want to look closely at only part of your data table, you can create a subset. For example, suppose that you have already compared the sales and profits of big, medium, and small computer and pharmaceutical companies. Now you want to look at the sales and profits of only the medium-sized companies.

Creating a subset is a two-step process. First select the target data, and then extract the data into a new table.

Subset with the Subset Command

Select Help > Sample Data Library and open Companies.jmp.

Selecting the Rows and Columns That You Want to Subset

Select Rows > Row Selection > Select Where.

Select Size Co in the column list box on the left.

Enter medium in the text enter box.

Click OK.

Hold down the Ctrl key and select the Type, Sales ($M), and Profits ($M) columns.

Creating the Subset Table

Select Tables > Subset to launch the Subset window.

Figure 1.36 Subset Window

Select Selected columns to subset only the columns that you selected. You can also customize your subset table further by selecting additional options.

Click OK.

The resulting subset data table has seven rows and three columns. For complete details about the Subset command, see Create a Subset Data Table in the Using JMP book.

Subset with the Distribution Platform

Another way to create subsets uses the connection between platform results and data tables.

Example of Creating a Subset Using the Distribution Command

Select Help > Sample Data Library and open Companies.jmp.

Select Analyze > Distribution.

Select Type and click Y, Columns.

Click OK.

Double-click on the histogram bar that represents Computer to create a subset table of the Computer companies.

Caution: This method creates a linked subset table. This means if you make any changes to the data in the subset table, the corresponding value changes in the source table.