Date: Thu, 3 Feb 2000 12:33:05 -0300
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: "Hector E. Maletta" <hmaletta@OVERNET.COM.AR>
Content-Type: text/plain; charset=us-ascii
Kevin, if you do a SELECT IF operation, just do it in the negative. For
SELECT IF (COMPLAINT = 1) would select all cases where complaint=1.
SELECT IF (COMPLAINT NE 1) would select all cases where complaint is not
Wou may also phrase the criterion differently, for instance:
SELECT IF (COMPLAINT > 1).
SELECT IF (NOT(COMPLAINT=1)).
Universidad del Salvador
Buenos Aires, Argentina
Kevin Borders wrote:
> Hello. I'm a doctoral student in social work with a record selection
> question. I have a database made up of cases and complaint information.
> Each case may have more than one complaint associated with it. The data
> file looks something like this:
> case number complaint
> 001 1
> 001 45
> 002 17
> 002 87
> 003 1
> 003 22
> 003 129
> 004 1
> 004 36
> 005 77
> 005 110
> While I know how to select the case numbers where the complaint is 1,
> what I now need is to be able to also select all of the other complaints
> that are associated with that case number. What I get now is all of
> the case numbers where complaint = 1, and the rest of the complaints
> are left out. Does anybody have any suggestions? Thanks very much.
> Kevin Borders, MSSW University of Louisville
> To get your own FREE ZDNet onebox - FREE voicemail, email, and fax,
> all in one place - sign up today at http://www.zdnetonebox.com