Set JMP Column Properties

The Column Info Window and the Columns Manager

Use the Column Info window and the Columns Manager 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

Compact Character Columns

The Short-Integer Format

Numeric Formats

Store Information in Row State Columns

Initialize Data in a Column

About the Columns Manager

Filtering Columns

Add, Edit, and Delete Column Properties

Copy and Paste Column Properties and Attributes

Columns Manager Red Triangle Menu Options

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).