Date:         Sat, 29 Jun 2002 01:29:52 +1000
Reply-To:     Bob Green <bgreen@dyson.brisnet.org.au>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Bob Green <bgreen@dyson.brisnet.org.au>
Subject:      syntax question
Content-Type: text/plain; charset="us-ascii"; format=flowed

I have a data set which consists of studies. For example, if study A had a
100 subjects, Study B had 150 subjects and Study C had 30 subjects, the
respective number of rows/cases for each study would be 100, 150 and 30.

For each study the data contained in each row  is identical (e.g they will
have the same recruitment source, country of origin, diagnosis system used
etc) except for substance use, for which some subjects are coded as present
and some absent.

What I want to do, so I can readily cross check data accuracy is to
generate a record of one case from each study. Because each study is
represented by multiple rows I can't filter cases by studyid. I could
manually note a row from each study and then use syntax such as:

SELECT IF(casen = 25  or casen =969 or casen =3256).
EXECUTE .

I would be interested in any more elegant or simpler syntax to perform this
function.  Any assistance is appreciated,

Bob Green