Choose Language Hide Translation Bar
Highlighted
miguello
Level V

Compare many columns with possible empty values

All, 

 

Any ideas how to quickly do the following task:

 

I have N columns with values, that ideally should be identical, or some values might be missing (this is OK). I need to see if for a specific row either all the values are the same or missing, or if there is at least one column with value that is not the same?

 

 

2 REPLIES 2
Highlighted
miguello
Level V

Re: Compare many columns with possible empty values

Ok, I got it.

 

Provided the values are numerical, you can just calculate range between columns, doing this:

Maximum(<list of all the columns>) - Minimum(<list of all the columns>)

If it's not zero - there is difference in at least one column.

 

 

Highlighted
txnelson
Super User

Re: Compare many columns with possible empty values

I suggest you look at the Missing Values Analysis available in JMP.
Tables==>Missing Data Pattern
Jim
Article Labels

    There are no labels assigned to this post.