IDEAS home Printed from
   My bibliography  Save this paper

Exporting CAPI data to Stata: Experience from surveybe


  • Joachim De Weerdt

    (Economic Development Initiatives, Tanzania)


Researchers typically spend significant amounts of time cleaning and labeling data files in preparation of analyses of survey data. Computer-assisted personal interviewing (CAPI) gives the ability to automate this process. First, consistency checks can be run during the interview so that only data that passes autogenerated and user-written validation tests comes back from the field. Second, CAPI allows for the autogeneration of a Stata do-file that labels data files. This presentation discusses the Stata export procedure used by surveybe, a CAPI application designed to handle complex surveys. The questions, as displayed on the screen to the interviewer, are automatically turned into variable labels. Likewise, the drop-down menus are autocoded as value labels. Furthermore, the export procedure ensures that data from rosters get exported into different Stata data files and that complete referential integrity is ensured across all the files originating from the same survey, with unique primary keys linking files together. Any changes made to the electronic questionnaire (for example, adding a response code to the drop-down menu) or changes to the phrasing of a question will be automatically incorporated into the exported data files, thus ensuring that the data files match the questionnaires completely.

Suggested Citation

  • Joachim De Weerdt, 2011. "Exporting CAPI data to Stata: Experience from surveybe," United Kingdom Stata Users' Group Meetings 2011 15, Stata Users Group.
  • Handle: RePEc:boc:usug11:15

    Download full text from publisher

    File URL:
    File Function: presentation slides
    Download Restriction: no

    More about this item

    NEP fields

    This paper has been announced in the following NEP Reports:


    Access and download statistics


    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:boc:usug11:15. See general information about how to correct material in RePEc.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: (Christopher F Baum). General contact details of provider: .

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    We have no references for this item. You can help adding them by using this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service hosted by the Research Division of the Federal Reserve Bank of St. Louis . RePEc uses bibliographic data supplied by the respective publishers.