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 that 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 on how the data has been set up.
One variable per response
- Select all the related variables in the Data Sources tree.
- Right-click and select Combine.
- 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 that shows the top-of-mind response, select the first variable, right-click, and select Duplicate.
A Nominal variable for the first response and a Binary - Multi variable set for other mentions
- Select all the related variables in the Data Sources tree.
- Right-click and select Combine > Variable Sets > As Variable.
This needs the labels of the items to be identical so that it can match them up.