How to use the Interactive Mode
When you import a data set you are offered the choice to use automatically convert multiple choice and grid questions into their correct format.
SPSS Sav and Excel files cannot store multiple choice responses in the same variable so individual variables are created for each response. The import process can automatically join the responses back into a multiple choice question. The same applies to grid questions in all of the import formats. All adjacent columns that have the same categories, will be recognized as a grid.
To use interactive mode click on ‘Interactive Mode’ or “manual” mode after the file has been uploaded. You will then be able to search for multiple response and grid questions.
After you click on your choice the system will find all single answer questions it thinks can be converted. You can preview the new variable and also un-select any questions you do not wish to convert.
Click on the Create Button to create the new variables.
Merged variables are highlighted in yellow and you can click on the new variable and edit the text if required. You can also deselect elements to be included in the new variable by click on the check boxes to remove the tick mark.
If you want to removed a merged variable and revert back to individual variables simple select the variable and click on the ‘Undo Grid/Multi question’ button.