A column might contain attributes (data types, modeling types, numeric formats, and so on) or properties (formulas, notes, list and range checks, and so on) that you want other columns to have. You can use the existing column to standardize the attributes and properties across columns. This includes both adding and deleting attributes and properties.
2.
|
Select Cols > Standardize Attributes. The window in Standardizing Attributes across Columns appears.
|
Use the Recode option if you need to recode similar values within multiple columns in the same way. Once you click Recode, the values that appear are generated from the union of all of the selected columns. For example, suppose that you have two columns with user responses. One column contains the values Agree and Disagree. The other column contains the values Agree, Disagree, Unsure, and Strongly Disagree. You want to simplify all of the values in both columns to be A, D, U, and SD.
Note: If you want to recode values only in a single column, you can also use the Cols >Utilities > Recode option. See View Patterns of Missing Data in Enter and Edit Data.
By default, the items within the Standardize Attributes panel are dimmed. To access an item, click the Attributes button and select the items to be duplicated across columns.
2.
|
Select Cols > Standardize Attributes.
|
3.
|
Select Column Properties in the Standardize Properties area.
|
5.
|
Click Apply to standardize the property across selected columns. Changes are shown in the data table, open reports, and open graphs.
|
Or click OK to standardize the property across selected columns and close the column properties window.
2.
|
Select Cols > Standardize Attributes.
|
3.
|
Click Column Properties in the Delete Properties area and select the properties that you want to delete.
|
4.
|
Click OK.
|
If you have applied a formula to a column, and you want to apply that same formula to additional columns in the data table, use the Substitute Column Reference option.
For example, the Blood Pressure.jmp sample data table contains blood pressure measurements taken on five subjects three times each day, over a period of three days. You want to find the log of each blood pressure (BP) column.
1.
|
Open the Blood Pressure.jmp sample data table.
|
2.
|
Select Cols > Add Multiple Columns.
|
4.
|
Click OK.
|
5.
|
6.
|
Select BP 8M.
|
7.
|
Select Transcendental > Log.
|
8.
|
Click OK.
|
Column 1 now contains the log of the BP 8M column. You want the rest of the empty columns to contain the log of the remainder of the BP columns.
10.
|
Select Cols > Standardize Attributes.
|
11.
|
12.
|
Select the check box next to Substitute Column Reference.
|
13.
|
Click OK.
|
Now all of the new columns are populated with the log of the BP columns, in the order in which they appear. Column 1 contains the log for BP 8M, Column 2 contains the log for BP 12M, and so on.