topic Compare many columns with possible empty values in Discussions
https://community.jmp.com/t5/Discussions/Compare-many-columns-with-possible-empty-values/m-p/256027#M50289
<P>All, </P><P> </P><P>Any ideas how to quickly do the following task:</P><P> </P><P>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?</P><P> </P><P> </P>Fri, 03 Apr 2020 20:43:59 GMTmiguello2020-04-03T20:43:59ZCompare many columns with possible empty values
https://community.jmp.com/t5/Discussions/Compare-many-columns-with-possible-empty-values/m-p/256027#M50289
<P>All, </P><P> </P><P>Any ideas how to quickly do the following task:</P><P> </P><P>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?</P><P> </P><P> </P>Fri, 03 Apr 2020 20:43:59 GMThttps://community.jmp.com/t5/Discussions/Compare-many-columns-with-possible-empty-values/m-p/256027#M50289miguello2020-04-03T20:43:59ZRe: Compare many columns with possible empty values
https://community.jmp.com/t5/Discussions/Compare-many-columns-with-possible-empty-values/m-p/256034#M50291
<P>Ok, I got it.</P><P> </P><P>Provided the values are numerical, you can just calculate range between columns, doing this:</P><P>Maximum(<list of all the columns>) - Minimum(<list of all the columns>)</P><P>If it's not zero - there is difference in at least one column.</P><P> </P><P> </P>Fri, 03 Apr 2020 20:49:53 GMThttps://community.jmp.com/t5/Discussions/Compare-many-columns-with-possible-empty-values/m-p/256034#M50291miguello2020-04-03T20:49:53ZRe: Compare many columns with possible empty values
https://community.jmp.com/t5/Discussions/Compare-many-columns-with-possible-empty-values/m-p/256044#M50294
I suggest you look at the Missing Values Analysis available in JMP.<BR /> Tables==>Missing Data PatternFri, 03 Apr 2020 21:13:09 GMThttps://community.jmp.com/t5/Discussions/Compare-many-columns-with-possible-empty-values/m-p/256044#M50294txnelson2020-04-03T21:13:09Z