BookmarkSubscribeRSS Feed
Choose Language Hide Translation Bar
MMasten
New Contributor

Selecting one time point for repeated measures

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. 

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions

Re: Selecting one time point for repeated measures

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!
0 Kudos
2 REPLIES 2

Re: Selecting one time point for repeated measures

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!
0 Kudos
Highlighted
MMasten
New Contributor

Re: Selecting one time point for repeated measures

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.

0 Kudos