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

johnfhall@orange.fr

www.surveyresearch.weebly.com <http://surveyresearch.weebly.com/>

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 <mailto:johnfhall@orange.fr> johnfhall@orange.fr <http://surveyresearch.weebly.com/> 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.