cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

JMP Wish List

We want to hear your ideas for improving JMP. Share them here.
Choose Language Hide Translation Bar

Option to override common non-numeric data (e.g. "N/A", "Nil")

What inspired this wish list request? 

Testing results very often include non-numeric entries such as "N/A" or "Nil" in columns consisting of otherwise continuous numeric data. This causes JMP to class it as "Character" data, resulting in the need to recode and then reclassify the column.

 

What is the improvement you would like to see? 

I'd like JMP to be able to bring up an error message to say: "Column X's data is continuous and numeric apart from rows 35 ("N/A") and 37 ("Nil"). Would you like to change these to numeric entries?" "Yes" would then bring up a window where I could recode these two rows and it would automatically be classified as continuous numeric.

 

Why is this idea important? 

It's easy to stick to rules for data recording if you're generating and doing the recording yourself, but if you're contracting out or getting help from others, these errors can sneak in (and I suspect they're pretty common!). This sorts of studies tend to have large data sets and to be able to work with the data without having to recode would be ideal.

 

1 Comment
hogi
Level XIII

Kudo from my side.
related community post File Import: specify NAN?  with a workaround: 


- load text file

- substitute NAN with "."

- pipe into open