---
metadata:
  - name: generator
    content: Diplodoc Platform v5.32.1
alternate:
  - https://yandex.by/support/surveys/en/spss.md
  - https://yandex.by/support/surveys/ru/spss.md
  - https://yandex.by/support/surveys/tr/spss.md
---
> **Documentation Index:** Fetch the complete configuration index at https://yandex.by/support/surveys/en/llms.txt

# Export the report to SPSS 

{% note info %}

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

{% endnote %}

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:

{% cut "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.

{% endcut %}

{% cut "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 info %}

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

{% endnote %}

{% endcut %}

{% include notitle [fybuttonooter](_includes/ybutton-35c31ed47a18.md) %}

{% include notitle [footer](_includes/footer-072a12bf9868.md) %}