Using JMP • Reshape Data • Sort Data Tables
Previous
 • 
Next
Sort Data Tables
You can sort a JMP data table by columns in either ascending or descending order. By default, columns sort in ascending order. You can either create a new table that contains the sorted values, or you can replace the original table with the sorted table.
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.
If your sorted column uses either the Value Ordering property or the List Check property, the column is sorted according to that order.
Example of Sorting Data Tables
1.
Open the Popcorn.jmp sample data table.
2.
Select Tables > Sort.
The Sort Window
3.
Highlight the names of the columns that you want to sort by. For this example, select popcorn and yield.
4.
Click By to add the columns to the sort list.
The columns that you add to the list establish the order of precedence for sorting. The first column in the list is the major sort field. Each variable thereafter is sorted within the previous variable in the sort list. You can drag and drop within the By list to change the sort order.
5.
Customize your sort further using the additional options. For this example, highlight yield and click the descending button.
For a complete list of options, see Description of the Sort Window.
6.
Type a name for the new sorted table in the box beside Output table name. For this example, type sorted popcorn.
Completed Sort Window
7.
Click OK.
Sorted in Ascending and Descending Order
Description of the Sort Window 
Select Columns Filter Menu
Contains options to search and filter through columns. See Columns Filter Menu in JMP Platforms.
Replace Table
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.
Output table name
(Optional) To give a name to the sorted table, type a name in the box beside Output table name.
Keep dialog open
To keep this window open after clicking OK, check the box beside Keep dialog open.
By
Adds the columns that you want to sort by. The columns that you add to the list establish the order of precedence for sorting. The first column in the list is the major sort field. Each variable thereafter is sorted within the previous variable in the sort list.
Remove
Removes any highlighted columns.
ascending and descending buttons ()
To change the list order (ascending or descending) of the values for the grouping variables, in the By variable list, select a variable and click the appropriate ascending or descending button. The icon beside the variable changes to indicate the sorting order.