Thanks Jon
I was using traditional MULT RESP and should have sent the syntax as well.
mult resp groups stim 'Q23: Substances taken to cope' (q23.1 to q23.3 (1))
hazards 'Q24: Hazards experienced in workplace' (q24.1 to q24.16 (1))
social 'Q28: Not at all satisfied with time for family and social life' (q28.1 to q28.11 (1))
/freq stim to social.
How would I do this with CTABLES?
John F Hall
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of Jon K Peck
Sent: 21 November 2011 15:12
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: Re: Re-order variables in mult response tables
If you are using CTABLES, this is easy to do. Here's an example.
CTABLES
/TABLE $prob BY childs
/CATEGORIES VARIABLES=$prob ORDER=D KEY=COUNT
The MR set works just like ordinary variables. You can see this choice in the Categories and Totals subdialog of the gui.
If you are using the old Multiple Response procedure, you would have to run the table and then reorder the categories in the set definition appropriately and run the table again.
Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
peck@us.ibm.com
new phone: 720-342-5621
From: John F Hall <johnfhall@orange.fr>
To: SPSSX-L@listserv.uga.edu
Date: 11/21/2011 04:48 AM
Subject: [SPSSX-L] Re-order variables in mult response tables
Sent by: "SPSSX(r) Discussion" <SPSSX-L@listserv.uga.edu>
I’m advising a group of students doing a survey of shift-workers. Is there a way to rearrange the variables in a mult resp table (dichotomous mode: see table below) by size of frequencies, or do they have to do it by hand? RTFM doesn’t help as there doesn’t appear to be anything.
John F Hall
johnfhall@orange.fr
www.surveyresearch.weebly.com
hazards Frequencies | ||||
| Responses | Percent of Cases | ||
N | Percent | |||
Q24: Hazards exerienced in workplacea | Q24: Physically demanding work | 44 | 7.8% | 81.5% |
Q24: Mentally demanding work | 40 | 7.1% | 74.1% | |
Q24: Boring and repetitive work | 29 | 5.1% | 53.7% | |
Q24: Work needing continual concentration | 40 | 7.1% | 74.1% | |
Q24: High workload | 27 | 4.8% | 50.0% | |
Q24: Awkward postures | 28 | 4.9% | 51.9% | |
Q24: Chemicals | 44 | 7.8% | 81.5% | |
Q24: Fumes or dust | 47 | 8.3% | 87.0% | |
Q24: Noise | 49 | 8.6% | 90.7% | |
Q24: Uncomfortably low temperatures | 26 | 4.6% | 48.1% | |
Q24: Uncomfortably high temperatures | 40 | 7.1% | 74.1% | |
Q24: Working at heights | 40 | 7.1% | 74.1% | |
Q24: Slippery floors | 29 | 5.1% | 53.7% | |
Q24: Dangerous machinery | 36 | 6.3% | 66.7% | |
Q24: Badly designed equipment | 20 | 3.5% | 37.0% | |
Q24: Working alone | 28 | 4.9% | 51.9% | |
Total | 567 | 100.0% | 1050.0% | |
a. Dichotomy group tabulated at value 1. | ||||