Date: Tue, 2 Feb 1999 17:57:58 GMT
Reply-To: Richard F Ulrich <wpilib+@PITT.EDU>
Sender: "SPSSX(r) Discussion" <SPSSX-L@UGA.CC.UGA.EDU>
From: Richard F Ulrich <wpilib+@PITT.EDU>
Organization: University of Pittsburgh
Subject: Re: Aggregating Data
Brad (mystery_mole@hotmail.com) wrote:
: Assuming I have data sorted by an index number and date, how would I take
: just the last occurrence of index number (i.e. the most recent occurrence by
: date). I assume I have to use the aggregate command and the last function ,
: but haven't worked out the syntax.
- wrong. It is simpler than that. You can do Match Files with just
one file, and use /Last=varname and Select IF - For example:
Match files file=* /last=use_it /by indexnum
select if use_it
--
Rich Ulrich, biostatistician wpilib+@pitt.edu
http://www.pitt.edu/~wpilib/index.html Univ. of Pittsburgh