Add Study...

This study management action adds a study (see Studies) from local folders that contain CDISC-formatted data. You must add a study before you can perform the analysis. The data can be submitted as JMP data tables (.jmp files), SAS data sets (.sas7bdat files), SAS Transport Files (.xpt files), or a combination of these.

Note: If you are adding JMP data tables, then all columns must have a SAS Name column property. The columns should also have SAS Label column property, but this is optional. If SAS Label property is provided, then that is used to identify columns in the report displays.

Note: SAS data sets (.sas7bdat files) used for submission must have UTF-8 encoding.

The following table summarizes the minimum requirements of new studies.

You must specify...

...while abiding by these restrictions:

a Study Name

The study name must conform to the Rules for Study Names.

the location of either the SDTM Folderand/or the ADaM Folder

The SDTM Foldermust contain at least one domain.
The ADaM Folder must contain at least one domain.
Either DM (DM in SDTM or ADDM in ADaM) or ADSL (from ADaM) must be present.
For DM or ADSL, either the treatment start date variable or reference start date variable must be available.
For ADaM BDS Findings data, both PARAMCD and either AVAL or AVALC must be present.
Data sets can either be JMP data tables, SAS data sets, SAS Transport Files, Dataset-JSON files or a combination of these.
The same folder cannot be specified in the SDTM Folderand ADaM Folder fields.
The file path to these folders must conform to the Rules for Paths

The study and associated metadata are added to your database.

To Add a Study

8 Click to open the dialog:

8 Specify the desired options and click .

The following options are available. Links to specific documentation for each of the options are provided in the following table:

Options

Information

Study Name

The study name must conform to the Rules for Study Names.

SDTM Folder

Use the text box to specify the location and name of the folder.
The SDTM Folder must contain at least one domain.
DM must be present.
For ADaM BDS Findings data, both PARAMCD and either AVAL or AVALC must be present.
Data sets can either be JMP data tables, SAS data sets or SAS Transport Files or a combination of these.
The same folder cannot be specified in the SDTM Folder and ADaM Folder fields.
Selected SDTM Domains

This option is used when there are multiple SDTM domain files in the same folder.

Use this option to specify the SDTM domains to be added to the study. If you leave this option blank, all SDTM domains in the folder are added to the study.

ADaM Folder

The ADaM Folder must contain at least one domain.
Either ADDM or ADSL must be present.
Data sets can either be JMP data tables, SAS data sets or SAS Transport Files or a combination of these.
The same folder cannot be specified in the SDTM Folder and ADaM Folder fields.
Selected ADaM Domains

This option is used when there are multiple ADaM domain files in the same folder.

Use this option to specify the ADaM domains to be added to the study. If you leave this option blank, all SDTM domains in the folder are added to the study.

Load Only

This setting applies to Findings results submitted in SDTM.

Choose to import either:

Results in standard units (data is imported from xxSTRESNor xxSTRESC).
Results in original units (data is imported from xxORRES).
Start Date Imputation Method:
Use Start Date Imputation Method to specify whether to use the first moment rule or last moment rule for deriving missing values in the variable indicating the starting day of an event/finding/intervention.
End Date Imputation Method:
Use End Date Imputation Method to specify whether to use the first moment rule or last moment rule for deriving missing values in the variable indicating the ending day of an event/finding/intervention.
Value Derivation
The Value Derivation widget enables you to derive values for any missing study day data or to rederive all study day values across the study, replacing any existing values
Anchor Date for Study Day Calculation
Use Anchor Date for Study Day Calculation to specify the variable to use for specifying the anchor date for deriving study days for each subject..

Make this the current study

Checking this box makes your study the default study for all reports. This option is checked by default.
Close this window after adding study
Checking this box closes the Add Study window once the study has been added.. This option is checked by default.

Note: When adding a clinical study and assigning both ADAM and SDTM domains, the ADAM equivalent of each domain is added and the corresponding SDTM data set excluded. For example, if both ADAE and AE are present, then ADAE takes precedence and is included, whereas AE is not included.

Note: Any SDTM SUPP-- domains are merged into their parent domain.

Note: If some data files cannot be processed, they are excluded from the study. The name of these files with the reason why they were excluded is then listed in the Included and Excluded Domains pdf file.

Note: Empty columns are removed from each domain. The list of these excluded columns is then listed in the Excluded Variables pdf file.

Note: You should make sure that JMP Show Alternate Column Name preference (File > Preferences > Tables > Show Alternate Column Name)is not checked. If checked, this option results in the original column names, such as USUBJID, being lost when the study is added.

Example: Adding the Nicardipine Study

JMP Clinical ships with the data from a Nicardipine study. The data files are located in the Sample Data in your Installation directory (typically C:\ProgramData\SAS\JMPClinical\17\Clinical\Sample Data\Nicardipine for Windows machines and /Library/Application Support/JMP/17/Clinical/Sample Data for MACs). In this example, we add a clinical study we call Nic1.

Note: The C:\ProgramData\ directory may be hidden by default. Click View > Show > Hidden Items to view.

8 Click to open the Add Study dialog.
8 Specify the name of the study.
8 Specify the file paths to the SDTM and ADaM folders either by typing the path directly or clicking and navigating to the folders.
8 Accept default setting for all other options.

The completed dialog appears as follows:

8 Click to add the study.

When the add study process is complete, the following Results window appears.

When a study has been successfully added, the new study appears in the Studies window.

The Internal Data Model

During the Add Study process, a number of variables from the imported data sets are used to construct a new set of internal JMPC_ variables. These analysis-ready variables follow the ADaM standards and they are used in calculations and displays by the reports. Some of these variables only get added to the TADSL data table which is an internal subject-level data table that is a merge of ADSL and DM, if both exist. For those cases in which a variable exists in both ADSL and DM, the ADSL variable takes priority over the DM variable. If ADSL is present, but DM is not, TADSL is based only on ADSL. Conversely, if DM is present but ADSL is not, then TADSL is only based on DM.

The JMPC_ variables have the following column properties:

SAS Name – same as column name.
SAS Label – the label of the original variable is used. If the variable was derived and multiple variables were used to create the variable, then the standard ADaM label is used.
Origin – this is the list of the original variable(s) that was/were used to create the JMPC_ variable.

Refer to The JMPC_ Internal Model Variables Table for the names and descriptions of all JMPC_ variables.