Replace Missing Values with Previous Values

JMP Support 800.450.0135 (US)

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

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

•

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 3.5 Missing Values

2.

Right-click and select Fill > Replace Missing with Previous Value.

Figure 3.6 Replaced Values

•

Help created on 7/12/2018