Exporting data from a specific data level (as a stacked export) (AskiaTools)

Use this feature to export data from a specific data level of a QES file or SQL database. Loop statements will be separated into individual questions. This is known as a stacked export.

In this topic:

• Performing a stacked export
• Using the command line

Performing a stacked export

To perform a stacked export:

1. In the file menu, select export, then stacked export....  The stacked export dialog appears:
   
2. In target file, specify the file into which you want to save the data (you can click ... and browse to a location). You can specify a new QES file, or to an SPSS .sav file.
3. In target level, select the data level you wish to export from.
4. In default loop match, select the method that will be used to match items (by entry codes, captions or links), unless specified otherwise for a specific loop (see match type below).
5. In the variable list, select the loops and questions you would like to export.
6. For each loop you plan to export, in the match with column select the loop you would like to match it with (if the loop is the same as the target level, only itself is available). If you select develop questions, one question will be created for each loop item.
7. In the match type column, you can specify how the match will be done for each loop (using entry codes, captions, IDs, or by adding new responses). If you do not select anything here, the setting in default loop match (see above) will be used for that loop.
8. If you want to export your data selection (so that you can re-use it in a future stacked export), click save:
   
   Note that you must have made a selection in target level to use this command. The question selection is saved as an XML file to your computer. You can import this file during a future stacked export by clicking open:
   
9. Click OK to carry out the export.

Command line