Introduction
Questionnaires sometimes collect data in two stages, where the first asks something like "which one brand comes to mind first" and another question asks the user for other responses ("and which other brands do you know"). For example, this is commonly used when collecting top of mind awareness and prompted/aided awareness.
Requirements
Data is set up so the first variable contains the first brand mentioned, the second variable contains the second brand mentioned, etc.
Methods
The best way to address this depends upon how the data has been setup.
One variable per response
- Select all the related variables in the Data Sets tree.
- Right-click and select Combine or simply click Combine in the toolbar.
- In the Object Inspector, set Structure to Binary - Multi (Compact). The resulting variable set will contain all the mentions.
If you wish to also have a question which shows the top of mind response, select the first variable, right-click and select Duplicate or else click Duplicate in the toolbar.
A Nominal variable for the first response and a Binary - Multi variable set for other mentions
- Select all the related variables in the Data Sets tree.
- In the toolbar click Combine > As Variable Set > Merge Variables.
This needs the labels of the items to be identical so that it can match them up.
Next
How to Merge Variables into a Single Variable