About the Column Info Window

Use the Column Info window to specify all of the attributes and properties of a column. You can access the Column Info window in any one of the following ways:

•

Select Cols > New Columns.

•

Click an existing column heading and select Cols > Column Info.

•

Right-click an existing column heading and select Column Info.

•

Double-click directly above a column name.

•

In the Columns panel, right-click a column and select Column Info.

Figure 5.2 The Column Info Window

The Column Info window contains the following information:

Column Name

Type or edit the name of the column.

Lock

Lock the column so that none of its values can be edited. After you lock a column, the lock icon (

) appears next to the column name in the data table’s Columns panel. If you add a formula to a column, the column automatically locks.

Data Type

Select or change the data type of a column, which determines the following:

–

How the column’s values are formatted in the data grid

–

How the column’s values are saved internally

–

Whether the column’s values can be used in calculations

See About Modeling Types.

Choose from the following data types:

–

Numeric columns contain only numbers (with or without a decimal point).

–

Character columns contain any characters, including numbers. In character columns, numbers are seen as characters and are treated as discrete values instead of continuous values. The maximum field width for character values is 32,766 bytes.

–

Row State columns contain row state information, which indicates whether the rows are excluded, hidden, labeled, colored, or marked. See Row State Columns.

–

Expression columns contain JSL expressions that can range from simple entries to complicated statement sequences. In particular, an expression can correspond to a picture, a matrix, or an expression. You can drag-and-drop expressions, such as an image, from your desktop to cells in an expression column. See Expression Role.

Notes:

–

If you change a column’s Data Type from Character to Numeric, any character values become missing data values and are not recoverable.

–

If you enter non-numeric data in a column with a Numeric data type, a warning window is displayed, prompting you to change the data type to Character. Click Try Again to return to the data table to re-enter the value. Click Change to change the data type. Click Revert to cancel your edit and return the cell’s value.

–

Short-integer formats might also be available. See The Short-Integer Format.

Modeling Type

(Numeric or Character data types only) Select or change the modeling type of a column, which tells JMP how to treat the column’s values during analyses. You can change the modeling type to look at a variable in different ways. See About Modeling Types.

Choose from the following modeling types:

Continuous

Only numeric data types. Continuous values are treated as continuous measurement values. JMP platforms use the numeric values directly in computations.

Ordinal

Either numeric or character data types. JMP platforms treat ordinal values as discrete categorical values that have an order. If there are more than 50 discrete values, JMP treats the column as continuous.

–

If the column has a numeric data type, the values are ordered according to their numeric magnitude.

–

If the column has a character data type and a Value Order column property is saved to the column, values are ordered according to the Value Order property. Otherwise, values are ordered according to their alphanumeric data value ordering. However, in special cases where the values have an obvious order, values are automatically ordered appropriately. See Value Ordering.

Nominal

Either numeric or character data types. JMP platforms treat all values as discrete values with no implicit order.

Multiple Response

Only character data types. Distinct entries in a single cell must be separated by commas. JMP platforms that support multiple response columns treat each entry in the comma-separated list as a separate data value. If your entries are separated by a character other than a comma, use the Multiple Response column property instead. See Multiple Response.

Unstructured Text

Only character data types. These values are generally unique and are therefore not appropriate for categorical analysis. The Text Explorer platform is ideal for analyzing unstructured text values.

Vector

Only expression data types. The entries in the cells are column or row vectors. JMP platforms that support the Vector modeling type recognize the vectors and treat them appropriately in calculations.

None

Any data type. Use None as a modeling type when a column is not well represented by the other modeling types. For example, a column of pictures or ID values might be assigned the None modeling type. JMP launch windows do not allow you to assign roles to columns with the None modeling type.

Tip: You must use the Column Info window to change a column’s modeling type to Multiple Response, Unstructured Text, or Vector.

Format

(Numeric data types only) Select or change the display format of a numeric column. See Numeric Formats.

Initialize Data

(Appears only during new column creation) Specify the type of initial data values that you want to appear in the column. See Initialize Data.

Column Properties

(Contains a list of different properties) Assign properties to columns. See Column Properties.

Tip: Click the Next button to continue adding columns.