Merging variables
You can merge two or more variables to form a new variable. This is useful when you want to create a total awareness variable or when you want two or more categorical variables to be treated as one variable in your tables.
When merging categorical variables, the new variable has the same categories as the categorical variables you are merging. If the same category appears in more than one of the variables, it appears only once in the new variable.
When merging text variables, the new variable contains the texts from the text variables you are merging, concatenated together.
When merging numeric or date variables, the new variable contains the sum of the values stored in the variables you are merging.
The variables that you select must be:
▪of the same type (although they can be a mixture of single response and multiple response categorical variables)
▪at the same level if you are using hierarchical data. The level of the variables you select defines the level of the new variable. For example, if you select variables in the Person loop, the new merged variable will also be at the Person level.
If any of the variables you are merging has been edited, the edits will not be copied to the new variable. For example, if you merge two categorical variables from which you have deleted one or two categories. The new variable will include the deleted categories.
When you merge variables that contain any built-in special items, the new variable will not contain any of the built-in special items. You are most likely to see this when you are working with Quanvert data, which typically contains built-in special items. For example, if you merge two Quanvert variables, either or both of which contain a built-in mean, the new variable will not contain a mean. Built-in bases are not copied to the new variable and UNICOM Intelligence Reporter therefore inserts an autobase into the new variable.
To merge variables
1 In the Variables pane, use Shift+click or Ctrl+click to select the variables that you want to merge, and then cick Variables > Merge.
The New Variable window opens. The variable has a generated name such as NewVar.
2 Change the name and description. Ensure that the variable name conforms to the UNICOM Intelligence Reporter Naming conventions.
3 Make any further edits to the variable using the features in the New Variable dialog, and then choose Save and Close from the toolbar.
You can now use the new variable in your tables.
See also