Data Entry/Review module

Exporting subject data with SPSS Export report

The SPSS Export report is a standard report that enables you to export subject data in a format suitable for import into SPSS. The report must be configured in the REP module to display as a link on the Data Entry home page.

Other subject data export options are available in the System Management module.

To run the report:

1. From the DE home page, click on the report link (the exact name is specified during configuration)

2. Click on the study you want to report on. Only studies that you have permission to access are displayed.

3. Click Export for the site you want to report on.

4. Enter substitute values for missing data More info

   If a question has data missing, it will have been assigned one of three statuses; Missing, Not Available or Not Applicable. If you want to identify these in your report, you must specify a code for each status so that it might be displayed. Numbers from -1 to -999 are accepted. The values you enter will be inserted where applicable both on screen and in any output you save.

    

   You can click Check Values to scan the subject data for any occurrences of the substitute values in actual responses. The format of integer and real MACRO questions is taken into account, for example, a substitute value of -88 is considered equal to -88.0 and 0088.

   If any occurrences are found they are displayed. You should replace any occurring substitute values with numbers that are not present as real data.

    

   It is not possible for values -1 to -999 to be inserted in a date field so if a date question has a full date format and does not have the 'Allow partial dates' flag set, the following fixed dates will be automatically inserted for missing values:

    

   Missing data is exported as 09-09-1900 or 1900-09-09

   Not Applicable data is exported as 07-07-1700 or 1700-07-07

   Unobtainable data is exported as 08-08-1800 or 1800-08-08

    

   When exporting to SPSS, the date format is the same as that entered into the DE module. When exporting to CSV, the date format is the same as that specified in the study definition.

    

   If a date question has a partial date format OR has the 'Allow partial dates' flag selected, the missing value will be output as the specified substitute value (-1 to -999).

    

5. To view the report onscreen before saving to a file, click Display. See example Please note that this option is not suitable for displaying large amounts of data as the web browser may timeout, or display ‘buffer full’ messages.

    

   

    

6. To save in SPSS format, click Download SPSS and choose to open or save the 'SPSSexport_studyname_site.txt' file. See example

    

   

    

7. To save in CSV format, click Download CSV and choose to open or save the 'CSVexport.txt' file. See example

    

   

    

The report displays all unique Visit/eForm/Question combinations of subject data for the selected site, including multiple repeats.

The full number of export columns is used for every subject, even if data is not available for all the columns. When more data is entered in the database, and new unique combinations of Visit/Form/Question become available, the report will automatically add these new columns. Since the new columns will appear in logical order in the export file, all operations on the generated dataset should use column headers, not column numbers.

Data values are separated by the vertical bar (|) character. The last data value on each line is ended with a vertical bar (|) character.

Data rows longer than 150 characters are split over several lines.

Text data is not enclosed in quotes

Mapping of data between MACRO and SPSS

Date values are exported as follows:

Related Topics

Running home page reports

Enabling the home page

Adding items to the home page

Standard reports