SPSSX Discussion

Re-order variables in mult response tables

classic Classic list List threaded Threaded
♦
♦
 4 messages Options
John F Hall
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re-order variables in mult response tables

John F Hall

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

 

[hidden email]

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.

 

 

 
Jon K Peck
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: Re-order variables in mult response tables

Jon K Peck
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
[hidden email]
new phone: 720-342-5621



From:        John F Hall <[hidden email]>
To:        [hidden email]
Date:        11/21/2011 04:48 AM
Subject:        [SPSSX-L] Re-order variables in mult response tables
Sent by:        "SPSSX(r) Discussion" <[hidden email]>



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@...
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.
 

 
 
John F Hall
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: Re-order variables in mult response tables

John F Hall

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

 

[hidden email]

www.surveyresearch.weebly.com

 

 

 

 

 

 

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Jon K Peck
Sent: 21 November 2011 15:12
To: [hidden email]
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
[hidden email]
new phone: 720-342-5621




From:        John F Hall <[hidden email]>
To:        [hidden email]
Date:        11/21/2011 04:48 AM
Subject:        [SPSSX-L] Re-order variables in mult response tables
Sent by:        "SPSSX(r) Discussion" <[hidden email]>




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
 
[hidden email]
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.
 


 
 

Jon K Peck
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: Re-order variables in mult response tables

Jon K Peck
Define your MR set with the MRSETS command.  The definition persists with the data, unlike with MULT RESP.

Then just run the CTABLES command referencing the set as I described.

Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
new phone: 720-342-5621



From:        "John F Hall" <[hidden email]>
To:        Jon K Peck/Chicago/IBM@IBMUS, <[hidden email]>
Date:        11/21/2011 09:49 AM
Subject:        RE: Re-order variables in mult response tables



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@...
www.surveyresearch.weebly.com
 
 
 
 
 
 
From: SPSSX(r) Discussion [[hidden email]] On Behalf Of Jon K Peck
Sent: 21 November 2011 15:12
To: [hidden email]
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
[hidden email]
new phone: 720-342-5621




From:        John F Hall <[hidden email]>
To:        [hidden email]
Date:        11/21/2011 04:48 AM
Subject:        [SPSSX-L] Re-order variables in mult response tables
Sent by:        "SPSSX(r) Discussion" <[hidden email]>





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@...
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.


 
 

Free forum by Nabble Edit this page