For the latest version of JMP Help, visit

Using JMP > Set JMP Column Properties
Publication date: 11/29/2021

Set JMP Column Properties

The Column Info Window

Use the Column Info window to set specific properties on a column in a data table. Here are some examples of the actions that you can perform on a column:

Change data and modeling types

Change numeric formats

Add formulas

Specify restrictions on values or missing values

Order categorical values or row data

Save specification, control, or response limits

Enter a known value for sigma

You can also standardize attributes and properties across multiple columns, assign a preselected analysis role to columns, and compress columns in a data table.

Figure 5.1 The Column Info Window 

The Column Info Window


About the Column Info Window

About Modeling Types
The Short-Integer Format
Numeric Formats
Store Information in Row State Columns
Initialize Data in a Column

Column Properties in JMP

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

Standardize Attributes and Properties Across Columns

Recode Column Values
Standardize Column Attributes
Standardize Column Properties
Delete Column Properties
Example of Standardizing a Formula

Assign a Preselected Analysis Role to a Column

Want more information? Have questions? Get answers in the JMP User Community (