Using JMP > JMP Preferences > Preferences for Recoding Columns
Publication date: 05/24/2021

Preferences for Recoding Columns

The Recode preferences customize the recoding of columns.

Figure 13.24 Recode Preferences 

Recode Preferences

Table 13.23 Preferences on the Recode Page

Preference

Description

Sort style

Specifies how values are sorted by default.

New Value

Sorts in ascending order by the new value.

Old Value

Sorts in ascending order by the old value.

Count

Sorts in descending order with the most common values at the top.

Commit style

Defines the default behavior for recoding columns.

New Column

Puts the values in a new column is the default setting.

Formula Column

Put the values in a formula column. Select this option if you’d like to see how the values are being replaced.

In Place

Replaces the recoded column “in place”.

Script sequence of actions

Saves all of your actions in the script. This option is selected by default. If the option is deselected, only the original and replacement values are included in the script.

Compress sequence

Combines expressions to simplify the saved script. Selected by default when you select Script sequence of actions.

Remove Empty Items

In a Multiple Response column, excludes empty items in the column when recoding the column in the data table. This option is deselected by default.

Remove Duplicate Items

In a Multiple Response column, excludes duplicate items. For example, if the original data were a, b, b, c, and no changes to those particular items were made, the recoded column in the data table would contain a, b, c. This option is deselected by default.

Sort Items

In a Multiple Response column, sorts items alphabetically. For example, if the original data were b, a, c, and no changes to those particular items were made, the recoded column in the data table would contain a, b, c. This option is deselected by default.

Want more information? Have questions? Get answers in the JMP User Community (community.jmp.com).