Reports | Create Cross Domain Data

Create Cross Domain Data
This report adds data for various domains to the adsl.sas7bdat table corresponding to incidence of variables in the AE, CM, LB, and MH domains and a summary statistic for LB, EG, and VS domain values. The report converts all character variables with values N and Y to numeric variables with values 0 and 1, respectively. The resulting output data set is suitable for pattern discovery and predictive modeling. A transposed version of the data set is also produced. Both versions are useful for clustering.
Report Results Description
Running this report with the Nicardipine sample setting generates the Results shown below. Output from the report is organized into sections. Each section contains one or more plots, data panels, data filters, or other elements that facilitate your analysis.
The Create Cross Domain Data report initially shows two sections Indicators and Statistics. Use the available options in each section to drill-down into the data.
Hierarchically clusters all binary indicator variables. A separate section is created for each domain (ADSL (Subject Level), Concomitant Medications (CM), Adverse Events (AE), Disposition (DS), and Medical History (MH)) that has binary variables, depending on the options selected. The binary variables are converted to 0s and 1s and clustered.
The AD Indicators section is shown below:
An Indicator section contains the following elements:
A two-way hierarchical clustering analysis of the 0-1 variables, with subjects as rows and indicator variables as columns.
You can study the Heat Map and Dendrogram to see both subjects that have similar values of the binary variables as well as binary variables that are similar across subjects.
See the JMP Hierarchical Clustering platform for more information.
Hierarchically clusters a statistic computed on continuous variables. A separate section is created for each domain (ECG Test Results (EG), Laboratory Test Results (LB), and Vital Signs (VS)) that has continuous variables.
The EG Max section is shown below:
Statistics sections contains the following elements:
This shows a Parallel Plot of the computed statistic for each variable in the domain. Each line in the plot corresponds to a subject. In the example above, the max statistic is plotted for four variables. The coloring of the lines comes from the hierarchical clustering analysis of the first numeric domain.
You can study this plot to determine trends across variables as well as outlying subjects.
See the JMP Parallel Plot platform for more information.
This displays a two-way clustering analysis of the statistic across all variables and subjects.
You can study this plot to determine numeric measurements that are similar across subjects and/or subjects that are similar across numeric measurements.
See the JMP Hierarchical Clustering platform for more information.
Output Data
This pane provides links to the following output data sets:
Transposed Subject Data (adsl_cddt.sas7bdat): This data set is the transpose of the main output table. The transposed table has domain data identifiers as rows and subjects as columns.
Action Buttons
Action buttons, provide you with an easy way to drill down into your data. The following action buttons are generated by this report:
Profile Subjects: Select subjects and click to generate the patient profiles. See Profile Subjects for additional information.
Show Subjects: Select subjects and click to open the ADSL (or DM if ADSL is unavailable) of selected subjects.
Demographic Counts: Select subjects and click to create a data set of USUBJIDs, which subsets all subsequently run reports to those selected subjects. The currently available filter data set can be applied by selecting Apply Subject Filter in any report dialog.
Click to generate a standardized pdf- or rtf-formatted report containing the plots and charts of selected sections.
Click to read user-generated notes. Refer to View Notes for more information.
Click the Options arrow to reopen the completed report dialog used to generate this output.
Click the gray border to the left of the Options tab to open a dynamic report navigator that lists all of the reports in the review. Refer to Report Navigator for more information.
Report Options
Indicator Variables
Indicator variables are binary variables whose values 1 and 0 respectively indicate a Yes or No response.
Use the indicator variable options to generate additional variables that indicate whether specific Interventions have been made, specific Events have occurred, and/or High and Low Labs results have been observed. In addition, indicator variables can be created for Binary Variables in ADSL as well as Character Findings in SDTM.
Note: If you choose to create indicator variables for High and Low Labs, you must also specify the Multiplier for Upper Normal Limit and the Divisor for Lower Normal Limit below.
Use the Cluster subjects option to perform subject-level clustering for each domain.
Filtering the Data:
Filters enable you to restrict the analysis to a specific subset of subjects based on values within variables. You can also filter based on population flags (Safety is selected by default) within the study data.
See Select the analysis population, Select saved subject Filter1, Additional Filter to Include Subjects, and Subset of Visits to Analyze for Findings for more information.
Time Windows
By default, time is measured by visits. However, you can change the Time Scale to measure time in either weeks or days. This option is useful for assessing report graphics for exceptionally long studies.
When analyzing findings results by either days or weeks instead of by visit, you must specify the start and end days for each of one or more time windows. Trial Time Windows are defined blocks of time within the study where findings results are considered in a single time point regardless of where within the window, they were collected.
The term levels are determined by the coding dictionary for the Event domain of interest; typically these levels follow the MedDRA dictionary. You must indicate how each adverse event is named . For example, selecting Reported Term as the Term Level reports the event specified by the actual event term as reported in the AE domain.
Summary Statistics
Select the Create summary statistic variables for numeric findings to generate a new column containing the specified Summary Statistic for Findings Data for the numeric findings in each of the selected findings domains. Available summary statistics include Mean, Median, Maximum, Minimum, and Last Recorded Value.
By default, JMP Clinical reports unaltered laboratory measurement values. In any cases, simply examining the raw numbers can make interpretation somewhat confusing. Normalization of Lab Measurements to accepted values can often ease these difficulties. JMP Clinical offers three options for normalizing your data.
Selecting LLN normalizes the data to the lower limit of the expected normal range and is best used when you expect the values to fall below the normal. Normalized values less than one are considered to be lower than normal.
Selecting ULN normalizes the data to the upper limit of the expected normal range and is best used when you expect the values to exceed the normal range. Normalized values greater than one are considered to be higher than normal.
Selecting Geometric normalizes the data such that the lower limit of the expected normal range is set to -1 and the upper limit of the expected normal range is set to +1. This method is best used when there is no expectations of where the values might fall. Normalized values less than -1 are considered to be lower than normal while values greater that +1 are higher than normal.
Log transformations can make certain response distributions closer to Gaussian with constant variance and can enable you to draw more accurate statistical conclusions under standard modeling assumptions. They are especially useful for ratio-type measurements or measurements that are always positive and skewed to the right. You can use the log Transformation of Lab Measurements options to either use non-transformed data or to log2- or log10-transform your measurements.
High and Low Labs
Use the Multiplier for Upper Normal Limit and Divisor for Lower Normal Limit options to define the range above and below which findings results are considered abnormally high or low, respectively.

Subject-specific filters must be created using the Create Subject Filter report prior to your analysis.