The Columns Manager red triangle menu contains the following options.
Show Statistics
Displays summary statistics for each column including Min, Max, N Missing, N Unique, a Distribution graph, and All Integers. Character columns will only have a Distribution and All Integers. This option is selected by default.
Show Attributes
Displays column attributes. This option is selected by default.
Show Properties
Displays column properties. This option is selected by default.
Hide Excluded Columns
Hides columns with the excluded flag. This option is selected by default.
Columns excluded since the Columns Manager has been opened will still appear in the column list. Deselect and reselect the Hide Excluded Columns or close and reopen the Columns Manager to hide them.
Hide Hidden Columns
Hides columns with the hidden flag. This option is selected by default.
Columns hidden since the Columns Manager has been opened will still appear in the column list. Deselect and reselect the Hide Excluded Columns or close and reopen the Columns Manager to hide them.
Force calculations for all numeric columns
Specifies whether to calculate numeric statistics for all numeric columns. Deselected by default.
When selected, Columns Manager calculates the following statistics by default:
– For Continuous columns: N Unique
– For Nominal columns: Min and Max
Force calculations for all categorical columns
Specifies whether to calculate statistics for all categorical columns. Deselected by default.
When selected, Columns Manager calculates the following statistics by default:
– For Unstructured Text columns: N Missing and N Unique
– For None type columns: N Unique
Create Data Dictionary...
Creates a detailed summary of the attributes, description, data info, and properties for each column in the data table as a JMP Journal. See “Create Journals”.
Choose Columns
Determines what columns the data dictionary summarizes.
All
Summarizes all columns from the data table including hidden and excluded columns.
All Shown
Summarizes only the columns shown in the Columns Manager, excluding hidden or excluded columns when Hide Hidden Columns or Hide Excluded Columns are selected in the Columns Manager red triangle menu or columns hidden by applying filters in the Columns Manager.
Selected
Summarizes only the columns selected in the Columns Manager.
Categorical Options
Specifies the options for categorical columns.
Choose Stats
Specifies the summary statistics included.
Show Unique Values
Displays the number of unique values specified by Max Levels for each column.
Show occurrences per value
Only available when Show Unique Values is selected. Displays the number of occurrences of the unique values for each column.
Max Levels
Specifies how many unique values to display.
Continuous Options
Specifies the options for continuous columns.
Choose Stats
Specifies the summary statistics included.
Properties
Specifies the column properties included.
Value Labels
Displays value labels.
Formula
Displays the formula used for any formula columns. See “Create Formulas in JMP”.
Preview
Displays a preview of the data dictionary that will be created with the selected settings.