Date:         Thu, 3 Feb 2000 12:33:05 -0300
Reply-To:     hmaletta@overnet.com.ar
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         "Hector E. Maletta" <hmaletta@OVERNET.COM.AR>
Comments: To: Kevin Borders <greenhiker@ZDNETONEBOX.COM>
Content-Type: text/plain; charset=us-ascii

Kevin, if you do a SELECT IF operation, just do it in the negative. For
instance:

SELECT IF (COMPLAINT = 1) would select all cases where complaint=1.

SELECT IF (COMPLAINT NE 1) would select all cases where complaint is not
1.

Wou may also phrase the criterion differently, for instance:
SELECT IF (COMPLAINT > 1).
SELECT IF (NOT(COMPLAINT=1)).

Hector Maletta
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
> greenhiker@zdnetonebox.com
>
> ___________________________________________________________________
> To get your own FREE ZDNet onebox - FREE voicemail, email, and fax,
> all in one place - sign up today at http://www.zdnetonebox.com