Home > Managing Projects, Data & The Organization > How to: Export to SPSS Quantum

How to: Export to SPSS Quantum

Overview

SurveyToGo supports exporting data into SPSS Quantum. Since SPSS Quantum file format uses card numbers and variables are placed into card numbers and offsets, we’ve create a special MAP file that maps between SurveyToGo variables and Quantum records and offsets. Here are the steps to do this

  1. Step 1: Export the survey to a MAP file (excel format)
  2. Step 2: Check and if needed modify the map file.
  3. Step 3: Export the survey data using the map file.

Step 1: Export the survey to a MAP file (excel format)

To export the survey to a map file:

  1. Right click on the survey and choose “Export Results”
  2. Choose to export the survey and not the results:
  3. Choose the SPSS Quantum map format:
  4. Complete the wizard by filling out the last screen or keeping the defaults:
  5. That’s it!

Step 2: Check and if needed modify the map file.

Once you have the map file there is no real need for you to manipulate it unless you wish to make changes to the defaults. If you do need to edit it:

  1. Open the file:
  2. You can see the CardNumber columns and startIndex/EndIndex columns which maps which SurveyToGo variable goes into what card (line) of the SPSS Quantum file and what offset from the limit of 80 characters per card.

Step 3: Export the survey data using the map file

When exporting the interviews, you can need to use the map file when exporting to SPSS Quantum:

  1. Choose to export the survey results:
  2. Then, choose the SPSS Quantum format:
  3. On the last export screen, enter the map file location:
  4. You will then export 2 files, a DAT file and an Axis file
  5. That’s it! 

Visit us at: http://www.dooblo.net

  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: