Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Discussions
- :
- N missing values/empty cell

Topic Options

- Start Article
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Oct 12, 2017 2:32 AM
(4493 views)

Sometime in my test product data, there are certain test whereby the product is not being tested. When I query from database, the result is empty though the category still appear hence I am getting the dark dot in JMP. Is there any way (beside exclude) whereby I can easily identify and remove those empty cell in every column.

Thank you.

2 ACCEPTED SOLUTIONS

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

What you are seeing is the Missing Value character for numeric columns. JMP uses this character intentionally. Statistics performed on a column that contains missing values, will automatically exclude those cells from the calculations.

If what you want, is to change the cells from the missing value character, into an empty(Blank) cell, you can do this by using the Column Property, Value Labels. By adding "." in as a value, and just a single space as the value to display, JMP will change the missing value symbols to blanks

Jim

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

@adam,

Try This :

Clear Globals(); Clear Log(); // Open Sample Data dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); // Artificially introduce blanks SR = dt << Select where(:height == 59) << Get Selected Rows ; dt:height[SR,0] = .; dt:weight[SR,0] = .; // Remove rows with blanks dt << Select where(IsMissing(:height)); dt << Delete Rows; // Beware that you cannot remove the value for only one column - the entire row will be deleted

Best

Uday

Best

Uday

Uday

4 REPLIES 4

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

What you are seeing is the Missing Value character for numeric columns. JMP uses this character intentionally. Statistics performed on a column that contains missing values, will automatically exclude those cells from the calculations.

If what you want, is to change the cells from the missing value character, into an empty(Blank) cell, you can do this by using the Column Property, Value Labels. By adding "." in as a value, and just a single space as the value to display, JMP will change the missing value symbols to blanks

Jim

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: N missing values/empty cell

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

@adam,

Try This :

Clear Globals(); Clear Log(); // Open Sample Data dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); // Artificially introduce blanks SR = dt << Select where(:height == 59) << Get Selected Rows ; dt:height[SR,0] = .; dt:weight[SR,0] = .; // Remove rows with blanks dt << Select where(IsMissing(:height)); dt << Delete Rows; // Beware that you cannot remove the value for only one column - the entire row will be deleted

Best

Uday

Best

Uday

Uday

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: N missing values/empty cell

Thanks Uday, this script helps too :)