Example (FLIP command)

The following is the LIST output for a data file arranged in a typical spreadsheet format, with variables in rows and observations in columns:

A              B         C         D
 
Income     22.00     31.00     43.00
Price      34.00     29.00     50.00
Year     1970.00   1971.00   1972.00

The command

FLIP.

transposes all variables in the file. The LIST output for the transposed file is as follows:

CASE_LBL    VAR001    VAR002    VAR003
 
A              .         .         .
B            22.00     34.00   1970.00
C            31.00     29.00   1971.00
D            43.00     50.00   1972.00
  • The values for the new variable CASE_LBL are the variable names from the original file.
  • Case A has system-missing values, since variable A had the string values Income, Price, and Year.
  • The names of the variables in the new file are CASE_LBL, VAR001, VAR002, and VAR003.