Export the report to SPSS

Note

A report in SPSS in available for simple and advanced types of the survey.

Every answer has its own number. However, for some types of answers the numbers are reserved:

  • 96 – Other.

  • 97 – Other (answer that lets the user input text).

  • 98 – None of the above.

  • 99 – Not sure.

Variables of a multiple-choice question (multiple response set) have the following form in the report: value labels contain answer options and question labels contain their text. It may lead to the fact that the text in the table will be the same for all rows when building reports.

To make the table look more familiar, use the following instruction:

Using the dialogue box

  1. In SPSS options click Analyze → Tables → Multiple response sets.

  2. Select all binary variables of a multiple-choice question (including the Other binary category and excluding the Other text variable).

  3. Apply the following settings:

    • In the Variable Coding section select Dichotomies with the Counted Value: 1 value.

    • In the Category Labels Source section select Labels of counted value and turn on the Use variable label as set label option.

  4. Click Add and OK buttons sequentially.

Using syntax

To create multiple sets without using dialogue boxes use the syntax.

The shortened syntax version to create multiple sets looks like this:

MRSETS
/MDGROUP NAME=$cash LABELSOURCE=VARLABEL CATEGORYLABELS=COUNTEDVALUES VARIABLES=q1_1 to q1_8 VALUE=1
.

To create a code for the syntax automatically:

  1. In SPSS options click Analyze → Tables → Multiple response sets.

  2. Select all binary variables of a multiple-choice question (including the Other binary category and excluding the Other text variable).

  3. Apply the following settings:

    • In the Variable Coding section select Dichotomies with the Counted Value: 1 value.

    • In the Category Labels Source section select Labels of counted value and turn on the Use variable label as set label option.

  4. Click Add и Paste buttons sequentially. A new file with the generated code opens. The code is added to the currently active syntax file, if the file was already opened.

Using syntax you can specify any numnber of multiple sets with one command. For example:

MRSETS
/MDGROUP NAME=$q1 LABELSOURCE=VARLABEL CATEGORYLABELS=COUNTEDVALUES VARIABLES=q1_1 to q1_8 VALUE=1
/MDGROUP NAME=$q2 LABELSOURCE=VARLABEL CATEGORYLABELS=COUNTEDVALUES VARIABLES=q2_1 to q2_8 VALUE=1
.

Note

Put a dot in the end of the MRSETS command for the correct operation.

Contact support



You can also go to