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


Using JMP > The Column Info Window > Column Properties > Properties That Validate Column Values
Publication date: 04/30/2021

Properties That Validate Column Values

The following properties help validate values in a column: Range Check, List Check, and Missing Value Codes.

Range Check

Range checking validates the data in a column. Set up the column to accept only numbers that fall within a specified range.

Select which formula to use to set up the range. x is the value entered into the column, a is the beginning of the range, and b is the end of the range.

a = the lowest value that the column accepts

b = the highest value that the column accepts

For a single-sided range check, leave either a or b empty.

From the data table, modify the range check by clicking () next to the column name in the Columns panel.

List Check

List checking validates the data in a column. Set up the column to accept only the individual values that you specify. List checking is useful when you want to specify how to order the data in your graphs or plots.

You can use up to 127 values.

Use the buttons to add new values, change, or reverse the order of values, and remove values.

Once a list check is set on a column, the cursor changes to when positioned over the cells. If you try to enter a value not included on the validation list, a warning message appears.

To see a menu of acceptable values, right-click a cell and select List Check Values. You can select the cell value from the menu instead of entering it into the cell.

From the data table, modify the list check by clicking next to the column name in the Columns panel.

Missing Value Codes

Use missing value codes to specify column values that should be treated as missing. For example, sometimes the value 99 is used as a placeholder to represent missing values, or perhaps several values are used to represent different types of missing values.

Note: The Missing Value Codes column property is an extended attribute. If you plan to export to a SAS 9.4 server or Save As a SAS 9.4 file format, you should enable extended attributes in the SAS Integration Preference page. See SAS Integration in the JMP Preferences section. Alternatively, you should select Store table and column properties in SAS 9.4 extended attributes in the Save As window. If extended attributes are not selected, JMP exports or saves Missing Value Codes as missing values. Extended attributes are supported only by SAS 9.4. Earlier versions of SAS disregard any extended attributes.

To remove missing value codes for a single column

1. In the Columns panel of the data table, next to the column, click > Missing Value Codes.

2. Missing Value Codes is highlighted in the list. Click Remove.

3. Click OK.

To remove missing value codes across multiple columns

1. Select the columns containing the missing value codes that you want to delete.

2. Select Cols > Standardize Attributes.

3. Under Delete Properties, click Column Properties > Missing Value Codes.

4. Click OK.

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