Restructure Data Wizard (Variables to Cases): Number of Variable Groups

In this step, decide how many variable groups in the current file that you want to restructure in the new file.

How many variable groups are in the current file? Think about how many variable groups exist in the current data. A group of related columns, called a variable group, records repeated measures of the same variable in separate columns. For example, if you have three columns in the current data--w1, w2, and w3--that record width, you have one variable group. If you have an additional three columns--h1, h2, and h3--that record height, you have two variable groups.

How many variable groups should be in the new file? Consider how many variable groups you want to have represented in the new data file. You do not have to restructure all variable groups into the new file.

  • One. The wizard will create a single restructured variable in the new file from one variable group in the current file.
  • More than one. The wizard will create multiple restructured variables in the new file. The number that you specify affects the next step, in which the wizard automatically creates the specified number of new variables.