For the latest version of JMP Help, visit JMP.com/help.


Publication date: 05/05/2023

Grouping Columns

In the Tabulate platform, grouping columns are columns (nominal or ordinal) that you want to use to classify your data into categories of information. They can have character, integer, or even decimal values, but the number of unique values should be limited.

Note the following:

If grouping columns are nested, the Tabulate platform constructs distinct categories from the hierarchical nesting of the values of the columns. For example, from the grouping columns Sex with values F and M, and the grouping column Marital Status with values Married and Single, Tabulate constructs four distinct categories: F and Married, F and Single, M and Married, M and Single.

If grouping columns are nested, you can stack the nested values to save horizontal space in the table. To stack the grouping columns, right-click the grouping column and select the Stack Grouping Columns option. The stacked grouping columns are consolidated based on the hierarchical nesting of the values of the columns.

You can specify grouping columns for column tables as well as row tables. Together they generate the categories that define each table cell.

Tabulate does not include observations with a missing value for one or more grouping columns by default. You can include them by checking the Include missing for grouping columns option.

To specify codes or values that should be treated as missing, use the Missing Value Codes column property. You can include these by checking the Include missing for grouping columns option. For more information about Missing Value Codes, see Missing Value Codes in Using JMP.

Want more information? Have questions? Get answers in the JMP User Community (community.jmp.com).