Instantly extract effect sizes, F-ratios, and FDR-adjusted p-values from your models with the Calculate Effects Sizes extension, available now in the JMP Marketplace!
New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
Your voice matters! Tell us how you prefer to receive JMP updates, so we can tailor our communication to your needs. Take short survey.

Discussions

Solve problems, and share tips and tricks with other JMP users.

Choose Language Hide Translation Bar

Level V

Created: Sep 1, 2022 02:15 AM | Last Modified: Jun 10, 2023 4:53 PM (1573 views)

Hi all,

How can I select the rows with the same ID and code values but with the latest timestamp?

Sample Data:

Expected Output:

1 REPLY 1

Super User

Super User

Sep 1, 2022 03:30 AM (1565 views) | Posted in reply to message from UserID16644 09-01-2022

Convert the time to Numeric (Datenum) and then use

<< Select Where(:Time == Col Max(:Time, :ID))

-Jarmo