Hi, My dataset includes dates and scores for a health assessment. The dates are SPSS dates. The scores are numeric. Some clients have taken no assessments, some have taken one, and some have taken more than one (the most is 19 times). The data looks something like this:
Client Score1 Date1 Score2 Date2... Score19 Date19
The dates are not necessarily in order. In other words, Date2 might be earlier than Date1. What I would like to do is create four new variables: ScoreFirst, DateFirst, ScoreLast, DateLast, where ScoreFirst and DateFirst are the earliest date and corresponding score, and ScoreLast and DateLast are the most recent date and corresponding score. I understand how to find DateFirst and Datelast: Use Transform -> Compute MIN, MAX. But how do I get the associated score? For example, if, for a particular client, the earliest date is Date4, then I would want the value of Score4 for ScoreFirst.
I am using PASW Statistics 18.