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.
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:
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.
See the JMP Parallel Plot platform for more information.
See the JMP Hierarchical Clustering platform for more information.
•
|
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.
|
•
|
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 the Options arrow to reopen the completed report dialog used to generate this output.
|
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.
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.
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.
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.
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.
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.