cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
rijking
rijking
Level II

How to prevent NA being treated as Missing Value Code by column compression?

Created: Dec 7, 2016 12:35 PM  |  Last Modified: Jun 9, 2023 4:23 PM (4019 views)

I have a large JSL script that uses column compression several times to keep file sizes managable: 

dt << Compress Selected Columns();

My issue is that for columns (both ordinal and nominal) where I have values such as "a","b","c","d","NA", the compression function removes the "NA" values, I assume because it treats them as a Missing Value Code. However, I require the "NA" to remain as it is used in subsequent functions. How can I prevent this, whilst still running the compression?

 

Many thanks

0 Kudos
2 REPLIES 2
txnelson
Super User txnelson
Super User

Re: How to prevent NA being treated as Missing Value Code by column compression?

Dec 7, 2016 03:46 PM (3995 views)  |  Posted in reply to message from rijking 12-07-2016
Look in column info for the missing value codes and remove NA
Jim
0 Kudos
rijking
rijking
Level II

Re: How to prevent NA being treated as Missing Value Code by column compression?

Dec 7, 2016 05:02 PM (3988 views)  |  Posted in reply to message from txnelson 12-07-2016

@txnelson Thanks, but NA isn't listed as a missing value code in column info for at least some of the relevant columns. As I'm creating a large number of columns with JSL it's not practical to manually check/adjust each. Can this be scripted or can missing value codes be globally defined using JSL?

0 Kudos