Exporting data
You can export selected data from the currently open survey data file to a number of different file formats such as IBM SPSS Statistics SAV files, delimited text files for use in Microsoft Excel, Quantum DAT files, or SAS system files. The export creates a new file in the location that you specify.
New variables and variable edits are also exported.
Notes
▪Exporting data is only possible from the desktop version of UNICOM Intelligence Reporter. You cannot export data from the version of UNICOM Intelligence Reporter that is installed from a server.
▪Exporting new or edited variables that contain an up-lev expression (for example, MalesInHouseHold "Males live in the household" Boolean expression("Sum(Person.(Gender = {male})) > 0") or an expression that references the level ID (for example a derived grid such as LikesOurBrand "Respondent likes our brand" Boolean expression("LevelID = {OurBrand} And Rating * {VGood, Excellent}") is not supported.
You can choose to export data for all the variables in the survey data file, or you can select variables to export using the Variables pane, or select particular types of variables to export.
You can also apply a filter to restrict the data to export, by setting up a global, table, or interview filter in UNICOM Intelligence Reporter before you export the data.
To export data
1 If required, set up any filtering that you want to use. You can apply a global, table, or interview filter, or any combination of these.
2 If you do not want to export all variables, use Shift+click or Ctrl+click to select the variables you do want to export in the Variables pane.
If you frequently want to export the same variables, you can add them to a folder so that they are in the same place, and then you can select them using Shift+click.
3 Click File > Export > Data.
The Export Data dialog opens.
4 In the General tab:
If the survey data file you are exporting from includes more than one language, select the language to export from the list.
Select the output file format you want to use. Depending on the file format you select, additional options might be available. For more information, see
Export Data dialog: General tab.
Enter a name for the output file. If you do not enter a file path, the file will be saved in the same folder as the survey data file. To save the file elsewhere, click Browse, and then select a folder.
5 In the Variables tab:
If you want to export all variables in the survey data file, select All variables.
If you want to export the variables you have selected in the Variables pane, select Variables currently selected in the variable list. To see a list of the selected variables, click View selection.
If you want to export all variables of a particular type, for example, all categorical variables, select Specific types of variables, and check the relevant boxes.
Choose whether to include system variables. You can choose common system variables or all system variables.
Choose which variables should be exported for the axis variable.
6 In the Filters tab, choose the filter or filters to apply to the data before it is exported. Only the data that passes the filters will be exported.
7 Click OK to export the data.
See also