topic Create a subset by ID based on column maximum value in Discussions

Create a subset by ID based on column maximum value

david_arteta — Wed, 14 Nov 2018 09:34:27 GMT

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

gzmorgan0 — Wed, 14 Nov 2018 11:04:04 GMT

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

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

david_arteta — Wed, 14 Nov 2018 14:39:41 GMT

Thanks @gzmorgan0 for your quick and useful answer!