User Guide

177
File Handling a
nd Fi le Transformations

If the working data file contains an ID or name variable with unique values, you
can use it as
the name variable, and its values will be used as variable names in
the transposed data file. If it is a numeric variable, the variable names start with
the letter V, followed by the numeric value.
 User-missing values are converted to the system-missing value in the transposed
data file. T
o retain any of these values, change the definition of missing values in
the Variable view in the Data Editor.
To Transpose Variables and Cases
E From the menus choose:
Data
Transpose...
E
Select one or more variables to transpose into cases.
Merging Data Files
You can merge data from two files in two different ways. You can:
 Merge files containing the same variables but different cases.
 Merge files containing the same cases but different variables.
Add Cases
Add Cases m
erges the working data file with a second data file that contains the same
variables but different cases. For example, you might record the same information
for customers in two different sales regions and maintain the data for each region
in separa
te files.