An example of a multiple choice question is:
Which of the following did you purchase today:
- Fast food
- Ice cream
This seems to be one question, but the answers are usually not stored in one column, but a column per answer, as below.
During the import in Dapresy you can define if you would like these 3 variables to become 1. This is more efficient for reporting and will take less storage of data. The setting to define this is called the "Multi choice separator" which is in the example above an underscore. During the transformation, Dapresy will remove the postfix after the multiple choice separator and the postfix will become the answer id's. As an example, the multiple in the picture above will become Q3Mult with answers 1, 2 and 3.
Dapresy has two options when defining the multiple choice questions:
Apply multiple choice variable grouping to all variables
Dapresy can recognise all multiple choice questions at once. (In SPSS this can be defined on the import settings, but for an Excel/CSV upload you need to define this during the meta data transformation.)
Note: be careful in defining the multi choice separator. In case you have other variables which should not be a multiple but with this character, it will define these as a multiple too.
To do this, click on your right mouse button and select "Apply multiple choice variable grouping to all variables", see image below.
Dapresy can only do this if you have a multiple choice separator for all these questions, so Dapresy will immediately prompt what the separator should be, like in the picture below.
Apply multiple choice variable grouping
In case you don't want or you cannot apply this rule to all, you can also select a group of variables and tell Dapresy to combine them into a multiple by using the function "Apply multiple choice variable grouping, see image below.
What else can you do during the meta data transformation?
All done? Continue!