topic Re: N missing values/empty cell in Discussions

N missing values/empty cell

adam — Thu, 12 Oct 2017 09:32:50 GMT

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.

Re: N missing values/empty cell

txnelson — Thu, 12 Oct 2017 14:52:44 GMT

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

Re: N missing values/empty cell

uday_guntupalli — Thu, 12 Oct 2017 21:09:11 GMT

@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

Re: N missing values/empty cell

adam — Fri, 13 Oct 2017 00:00:47 GMT

My bad, I was thinking that those missing is considered for statistic calculation. Thanks txnelson for answering my question.

Re: N missing values/empty cell

adam — Fri, 13 Oct 2017 00:03:02 GMT

Thanks Uday, this script helps too :)