World Statistics Day was yesterday, but we’re celebrating all week long! This celebration means acknowledging the impact statistics has on our world. Who is your favorite statistician? Share with us who they are and why they top your favorites list.
Choose Language Hide Translation Bar
Highlighted
MMasten
Level I

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. 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

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!

View solution in original post

2 REPLIES 2
Highlighted

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!

View solution in original post

Highlighted
MMasten
Level I

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.

Article Labels

    There are no labels assigned to this post.