Date: Wed, 14 Nov 2007 13:27:42 -0700
Reply-To: ViAnn Beadle <vab88011@gmail.com>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: ViAnn Beadle <vab88011@gmail.com>
Subject: Re: counting numbers across three variables
In-Reply-To: <s73b0130.003@gwiapool1_server.aap.org>
Content-Type: text/plain; charset="us-ascii"
Look at CTABLES (Option), TABLES (Deprecated Option), or MULT RESPONSE. What
you have here is a multiple response group.
-----Original Message-----
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of
Jennifer Steffes
Sent: Wednesday, November 14, 2007 1:07 PM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: counting numbers across three variables
Hi Listserv Members-
I have a dataset which asks people to list the medications they are
taking. Currently I have 3 fields in which they can enter medications
(CHRRX_OA, CHRRX_OB and CHRRX_OC) and we have coded these answers into
one of 20 catergories. Now I want to see across the three fields the
total number of times each number is listed. Here is an example of what
I have:
CHRRX_OA CHRRX_OB CHRRX_OC
4 5 1
4 3 7
7 11 4
1 3 5
I know that I can run a simple frequency and get the count of each
category within each of the 3 fields but is there a way to have the
counts of all three fields totaled, so that I can easily see that, using
the above example, I have 3 incidence of category 4 (2 from CHRRX_OA and
1 from CHRRX_OC)? Please let me know if this is not explained well.
Thanks in advance for any assistance you can give me!
Jenny
=====================
To manage your subscription to SPSSX-L, send a message to
LISTSERV@LISTSERV.UGA.EDU (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
=====================
To manage your subscription to SPSSX-L, send a message to
LISTSERV@LISTSERV.UGA.EDU (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
