Next
Use the General tab of the Export Data dialog box to enter details of the output file that you want to export to, and to select a language for the export.
Variable description language. Choose the language in which you want variable and category descriptions to be exported. The drop-down list shows all of the languages that are available in the current survey data file.
Export format. Choose the format in which to save the exported data. Available formats are:
• IBM® SPSS® Statistics File (SAV)
• Delimited Text File (Microsoft Excel)
• IBM SPSS Data Collection Data File (ddf and compressed dzf formats)
• IBM® SPSS® Quantum™ Data File (DAT)
• SAS System File
• Triple-S File (Fixed or CSV)
• IBM® SPSS® Data Collection XML Data File
• Metadata Only
• Advanced
File name. Enter a name and file path for the output file.
The remaining sections of this dialog box are specific to the export format you have selected:
SPSS Statistics File (SAV). If you are exporting data to SPSS Statistics .SAV format for use with versions of SPSS Statistics prior to version 12, check the Use SPSS Statistics SAV short file names box to export variable names with a maximum length of eight characters.
• Export Factors. When selected, case data for single-response categorical variables that have factor values, are exported as factor values (or missing values for non-factor elements). The case data are not exported as categorical values.
• Export Variables in Different Levels into Different Files. When selected, variables are exported, in one or multiple files, and grouped together in the same hierarchical level. The export process creates a new file for each unbounded level that has variables selected from it. A separate record is created in the output file for each record at the level being exported.
SAS System File. If you are exporting data to SAS system file format, ensure that the Export Factors box is checked if you want to export factors set for the categories in IBM® SPSS® Data Collection Survey Reporter as category values in the SAS file (this is the default for SAS). Deselect the box if you want to export the native values (sequential values starting from 1).
Quantum Data File (DAT). If you are exporting data into a Quantum DAT file format, a set of prompts to do with card column options is displayed. Do the following:
• In the Width of serial number field, type the number of columns to reserve for the respondent serial number. The default is five columns.
• In the Width of card number field, type the number of columns to reserve for the card number. The default is two columns.
• In the Max card length field, type the maximum number of columns to write per card. The default is 80. Leave this field blank for an infinite card length.
• In the Full name of serial variable field, enter the name of the variable that contains the respondent serial numbers. In survey data files created by Data Collection products this variable is called Respondent.Serial, but in files from other sources it may have another name, for example, Serial.
Metadata Only. When selected, this option only saves the metadata document as loaded by Survey Reporter (the Variable tab and filtering options are not available).
Advanced. If you select the Advanced option, choose the Edit button to display the Data Link Properties dialog box, where you can specify the connection properties for your required export format.