Selecting on time point for repeated measuresIs 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.
Re: Selecting one time point for repeated measuresYou 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.
Re: Selecting one time point for repeated measuresThank 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.
