QPSMR Limited  
office: +44 (0) 1491 825644 
fax: +44 (0) 1491 832376 

QPSMR Facebook  QPSMR Twitter  QPSMR YouTube  


Kat's Corner

See Kat's Corner Tips for other tips.

Tip 5 - Exporting “Non-European Projects” To SPSS Version 21

Many of you will have used the “classic” software (QPSMR Insight, QPSMR CATI or QPSMR Command Language) to export your project information to the statistical program SPSS, using the [Data] [Export data] [Other data...] menu selection.  This method is still fine for projects in any language if you need to export files for use with an old version of SPSS (pre version 21).

However, if you wish to export to SPSS version 21, which requires Unicode files, and your questionnaire and/or data contains “non-European” characters (for example Korean, which uses the Far Eastern double character set) the QPSMR Companion export should be used.

  QPSMR Kat's Corner 
STEP 1.  Save the project to a Unicode QDF
(this format is compatible with “classic” QPSMR software)

Open your project file (QDF) and from the main window select [File] [Save as...], name the file (selecting the appropriate folder) and use the drop down "Save as type:" box to select [Unicode questionnaire definition file].

QPSMR Companion Unicode QDF

STEP 2.  Open the data file and save as a .UNI (Unicode) data file

(this data file format is not compatible with “classic” QPSMR software)

Select [Data] [View data file...] [Browse...] and choose your data file. From the “Data view” window select [File] [Save as] [Raw data file...], name the file (selecting the appropriate folder) and using the drop down "Save as type:" box select [Unicode UNI] and click [Save].

A message box will appear telling you how many records were written to your new Unicode file, click [OK] and then close the "Data view" window.

QPSMR Companion Data 

STEP 3. Export to SPSS

Select [File] [Export project as] [SPSS Syntax SPS...] choose the UNI data file and name the file, which is then ready to load to SPSS version 21.

QPSMR Companion Unicode SPSS 

Remember, if you run the SPS file from a different location (computer or folder) you will need to modify the file handle row in the syntax, so the correct location for the UNI data file is shown.

Note: If your project uses a binary data file (CBA) you will need to convert it to an ASCII project before following the steps above. Please contact the QPSMR support team (email info@qpsmr.ltd.uk) if you are unsure how to do this.

Extra Tip:
If you use the MakeQDF.sbs file with SPSS version 21 to generate a QPSMR QDF file and data file, although the data file will have the suffix ASC it will be stored using the Unicode format. If you wish to analyse the data with “classic” QPSMR software (QPSMR Insight, QPSMR CATI or the QPSMR Command Language) you should open the QDF in QPSMR Companion and save the data as an ASCII file. To do this, from the main window, select [Raw] [Data file view…] choose the data file (you will see a message saying that the file is Unicode) and from the “Raw data view” screen (UNI) select [File] [Save as character data file] (ASC).

I hope you found these notes useful.  Look out for more tips coming soon.

QPSMR Click Click for the Kat's Corner Tips page