Welcome to the JMP User Community!

Latest Discussions

• how to compare rows with 0 and 1 to find out the prevalence and clustering of two medical conditions?

  Hello, I am a new and unexperienced user of JMP working on my PhD thesis. I simply cannot find out how to compare a part of my data and I need assistance. My data consists of 146 columns with either 1 or 0 (yes/no) for 146 medical conditions respectively. I have about 14000 rows (patients) to compare this data from. I need to find out the order for the most common combinations for two medical cond...

  EmmaLT

  Discussions |

  Oct 5, 2021 4:31 AM

  1860 views | 4 replies

• Is there an alternative to iterating through rows using column formula?

  I have a dataset which is a series of test runs, all collected in one table. The experiment is 6 sweeps from high to low speed for each sample, and what I need to do is assign the correct sweep number to each one (i.e. from 1 to 6) and then restart the sequence for the next sample. I could easily do this with the sequence or count function, however the number of points in each sweep is not always ...

  david_gillespie

  Discussions |

  Oct 5, 2021 1:07 AM

  1253 views | 2 replies

• //GraphBuilderGroupBox << Get Window Title issue

  Hi,   do you know how to get the GraphBuilderGroupBox "name" from the JSL scripting level? In attached picture it would be "Male" or "Female" (marked in red circles). My guess is to have a similar command to << xpath( "//GraphBuilderGroupBox" )) << Get Window Title. However it doesn't work.   Here is the code:     dt = Open( "$SAMPLE_DATA/Academic Achievement.jmp" ); win = dt << Graph Builder( ...

  LiPav

  Discussions |

  Oct 5, 2021 12:54 AM

  1460 views | 1 replies

• Summary table ignoring weight column in specific conditions (bug?)

  For some reason, when adding to summary a Median(), it ignores the weights provided for other statistics. Here, I am creating a simple filter where every male row has 0 weight, hence max and min for males should not exist. Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); // New column: Filter dt << New Column( "Filter", Numeric, "Continuous", Format( "Best", 12 ), Formu...

  FN

  Discussions |

  Oct 4, 2021 11:20 PM

  1117 views | 2 replies

• JMP 16: Script to add columns with formula, using relative reference

  Hi,Trying to write my first ever script in JMP, would greatly appreciate some help. I have 10 columns (lets say one, two, three, four, five, six , seven, eight, nine, ten) and a Total column.and i need to add ten more column which calculates the percentage of the first ten columns. I cannot use column names because i have 150 columns actually and the column names are all different.  How do i get i...

  Rakendu

  Discussions |

  Oct 4, 2021 6:15 PM

  1585 views | 2 replies