Welcome to the JMP User Community!

Latest Discussions

• isolating the smallest date difference

  i have a large dataset that has a static date on a subject (date of chest CT scan) and i need to find the smallest date difference and keep that row (delete the others).  jmp 16.2.0 Example below - i want to keep rows 2 and 4 (the smallest day difference for subject 1 and 2).  subj ID.    CT date.      lung function date.      day difference1               8/30/18            1/29/18               ...

  jsolo01

  Discussions |

  Apr 24, 2024 10:00 PM

  1255 views | 3 replies

• How to prompt a " File in Use" message

  Hi,   I'm currently creating a JMP file which acts as a database. Therefore I would like to prompt a "File in use" message and keep the file locked for editing when someone else already opened the database and is making changes to the file. For example, the same message you get when you open an Excel file on a server location that is already in use by someone else:           I think I already fou...

  RobRobeyns

  Discussions |

  Apr 24, 2024 12:54 PM

  5743 views | 10 replies

• DoE and inputting replicate analytics

  Hi, I have performed a DoE as designed, but would like to know how to evaluate replicate analytical data which feeds into the response for each condition. We usually use analytical data provided by our analytical department, but are investigating a rapid analysis tool for future applications. While this tool is helpful, it appears most accurate when performing replicate analysis, and then averagin...

  MetaLizard62080

  Discussions |

  Apr 24, 2024 8:58 AM

  2786 views | 6 replies

• How to Code a new column by referencing text in second column?

  How would I code a new column to fill each cell with a specific text based on the text in a second column? I have a "well" column with A1-A100. I need to create a second column with Treatment "A", for wells A1-A10, "B" for wells A11-A20, etc.Thanks! 

  Mcc99

  Discussions |

  Apr 24, 2024 8:21 AM

  1292 views | 3 replies

• Subset rows automatically selected for by key word in column?

  I have a tall data table with sample ID, test, count, and some categorical info. The test column identifies which test the count refers to and whether it's a positive or negative population. For example "Test one positive", "test one negative", etc., as well as some rows such as "total tests". These repeat for each sample.How would I select all the rows with a "positive" in the column regardless o...

  Mcc99

  Discussions |

  Apr 24, 2024 7:41 AM

  1157 views | 1 replies