Date: Thu, 1 Jul 2004 17:16:48 -0400
Reply-To: Raynald Levesque <rlevesque@videotron.ca>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: Raynald Levesque <rlevesque@videotron.ca>
Subject: Re: managing multiple cases
In-Reply-To: <A638F67F2080D84C9CBECE5E9321977C89AEE5@EXCHANGE1.chkd.net>
Content-type: text/plain; charset=iso-8859-1
Hi
This is one way:
DATA LIST LIST /ID(F3) FRACTURE(A8) FRACTURECAT(A8).
BEGIN DATA
211 rib1 rib
211 rib4 rib
211 rib7 rib
123 rib2 rib
123 rib5 rib
003 skull skull
003 skull rib
111 head head
128 skull skull
END DATA.
SAVE OUTFILE='c:\temp\original data.sav'.
SORT CASES BY id fracturecat.
ADD FILES FILE=* /BY=id fracturecat /FIRST=fract1.
ADD FILES FILE=* /BY=id /FIRST=nbid.
SELECT IF fract1.
AGGREGATE OUTFILE=*
/BREAK=fracturecat
/n=N /nbid=SUM(nbid).
COMPUTE nobreak=1.
AGGREGATE OUTFILE='c:\temp\totalid.sav'
/BREAK=nobreak
/totalid=SUM(nbid).
MATCH FILES FILE=*
/TABLE='c:\temp\totalid.sav'
/BY=nobreak.
COMPUTE pc=n/totalid*100.
FORMATS pc(PCT5.2).
LIST fracturecat pc.
Regards
Raynald Levesque rlevesque@videotron.ca
Visit my SPSS site: http://pages.infinit.net/rlevesqu/
-----Original Message-----
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU]On Behalf Of
Heisler, Kurt W
Sent: July 1, 2004 4:13 PM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: managing multiple cases
I have a dataset with fracture information on 194 children. However, because
some children have multiple fractures, I actually have 630 cases entered.
For example, a child with 3 different ribs broken is entered as 3 cases, and
a child with one skull fracture and one rib fracture is entered as 2 cases:
ID FRACTURE FRACTURECAT
211 rib1 rib
211 rib4 rib
211 rib7 rib
003 skull skull
003 skull rib
...
I simply want to know the percentage of children with rib fractures (i.e., %
= [no. of children with at least 1 rib fracture] / 194 X 100), the
percentage of children with skull fractures, and so on. I assume it's a
simple crosstab I need to do, but how do I prevent the extra rib fractures
of one child with rib fractures being counted?
Thanks.
Kurt
CHKDHS Disclaimer
The information contained in this e-mail message, including any
attachment(s), is for the sole use of the intended recipient(s) and may
contain confidential and privileged information. Any unauthorized review,
use, disclosure or distribution is prohibited and may result in Legal
action. If you are not the intended recipient, and have received this
communication in error, please contact the sender by reply e-mail and
destroy all copies of the original message.
