Setting Options

Option Name
Description
Names and Labels of Transposed Variables
Construct New Variable Names
Use prefix
You can specify a prefix to use in constructing the names for the transposed variables in the output data set. When you use a prefix, the variable name begins with the prefix value and is followed by the number 1, 2, and so on.
Select a variable that contains the names of the new variables
The variable that you assign to the New column names role is used to name the transposed variables in the output data set.
If you specified to use a prefix in the name, the name for the new variable begins with the prefix and is followed by the value of the New column names variable.
If you select the Allow duplicate of ID values check box, the transposed output data set contains only the last observation for each BY group.
Construct New Variable Labels
Select a variable that contains the labels of the new variables
The values of the variable that you assign to the New column labels role are used to label the variables in the output data set.
Names and Labels of Original Variables
Put original variable names in a new variable
Each row of the output table includes the name of the variable in the input table to which the values in that output row belong. To specify a heading for the output column that contains these variable names, enter the heading in the Name box. The name can include special characters, leading numbers, and white space, but it cannot exceed 32 characters. The default name is _Name_.
Put original variable labels in a new variable
Each row of the output table includes the label of the variable in the input table to which the values in that output row belong. To specify a heading for the output column that contains these variable labels, enter the heading in the Label box. The label can include special characters, leading numbers, and white space, but it cannot exceed 32 characters. The default label is _Label_.