|
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 |
|
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 |
| Free forum by Nabble | Edit this page |
