nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

83244_en-US

liliconcom

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.

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

Thanks @gzmorgan0 for your quick and useful answer!

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

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

Comments

There are no comments yet