Date:         Thu, 3 Feb 2000 16:43:45 -0600
Reply-To:     Max Martin <mmartin@EDGEWOOD-SA.K12.TX.US>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Max Martin <mmartin@EDGEWOOD-SA.K12.TX.US>
Comments: To: Kevin Borders <greenhiker@zdnetonebox.com>
Content-Type: text/plain; charset="iso-8859-1"

What about:

SORT cases by CASENO COMPLAIN.
compute flag=0.
if(complain=1) flag=1.
if (lag(flag)=1 and caseno=lag(caseno)) flag=1.
fre flag.

Then select or filter your cases to get all cases with flag=1.

I tried it with a small dataset of 16 cases, and it seemed to work ok

HTH
Max Martin


----- Original Message -----
From: Kevin Borders <greenhiker@zdnetonebox.com>
To: Max Martin <mmartin@edgewood-sa.k12.tx.us>
Sent: Thursday, February 03, 2000 3:40 PM
Subject: Re:


> What I'm trying to select are all cases that have a complaint of 1
attached
> to them (which I know how to do), as well as the rest of the complaints
> that are attached to that case number, where one of the complaints =
> 1. When I just select for complaint = 1, all of the other case numbers
> and complaints which also have that case number are filtered out.  I'm
> wanting to know this "in cases that have a complaint =1, what other
complaints
> are also connected with this case?"
>
> Kevin
>
> --
> Kevin Borders, MSSW, University of Louisville
> greenhiker@zdnetonebox.com - email
>
>
>
> ___________________________________________________________________
> To get your own FREE ZDNet onebox - FREE voicemail, email, and fax,
> all in one place - sign up today at http://www.zdnetonebox.com
>
>