Publication date: 09/28/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
Contents
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 (community.jmp.com).