Stat/Transfer is a widely used third party application that enables you to convert data files to over 30 different formats. This includes analysis programs such as Strata, SPSS and Epi info.


Please be aware that you will need to have a copy of Strat/Transfer to make use of this export format.


There are two types of files that are important to consider for the Stat/Transfer export format: the data file (which has a ".dat" file extension) and the definition file (which has a ".stdd" file extension). The data file contains the response data and the definition file contains the associated meta data which describes the response data types, code values, etc.


When selecting the Stat/Transfer export format, you will be able to configure a few export options:




Repeating sections

You can choose how to handle repeating sections in your export:

  • By selecting "Export each section as a separate file", a separate data file and definition file pair will be created for each section. These will all be zipped up into a single archive which you can extract after downloading.
  • By selecting "Export repeating sections as separate files", all non-repeating sections will be merged into a single data file and definition file pair. Each repeating section will generate its own data and corresponding definition files. All files will be zipped up into a single archive which you can extract after downloading. 
  • By selecting "Merge repeating sections as additional rows into a single file", all sections will be merged into a single data file and definition file pair. A separate row will be generated for each iteration. For example, if there are two repeating sections in the form, "Section A" and "Section B", and for a particular submission "Section A" repeats 3 times and "Section B" repeats 4 times, the file will contain 4 rows for the submission.
  • By selecting "Merge repeating sections as additional columns into a single file", all sections will be merged into a single data file and definition file pair. For repeating sections, additional columns will be generated to accommodate the maximum number of repeats in the data and the column/variable headings will be suffixed with "_0", "_1", "_2" as needed to indicate each instance. 


Multi-select option naming

There are also two options which can be used to determine the naming convention for multi-select field types. When exporting multi-select field types, a column/variable is generated for each available option which is then represented as "selected" (1) or "not selected" (0).


Assume you have a multi-select field "HOUSEHOLD_ITEMS" with 3 options: Television (value: TV), Radio (value: R) and Fridge (value: F):

  • By selecting "Append option values to question name", the column/variable names generated for each option will be labelled by appending the relevant option's value to the field name. E.g. "HOUSEHOLD_ITEMS_TV", "HOUSEHOLD_ITEMS_R", "HOUSEHOLD_ITEMS_F".
  • By selecting "Append option labels to question name", the column/variable names generated for each option will be labelled by appending the relevant options's label to the field name. E.g. "HOUSEHOLD_ITEMS_Television", "HOUSEHOLD_ITEMS_Radio", "HOUSEHOLD_ITEMS_Fridge".


Single-select option naming

Likewise with single-select field types, there are two options which can be used to determine the naming convention for single-select field types.


Assume you have a single-select field "HOUSEHOLD_ITEMS" with 3 options: Television (value: TV), Radio (value: R) and Fridge (value: F):

  • By selecting "Use the selected question's value", the column/variable name generated for the option will be labelled by appending the option's value to the field name. E.g. "HOUSEHOLD_ITEMS_TV" or "HOUSEHOLD_ITEMS_R" or "HOUSEHOLD_ITEMS_F".
  • By selecting "Use the selected question's label", the column/variable name generated for the option will be labelled by appending the option's label to the field name. E.g. "HOUSEHOLD_ITEMS_Television" or "HOUSEHOLD_ITEMS_Radio" or "HOUSEHOLD_ITEMS_Fridge".


Converting from Stat/Transfer to another format

Once the export has been generated, extract the zip file. Open Stat/Transfer and select "ASCII/Text - Stat/Transfer Schema" as the Input File Type. Once you have done that, browse to the ".stsd" file you extracted from the export download.