Customer Service: +44 1334 657957

Getting data from SPSS

The SPSS script files for exporting to QPSMR Classic and the Companion can be downloaded here:

MakeQDF.zip

This zip file contains:

MakeQDF with ASC.sbs

This creates a QDF and an associated ASC raw data file that can be used directly by QPSMR Classic and the Companion.

MakeQDF with CSV.sbs

This creates a QDF and an associated CSV raw data file that can be used directly by the Companion.

MakeQDF.sbs

This older version creates a QDF and an associated ASC file that can be used directly by QPSMR Classic and the Companion

How to use the exports

To use one the export scripts:

  1. Open the data file in SPSS
  2. [File] [Open] [Script] and choose the relevant export SBS file
  3. [Run] You will be asked to give the full path name for the output file files

Important note on naming conventions

For some SPSS variables the export creates two entries: a question and a variable that refers to the question.  The naming conventions have changed in the newer versions:

  • The older version changed the name of the original question by adding an underscore (_) to the front of the name, and a variable with the original name was added that referred to the changed original question (with the underscore).
  • The newer versions retain the original names and add a "V" to the front of the variable created from it.

In either case the user only references the variables for analysis.

Important note on newlines in text variables

SPSS allows new lines to be used in text entries which makes an ASC data file export unusable.  If the number of records in QPSMR programs is not the same as the original SPSS data file you should try the following:

  1. Use MakeQDF with CSV.sbs
  2. Use Companion [Raw] [CSV file view]
  3. [File] [Treatment and separator select] and turn on "Combine short lines"
  4. Check the number of records at the bottom is correct.
  5. [File] [Save as] to create a new CSV file with the short lines put together.
  6. [Data][View data file] and open this new CSV (you will need to change type of file to spreadsheet data)
  7. [File] [Save as] [Raw data file] to create an ASC file for use with QPSMR Classic