Skip to main content

Move dataset columns and rows

A dataset is a visual representation of columns and rows in CDASH domains based on the configuration of forms. Each column in the dataset represents a CDASH variable that captures data in corresponding rows as per record ID settings. In Study Designer, a dataset is not the actual data storage as it serves solely to show how data is structured when entered in forms of the EDC system.

Any of the columns or rows can be moved to a different location within a CDASH domain in the dataset. The changes in the dataset structure are applied to ensure that the data remains organized and coherent after it is collected in EDC.

Tip

Each column is associated with a CDASH variable. Each row in the dataset displays what responses are to be captured when entered in EDC since a single variable can be associated with many questions across different forms.

To move columns and rows within a dataset

  1. In the Study Designer application header, select the CRF DESIGN tab.

  2. In the toolbar, select the latest draft CRF version marked with the respective unlock symbol unlocked_icon_purple.png, otherwise, you cannot perform any actions.

    Selecting latest draft CRF version
    Figure 1. Selecting latest draft CRF version

  3. From the workspace toolbar of the hierarchy tree, select Dataset icon_datasets.png.

    Accessing dataset page
    Figure 2. Accessing dataset page

  4. In the left pane of the page that opens, select the domain whose columns or rows you want to move.

  5. In the content panel that appears, do one of the following:

    • Move a column: in the table header, open More icon_more_actions.png next to the needed variable and then select any of the available options to move the column in the necessary direction.

      Moving column
      Figure 3. Moving column

    • Move a row: in the first column, open More icon_more_actions.png next to the needed row and then select any of the available options to move the row in the necessary direction.

      Moving row
      Figure 4. Moving row

Once selected, the column or row is moved to another location within the dataset domain.

In this section:

A specific area or category of data within a clinical trial that encompasses a set of related variables that share a common theme. Each domain organizes data to facilitate analysis and reporting, ensuring that information is structured and easily interpretable.

For example, in a clinical trial, domains might include demographics, efficacy, safety, and laboratory results.

An eClinical application that is mainly used to collect and manage subject data during clinical trials. It integrates with the Study Designer (SD) application and uses preconfigured there case report forms (CRFs) to complete data collection and management. It also provides an audit trail, data alert, source data verification (SDV), payment management, adjudication, and other functions as well as supports data export according to the CDISC ODM standard.

Get to know all the possibilities of the app with the comprehensive EDC User Guide.