Jim,
This is a job for Aggregate. Read the documentation on that command. In 17
and on you can do this
AGGREGATE OUTFILE=* MODE=ADDVARIABLES/earliestdate=min(date).
In 16 and before you have to do this.
Compute rec=1.
Execute.
AGGREGATE OUTFILE=* MODE=ADDVARIABLES/break=rec/earliestdate=min(date).
Gene Maguin
>>I can't figure this one out. I have a list of cases sorted by DATE. I want
to identify the earliest case by DATE and copy that single value for DATE
into a new variable I'll call EARLIESTDATE.
All cases will have the same value for EARLIESTDATE. I then plan to
calculate the difference between DATE and EARLIESTDATE for some additional
analysis.
=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
Locked
