counting numbers across three variables

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

counting numbers across three variables

Jennifer Steffes
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
[hidden email] (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
Reply | Threaded
Open this post in threaded view
|

Re: counting numbers across three variables

ViAnn Beadle
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:[hidden email]] On Behalf Of
Jennifer Steffes
Sent: Wednesday, November 14, 2007 1:07 PM
To: [hidden email]
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
[hidden email] (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
[hidden email] (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