...
It is necessary to select which version of the study to export. If multiple sites/subjects are on different versions, they will need to be exported separately. The reason exports are separated by version, is due to the extensive study design changes that can be made from one version to the next. Combining versions into a single export would lead to an inaccurate reflection of data.
...
The Metadata and Data export option combines combine both the Metadata and Data in one ODM export file. The data can be downloaded by clicking the Click Here to Export Both Metadata and Data To ODM link as shown in the figure below.
SAS XML Export
The SAS XML (Xtensible Markup Language) format is used when you want to load the study data into SAS. SAS users will also want to use the XML MAP (discussed below) so SAS does not try to automap data types in the XML file. If using a SAS universal viewer, the SAS XML file will not be read. A full version of SAS, on the other hand, is able to open and map SAS XML.
To view the dataset without the full version of SAS software, SAS has an XML Mapping application as a free download that can be used to view the datasets. Just be aware, without a fully licensed version of SAS software, the SAS XML can only be viewed using the mapping application. Navigate to the external SAS download page for this application.
XML Export
The XML export provides an XML document that can be used by other products that support or process XML Documents. It can also be used to create a SAS data set using SAS’s XML Engine with the help of an XML MAP file.
...
The XML Map export is an XML document that provides the capability for a SAS program to read an XML file into a collection of SAS Data Sets. This XML MAP file only works with the XML File downloaded from Clinical Studio’s XML format. The XML Map file can be downloaded by clicking the Click Here to Export XML MAP link as shown in the figure below.
IBM SPSS Export
The IBM SPSS format provides a binary data file (sav format) that can be used by IBM’s SPSS (Statistical Package for the Social Sciences) program or GNUS PSPP (http://www.gnu.org/software/pspp/) program for statistical analysis. The exported file is a zipped collection of all the CRFs in the study. The zipped sav files can be downloaded by clicking the Click Here to Export to SPSS SAV link as shown in the figure below.
Excel
This downloads a single Excel file workbook with each dataset (form) included as a worksheet within.
CSV
This downloads a zip file that includes separate dataset files for every form in the study.
Clicking on any export link will start the export and display the progress in the Export Progress bar. In most cases, this should only take a few seconds. Once it's complete, the download will go immediately to your downloads folder or wherever you have set the computer to place downloads.
| Info |
|---|
Blank data is blank in data extracts. You will not see NULL or any other alternative. |
A note about Date and Time formatting:
The format of dates and times is dependent on the preferences of the user who is executing the export. User preferences can be temporarily changed if needed to export data with dates in a different format.
File Repository Information
Files uploaded on forms can be separately exported from the file repository. The data exports will only contain the file name if the field type is a file upload field.
Background CSV exports will include a “doc_id” column to the right of the file upload column. This contains the system the system's unique file ID that is also seen in the file repository, to help with identifying files.
...