|Date: ||Mon, 21 Nov 2011 17:46:57 +0100|
|Reply-To: ||John F Hall <firstname.lastname@example.org>|
|Sender: ||"SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>|
|From: ||John F Hall <email@example.com>|
|Subject: ||Re: Re-order variables in mult response tables|
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
Subject: Re: Re-order variables in mult response tables
If you are using CTABLES, this is easy to do. Here's an example.
/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
new phone: 720-342-5621
From: John F Hall <firstname.lastname@example.org>
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
Percent of Cases
Q24: Hazards exerienced in workplacea
Q24: Physically demanding work
Q24: Mentally demanding work
Q24: Boring and repetitive work
Q24: Work needing continual concentration
Q24: High workload
Q24: Awkward postures
Q24: Fumes or dust
Q24: Uncomfortably low temperatures
Q24: Uncomfortably high temperatures
Q24: Working at heights
Q24: Slippery floors
Q24: Dangerous machinery
Q24: Badly designed equipment
Q24: Working alone
a. Dichotomy group tabulated at value 1.