Re: SPSS select unique values?
From: Richard Ulrich (Rich.Ulrich_at_comcast.net)
Date: 08/11/04
- Previous message: David Reilly: "Re: State Space models and forecasting in Logistics network"
- In reply to: Joe: "SPSS select unique values?"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 11 Aug 2004 01:01:03 -0400
On 10 Aug 2004 13:45:39 -0700, jstankov@skidmore.edu (Joe) wrote:
> I have a dataset someone asked me to work on for them. They have a
> variable (Campus Safety Report Number) and the rows of SPSS contain
> unique student names. Because more than one student can be associated
> with a campus safety report, the report number 345, for example,
> occurs five times since there were 5 students involved. Does anyone
> know the syntax that would allow me to select unique non-duplicated
> codes in this variable so I can run a frequency that does not
> exaggerate the actual number of unique campus safety incidents? I
> know this is the not the best way to set up this data set, but any
> help is appreciated.
comp.soft-sys.stat.spss is the better place to post for
questions about SPSS.
If you don't care which report you get, or you can sort to
place the primary one first, then it is easy to
Sort cases by rep_num .
match files file= */first= vfirst /by rep_num .
If there is unique information that can be saved from
several fields, you can do the sort and then
Aggregate ....
using the minimum, max, first non-missing, count, etc., ...
to pick up non-missing fields or totals.
-- Rich Ulrich, wpilib@pitt.edu http://www.pitt.edu/~wpilib/index.html
- Previous message: David Reilly: "Re: State Space models and forecasting in Logistics network"
- In reply to: Joe: "SPSS select unique values?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
