|
|
For a file reorganization (see APPENDIX, below), I clicked up the
command
VARSTOCASES /MAKE Brand FROM Brand1 Brand2
/MAKE Q1 FROM B1Q1 B2Q1
/MAKE Q2 FROM B1Q2 B2Q2
/KEEP = ID Age Gender
/NULL = KEEP.
That took, among other steps,
Panel 2: "How many variable groups?"
Select "More than 1"
Enter 3
Panel 3: "Case group identifier"
Select "Use selected variable"
Move into box: ID
"Target variable:" drop-down list
- Change 'trans1' to 'Brand'
Move into box: Brand1 Brand2
- Change 'trans2' to 'Q1'
Move into box: B1Q1 B2Q1
- Change 'trans3' to 'Q2'
Move into box: B1Q2 B2Q2
That's a little awkward: giving the number of variable groups on the
second panel, then filling them in on the third. Wouldn't it be easy to
just let you add new target variables, and their source variables, as
you like, on Panel 3?
Going beyond, still nicer, the Wizard could support something like the
MVGROUPS I suggested just a bit ago. That is, instead of having to
specify each source variable individually for each target variable,
allow naming a set of target variables, and a consecutive range of
source variables to be spread over them: first to the first target,
second to the second target, etc., then back to the first target again.
===============================
APPENDIX: File in, and file out
===============================
In:
ID Brand1 B1Q1 B1Q2 Brand2 B2Q1 B2Q2 Age Gender
1 5 1 2 4 2 1 25 1
2 4 2 2 3 2 1 26 2
3 3 1 2 1 1 1 27 1
Out:
ID Age Gender Brand Q1 Q2
1 25 1 5 1 2
1 25 1 4 2 1
2 26 2 4 2 2
2 26 2 3 2 1
3 27 1 3 1 2
3 27 1 1 1 1
|
Locked
