MAKE Subcommand (VARSTOCASES command)
The MAKE subcommand
names, and optionally labels, the new variable to be created from
the variables on the FROM list.
- One new variable is required on each
MAKEsubcommand. It must have a unique name. - The label for the new variable is optional and, if specified, must be enclosed in quotes.
- The new variable will have the values of the variables
listed on the
FROMlist. For each case in the original data, one new row will be created for each variable on theFROMlist. - All of the variables on the
FROMlist are required to be of the same type. For example, they must all be numeric or they must all be string. - The dictionary information for the new variable (for
example, value labels and format) is taken from the first variable
in the
FROMlist. If string variables of different lengths are specified, the longest length is used. - Rows are created in the order in which variables
appear on the
FROMlist. - Variables that appear on the
FROMlist will not appear in the new data file. - Variables that are kept in the new data file and
not named on the
FROMlist will have their values propagated for each new row. - When multiple
MAKEsubcommands are used, a variable may not appear on more than oneFROMlist. - A variable may be listed more than once on a
FROMlist. Its values are repeated. - When multiple
MAKEsubcommands are used, theFROMlists must all contain the same number of variables (variables that are listed more than once must be included in the count).