EpiHandy Notes for importing into SPSS
From EpiHandy
EpiHandy has a function to import data into SPSS through the usage of Syntax script.
- NOTE! EpiHandy does not export directly to SPSS sav files.
- NOTE! This is only tested fully on version 15 and newer. Some older versions do not properly run the syntax import functionality.
This function exports Variables, Data, DataTypes, Labels and Values, so it gives you a very well documented dataset. Not only the variables and data.
When saving a dataset as SPSS EpiHandy outputs 2 files for each datatable in the dataset.
- A SPSS Syntax script (Export.sps)
- A delimited file containing the data from EpiHandy (Export.sps.txt)
To create an SPSS sav file from this you need to do the following.
- Open the Syntax file (Export.sps)
- NOTE! If you move the files to another location you need to do some manual edits of the Syntax file (see below)
- Mark everything in the file and click Run in SPSS
- This will create a SPSS spreadsheet
- Now you can save this file as a SPSS sav file.
If you move the file to a new location before running the syntax in SPSS you need to do the following:
So if you move the files to a new location or a computer, you need both files, AND what is very important is that you need to MANUALY edit the path written in the SPSS syntax file
You need to change the path and filenames in the second line of the script which starts with /FILE
So if the original syntax looks like: /FILE = 'C:\Exports\File1.sps.txt and you have moved the 2 files to D:\Export\Version2\ you need to change that like to: /FILE = 'D:\Export\Version2\File1.sps.txt