Transpose

Transposing variables consists in reversing the « referencial » on which a reflection is based. In our example below, we have a question table which contains situations of beverages (When is the respondent likely to drink?). For each situation, he chooses the corresponding beverages (for example « With a good meal », the respondent will tick « Wine » and « Mineral water »).

But it would be useful not to think in terms of situations, but in terms beverages. We want, for example, to know in which situations people drink especially the wine. For this, we will transpose our variables.

2 Select the variables you wish to transpose (to be compatible, the variables must have the same number of modalities)

3 Choose or insert the new variables (in the beginning or in the end of the questionnaire). Click Finish to quit the assistant. (So many variables will be created as well as the modalities in the table) (in our example, the variables created will be « Wine », « Beer » etc…) and the values of these new variables will correspond to the situations chosen by the respondents related to the beverages (for example « Beer » could have for value « When I spree »).

Merge

We should remind that this assistant allows to assemble the variables of two surveys.

For the first part 1, go to to the introductory part of the operating mode Combine variables.

2 Select the variables to merge, here we want to merge the occupational status of respondents with their gender  (male or female) for the analyses (for example we wish to make statistics on males who are retired).

3 Choose the method of merging (refer to the dialog box Combine variables).

4 Inform the name of the new variable to create.

5 Choose or insert the new variable. By clicking Finish, the new variable will be created containing the new modalities.

Create a variable from a sub-sample

This assistant allows to create a new variable which values will be the profiles to which the observations belong (for example for a response saved by a French respondent, this created variable will have the value « France » as value).

For the part 1, go to the introductory part of the operating mode Combine variables.

2 Select your profiles from the sub-samples of the survey (refer to the part Use the sub-samples)

3 You can create sub-samples directly from this assistant by clicking 

4 Inform the name of the new variable to create,

5 Choose or insert the new variable. By clicking Finish, the new variable will be created containing the new modalities.