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


Using JMP > Set JMP Column Properties > Column Properties in JMP
Publication date: 05/05/2023

Column Properties in JMP

A column property is information that is attached to a column. Once that information is entered, it is saved as part of the data table. You can select column properties and apply them to columns. There are some column properties that JMP creates for your convenience. Often, you can modify these.

Column properties are listed in the Column Info window’s Column Properties menu. The area below the Column Properties menu shows column properties that have been saved to a column. To view or edit a property, select it from this list.

In the Columns panel of the data table, an icon appears next to the name of each column that contains a property, other than the Notes property. The Notes property is not denoted by an icon. Icons include the following:

Image shown here Indicates that the range or list check property is applied

Image shown here Indicates that the column contains a formula

Image shown here Indicates that the column contains a property other than the Note, Range Check, or List Check column property

For information about more column property icons, see Icons Representing Column Characteristics and Properties.

To assign a column property to one or more columns

1. Select the column or columns to which you want to assign a property.

2. Do one of the following:

Right-click the header area, select Column Properties, and select the property.

Right-click the header area, select Column Info, and select the property from the Column Properties menu.

Select Cols > Column Info and select the property from the Column Properties menu.

3. In the column property panel that appears, specify values and select options as appropriate.

Click Apply to add the column property or click OK to add the column property and close the column properties window.

A column might already contain a property that you want to apply to other columns. Use the Standardize Attributes command to apply that property to other columns. See Standardize Attributes and Properties Across Columns.

The following sections describe the properties that you can add to columns.

Basic Column Properties

Properties That Validate Column Values

Properties That Attach Information to Column Values

Properties That Control the Display of Columns

Properties Used in Modeling and DOE

Properties Associated with Control Charts and Capability

Properties That Control How Columns Are Used in Platforms

SAS Properties

Link Data Tables with Virtual Join Properties

Additional Column Properties

Properties Assigned and Controlled by JMP

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