Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Created:
Jun 7, 2019 9:32 AM
| Last Modified: Jun 7, 2019 9:32 AM
(2036 views)

Is there a way to easily select just the most recent time point for subjects with repeated measures? Some subjects have one time point, others have 15, and then there are others who are inbetween. The data are arranged so each timepoint has its own row with the data in the columns. There are subject numbers, dates, and which number iteration it is in the columns as well.

1 ACCEPTED SOLUTION

Accepted Solutions

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

You might be able to use one column formula to compute the maximum date per subject, then another column formula to compute where date equals the maximum.

Learn it once, use it forever!

2 REPLIES 2

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

You might be able to use one column formula to compute the maximum date per subject, then another column formula to compute where date equals the maximum.

Learn it once, use it forever!

Highlighted
##

Thank you for the suggestion. I used the column maximum formula (Col Maximum (date, id)) to give the maximum date by ID. Then I was able to use the row selection function to find where the data column was equal to the maximum date.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Selecting one time point for repeated measures

Article Labels

There are no labels assigned to this post.