Step 9b: Analysing with SPSS and STATA

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:

Click on the 'Classic' button

In the next screen, you will see the word ‘Read’ in the top left. Click on that.

Click on the word 'Read' in the top left
Click on the word ‘Read’ in the top left

In the box that pops up, click on the button to find Data Source as shown here:

data source
Now find your PRJ file and select it and click okay.

find prj

Then select the form you entered data to (there should be only one form to choose from:

select your form

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.


Step 10: Interpreting and Using the Data
Step 9a: Analysis with EpiInfo

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>