At 01:36 AM 5/25/2006, David Lindsay wrote:

>I have a number of variables that are answers to 5 point likert >scales, that refer to 5 brands, and I want a to create a table of >means that in layout terms looks like this: > > brand1 brand2 brand3 brand4 brand5 >colour q33 q40 q47 q54 q61 >shape q34 q41 q48 q55 >useful q35 q42

At 06:54 PM 5/26/2006, Keith McCormick responded:

>I am convinced that in [your file's] current form, this is not >possible. You will have to transform the variables so that all the >colors, etc. are in one column with a new variable for brand next to >it, or vice versa.

I'm brand new to CTABLES, so I took this as a chance to play a little. I restructured a little more than Keith McCormick suggested. (Keith, your solution is likely simpler; I'd like to see it.) But this, using VARSTOCASES and CTABLES, appears to work. (Both commands are clicked up, with some post-editing.) This is SPSS draft output:

* ........................................... . LIST.

List |-----------------------------|---------------------------| |Output Created |29-MAY-2006 17:49:16 | |-----------------------------|---------------------------| RESPNDNT q33 q34 q35 q40 q41 q42 q47 q48 q49 q54 q55 q56 q61 q62 q63

001 5 3 3 0 4 4 4 3 5 5 2 2 3 3 3 002 5 5 4 2 4 3 1 4 4 4 5 2 4 4 3 003 5 5 3 2 2 5 4 3 4 4 4 2 2 4 5 004 5 4 2 2 2 5 4 3 1 3 5 3 5 1 4 005 2 3 2 3 1 5 3 3 5 5 5 0 2 3 4 006 3 4 2 1 1 5 4 4 4 5 5 1 5 3 4 007 4 4 3 3 1 5 2 4 5 4 4 3 2 4 3 008 4 5 2 2 2 5 3 4 3 5 5 3 4 4 5 009 5 4 4 0 4 4 3 3 4 4 4 4 3 5 2 010 4 4 2 3 2 5 1 3 5 4 3 1 4 3 4

Number of cases read: 10 Number of cases listed: 10

VARSTOCASES /MAKE Rating FROM q33 q34 q35 q40 q41 q42 q47 q48 q49 q54 q55 q56 q61 q62 q63 /INDEX = Brand "Brand rated"(5) Scale "Scale on which rated"(3) /NULL = KEEP.

Variables to Cases |--------------------------|---------------------------| |Output Created |29-MAY-2006 17:49:16 | |--------------------------|---------------------------|

Generated Variables |------|---------------| |Name |Label | |------|---------------| |Brand |Brand rated | |------|---------------| |Scale |Scale on which | | |rated | |------|---------------| |Rating|Rating of | | |brand1 for | | |colour | |------|---------------|

Processing Statistics |-------------|--| |Variables In |16| |-------------|--| |Variables Out|4 | |-------------|--|

VAR LABELS Rating ''. VALUE LABELS Scale 1 'Colour' 2 'Shape' 3 'Useful'.

LIST /CASES=6.

List |-----------------------------|---------------------------| |Output Created |29-MAY-2006 17:49:16 | |-----------------------------|---------------------------| RESPNDNT Brand Scale Rating

001 1 1 5 001 1 2 3 001 1 3 3 001 2 1 0 001 2 2 4 001 2 3 4

Number of cases read: 6 Number of cases listed: 6

* Custom Tables. CTABLES /VLABELS VARIABLES=Scale Rating Brand DISPLAY=DEFAULT /TABLE Scale BY Brand > Rating [MEAN F5.2] /CATEGORIES VARIABLES=Scale Brand ORDER=A KEY=VALUE EMPTY=INCLUDE /TITLES TITLE= '2006-05-25 Lindsay - [Table layout]' CAPTION= 'By Richard Ristow' 'Run at )DATE )TIME'.

Custom Tables |-----------------------------|---------------------------| |Output Created |29-MAY-2006 17:49:16 | |-----------------------------|---------------------------|

2006-05-25 Lindsay - [Table layout] |-----------|---------|------------------------------------------| | | |Brand Brand rated | | | |--------------|------|------|------|------| | | |1 |2 |3 |4 |5 | | | |--------------|------|------|------|------| | | |Rating |Rating|Rating|Rating|Rating| | | |--------------|------|------|------|------| | | |Mean |Mean |Mean |Mean |Mean | |-----------|---------|--------------|------|------|------|------| |Scale |1 Colour|4.20 |1.80 |2.90 |4.30 |3.40 | |Scale on |---------|--------------|------|------|------|------| |which rated|2 Shape |4.10 |2.30 |3.40 |4.20 |3.40 | | |---------|--------------|------|------|------|------| | |3 Useful|2.70 |4.60 |4.00 |2.10 |3.70 | |-----------|---------|--------------|------|------|------|------| By Richard Ristow Run at 5/29/2006 5:49:16 PM