ID subcommand (CASESTOVARS command)

The ID subcommand specifies variables that identify the rows from the original data that should be grouped together in the new data file.

  • If the ID subcommand is omitted, only SPLIT FILE variables (if any) will be used to group rows in the original data and to identify rows in the new data file.
  • CASESTOVARS expects the data to be sorted by SPLIT FILE variables and then by ID variables. If split-file processing is in effect, the original data should be sorted on the split variables in the order given on the SPLIT FILE command and then on the ID variables in the order in which they appear in the ID subcommand.
  • A variable may appear on both the SPLIT FILE command and the ID subcommand.
  • Variables listed on the SPLIT FILE command and on the ID subcommand are copied into the new data file with their original values and dictionary information unless they are dropped with the DROP subcommand.
  • Variables listed on the ID subcommand may not appear on the FIXED or INDEX subcommands.
  • Rows in the original data for which any ID variable has the system-missing value or is blank are not included in the new data file, and a warning message is displayed.
  • ID variables are not candidates to become a variable group in the new data file.