User Guide

205
File Handling a
nd Fi le Transformations
variable in the new file. Use the controls in Variables to be Transposed to define
the restructured variable in the new file.
To Specify On e Restructured Variable
E Put the variables that make up the variable group that you want to transform into the
Variables to be Transposed list. All of the variables in the group must be of the
same type (n
umeric or string).
You can include the same variable more than once in the variable group (variables are
copied rat
her than moved from the source variable list); its values are repeated in
the new file.
To Specify
Multiple Restru c tured Variables
E Select th
e first target variable that you want to define from the Target Variable
drop-down list.
E Put the variables that make up the variable group that you want to transform into the
Variables to be Transposed list. All of the variables in the group must be of the same
type (num
eric or string). You can include the same variable more than once in the
variable group. (A variable is copied rather than moved from the source variable list,
and its values are repeated in the new file.)
E Select the next target variable that you want to define, and repeat the variable selection
process
for all available target variables.
 Althou
gh you can include the same variable more than once in the same target
variable group, you cannot include the same variable in more than one target
variable group.
 Each target variable group list must contain the same number of variables.
(Variab
les that are listed more than once are included in the count.)
 The num
ber of target variable groups is determined by the number of variable
groups that you specified in the previous step. You can change the default
variable names here, but you must return to the previous step to change the
number
of variable groups to restructure.
 You mu
st define variable groups (by selecting variables in the source list) for all
available target variables before you can proceed to the next step.