Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

- JMP User Community
- :
- Discussions
- :
- Compare many columns with possible empty values

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Compare many columns with possible empty values

Apr 3, 2020 1:43 PM
(456 views)

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
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Compare many columns with possible empty values

I suggest you look at the Missing Values Analysis available in JMP.

Tables==>Missing Data Pattern

Tables==>Missing Data Pattern

Jim

Article Labels

There are no labels assigned to this post.