View or Change Column Information

JMP Support 800.450.0135 (US)

Documentation Feedback
Your feedback is important to us. us any comments about our documentation.

Discovering JMP • Work with Your Data • Work with Data Tables • View or Change Column Information

•

View or Change Column Information

Information about a column is not limited to the data in the column. Data type, modeling type, format, and formulas can also be set.

To view or change column characteristics, double-click the column heading. Or, right-click the column heading and select Column Info. The Column Info window appears.

Figure 1.21 Column Info Window

Enter or change the column name. No two columns can have the same column name.

Select one of the following data types:

–

Numeric specifies the column values as numbers.

–

Character specifies the column values as non-numeric, such as letters or symbols.

–

Row State specifies the column values as row states. This is an advanced topic. See Row State Columns in the Using JMP book.

Modeling types define how values are used in analyses. Select one of the following modeling types:

–

Continuous values are numeric only.

–

Ordinal values are either numeric or character, and are ordered categories.

–

Nominal values are either numeric or character, but not ordered.

Select a format for numeric values. This option is not available for character data. Here are a few of the most common formats:

–

Best lets JMP choose the best display format.

–

Fixed Dec specifies the number of decimal places that appear.

–

Date specifies the syntax for date values.

–

Time specifies the syntax for time values.

–

Currency specifies the type of currency and decimal points that are used for currency values.

Column Properties

Set special column properties such as formulas, notes, and value orders. See The Column Info Window in the Using JMP book.

Lock a column, so that the values in the column cannot be changed.

•

Help created on 10/11/2018