Create a subset by ID based on column maximum value
Nov 14, 2018 1:33 AM
| Last Modified: Nov 14, 2018 1:34 AM(3280 views)
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.