Using JMP • Enter and Edit Data • Enter Data • Replace Missing Values with Previous Values

For the latest version of JMP Help, visit JMP.com/help.

Previous
 • 
Next
Replace Missing Values with Previous Values
When a column contains missing values, you can replace those values with the value in the preceding cell. For example, if “4, .,., ., ., 6, ., ., 7, .” is selected, the values are changed to “4, 4, 4, 4, 4, 6, 6, 6, 7, 7”.
1.
Select the cells that contain the missing and replacement values.
The first cell that you select must immediately precede a missing value. After that, you can select non-adjacent cells.
Figure 4.5 Missing Values
2.
Right-click and select Fill > Replace Missing with Previous Value.
Figure 4.6 Replaced Values

Previous
 • 
Next
Help created on 3/19/2020