Subscribe Bookmark RSS Feed

N missing values/empty cell

Highlighted
adam

Occasional Contributor

Joined:

Sep 20, 2017

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
txnelson

Super User

Joined:

Jun 22, 2012

Solution

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

missing value column property.PNG

missing value column property2.PNG

 

Jim
uday_guntupalli

Community Trekker

Joined:

Sep 15, 2014

Solution

@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
4 REPLIES
txnelson

Super User

Joined:

Jun 22, 2012

Solution

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

missing value column property.PNG

missing value column property2.PNG

 

Jim
adam

Occasional Contributor

Joined:

Sep 20, 2017

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

uday_guntupalli

Community Trekker

Joined:

Sep 15, 2014

Solution

@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
adam

Occasional Contributor

Joined:

Sep 20, 2017

Thanks Uday, this script helps too :)