If columns contain value labels, sorting is based on the actual data values, not the value labels. (See Value Labels in The Column Info Window.) However, the value labels are displayed in the sorted data table.
1.
|
Open the Popcorn.jmp sample data table.
|
2.
|
Select Tables > Sort.
|
3.
|
4.
|
Click By to add the columns to the sort list.
|
5.
|
Customize your sort further using the additional options. For this example, highlight yield and click the descending button.
|
6.
|
Type a name for the new sorted table in the box beside Output table name. For this example, type sorted popcorn.
|
7.
|
Click OK.
|
To replace the original data table with the sorted table instead of creating a new table with the sorted values, click the box beside Replace Table. This option is not available if there are any open report windows generated from the original table.
|
|
(Optional) To give a name to the sorted table, type a name in the box beside Output table name.
|
|