Once the data has been entered using EpiInfo, you can export it to SPSS or STATA by following the steps below. We have prepared SPSS syntax and STATA do-file that will then allow you to analyse the data and get the quintile results. The SPSS syntax and STATA do-file is one of the files in the folder ‘data entry and analysis files’ for your country which you can download here.
Exporting from EpiInfo to SPSS or STATA
It might be easier to follow the instructions in the video in Step 9, but if your internet connection doesn’t allow this, below are text instructions:
You should at this stage have entered all the data from your questionnaires to the data entry tool. Now we are going to analyse that data to figure out what percentage of clients fall into each national wealth quintile. You can either use Epi Info, STATA or SPSS to do this. For STATA and SPSS, you’ll need to export your data to Excel from Epi Info, and then import it to STATA or SPSS.
First you should open Epi Info and click on the ‘Classic’ button:
In the next screen, you will see the word ‘Read’ in the top left. Click on that.
In the box that pops up, click on the button to find Data Source as shown here:
Then select the form you entered data to (there should be only one form to choose from:
Now you will need to click on the ‘Write’ command in the list on the left. For the output format, select Excel 97-2003 workbook. In ‘Connection Information’ choose a folder on your computer and then type the name for a new Excel file that your data will go into (you don’t have to make the file first, Epi Info should make it for you). In ‘Destination table’ write ‘Sheet1′. Click ‘OK’ and you should have an Excel file with all your data in it. This can be imported to SPSS or STATA for analysis with the provided syntax file or do-file.