2.
Select Cols > Standardize Attributes. The window in Standardizing Attributes across Columns appears.
Standardizing Attributes across Columns
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.
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.
Note: The Input Format item is applicable only for the Date, Time, and Duration formats.
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.
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.
5.
Right-click Column 1 and select Formula.
6.
Select BP 8M.
7.
Select Transcendental > Log.
8.
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.
In the Standardize Properties panel, click Column Properties and select Formula.
12.
Select the check box next to Substitute Column Reference.
13.
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.