Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
david_arteta
Level III

Create a subset by ID based on column maximum value

Hi group,

 

Using JMP 14, I have a dataset where I have measurements of an analyte on several individuals over different visits. I would like to subset the dataset keeping only the row for the last visit for each individual. How can I interactively do this (no scripting if possible)? I attach a simplified version of the dataset with only 4 individuals. The resulting dataset should have only 4 rows with the latest visit information.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
gzmorgan0
Super User

Re: Create a subset by ID based on column maximum value

  1.  Create a New Column, say Max Visit, with formula Col Maximum( :Visit, :ID )
  2. Select from the Main Menu > Rows > Row Selection > Select Where .... Visit equals, Compare Column, Max Visitimage.png
  3. Table > Subset > use the default settings OK produces the table below

image.png

View solution in original post

2 REPLIES 2
Highlighted
gzmorgan0
Super User

Re: Create a subset by ID based on column maximum value

  1.  Create a New Column, say Max Visit, with formula Col Maximum( :Visit, :ID )
  2. Select from the Main Menu > Rows > Row Selection > Select Where .... Visit equals, Compare Column, Max Visitimage.png
  3. Table > Subset > use the default settings OK produces the table below

image.png

View solution in original post

Highlighted
david_arteta
Level III

Re: Create a subset by ID based on column maximum value

Thanks @gzmorgan0 for your quick and useful answer!
Article Labels

    There are no labels assigned to this post.