VARIABLES Subcommand (FLIP command)

VARIABLES names one or more variables (columns) to be transposed. The specified variables become observations (rows) in the new active dataset.

  • The VARIABLES subcommand is optional. If it is not used, all variables are transposed.
  • If the VARIABLES subcommand is specified, variables that are not named are discarded.

Example

Using the untransposed file from the previous example, the command

FLIP VARIABLES=A TO C.

transposes only variables A through C. Variable D is not transposed and is discarded from the active dataset. 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