Custom Medical Query Risk Report
This report calculates risk measurements for custom medical queries defined in the adverse events dataset. Output is a two-sided plot with a dot plot showing percent occurrence and forest plot showing risk measurement. Additionally there are 3 tables for custom medical queries with dictionary-derived terms , custom medical queries, and custom medical queries by System Organ Class (SOC). This report is used for situations in which users need to create custom medical queries instead of using standard MedDRA or FDA medical queries.
This report differs from the other query-based risk reports in that there is no external data. Instead, it uses variables found in the ADAE data set. The ADAE variables are named CQ<number>NAM, where <number> represents a 3 digit number from 0-999.
Report Results Description
Running Custom Medical Query Risk Report for the Nicardipine study generates the Report shown below.
Plots
There are two plots shown here. Medical queries are shown on the y axis. The dot plot on the left shows the percentile occurrence of subjects in each arm exhibiting the queries. The Forest plot on the right of each group shows the risk difference for subjects to exhibit events covered by each query.
Forest Plots display relative strength of treatment effects as horizontal lines representing the 95% confidence interval of the effect observed in that trial. The confidence interval is normally for the relative likelihood of a given nominal-level outcome for the intervention group compared to the control group. In this example, the forest plot shown below, represents the risk difference for developing the specified event relative to exposure to Nicardipine.
Note: When you select either Relative Riskor Odds Ratio as the Risk Measurement, the scale on the x-axis of the Forest plot changes from linear to a log scale.
Tables
Three tables were generated for this example.
Medical Queries and Terms
This table lists each query with its associated dictionary-derived terms, the number (percentile) of subjects exhibiting the event, and the risk difference between the treatment arms.
Medical Queries
This table summarizes each query without the associated dictionary-derived terms for the number (percentile) of subjects exhibiting the event, and the risk difference between the treatment arms.
System Organ Class
This table lists the number (percentile) of subjects exhibiting each SOC and the risk difference between the treatment arms.
Options
Data
Event Type
Analysis can consider all events or only those that emerge at specific times before, during, or after the trial period. For example, selecting On treatment events as the Event Type includes only those events that occur on or after the first dose of study drug and at or before the last dose of drug (+ the offset for end of dosing).
Ignore available treatment emergent flags
If you choose to ignore available treatment emergent flags, the analysis includes all adverse events that occur on or after day 1 of the study when the event type is Treatment emergent events.
Risk Measurement
Use the Risk Measurement, option to specify the measure you want to use for defining risk.
Display Risk Difference as:
Use this widget to specify whether to display the risk difference values as either percentages or proportions.
Sort Risk Report plot and tables by:
Use the Sort Risk Report plot and tables by: widget to specify how the rows in the Risk Report plot and tables are to be sorted.
Treatment Value for Sort by
Use this widget to specify the treatment value to sort the plots and tables by. This is especially useful when there are multiple treatment regimes. Refer to Treatment Value for Sort by for more information.
Report Data Filters
These filters enable you to subset and view subjects based on demographic characteristics and other criteria. Refer to Data Filter for more information.
General and Drill Down Buttons
Action buttons provide you with an easy way to drill down into your data. The following action buttons are generated by this report:
| • | Click  to reset all report options to default settings. |
| • | Click  to view the associated data tables. Refer to Show Tables for more information. |
| • | Click  to generate a standardized pdf- or rtf-formatted report containing the plots and charts of selected sections. |
| • | Click  to generate a JMP Live report. Refer to Create Live Report for more information. |
| • | Click  to take notes, and store them in a central location. Refer to Add Notes for more information. |
| • | Click  to read user-generated notes. Refer to View Notes for more information. |
Default Settings
Refer to Set Study Preferences for default Subject Level settings.
Methodology
Methodology
To run this report, at least two treatment levels are required, and the treatment control level preference must not be set to None.
Statistical Calculations
The Custom Medical Query Risk Report calculates risk difference, relative risk, and odds ratio using the Response Screening platform in JMP. To prepare the data for this platform, a table is created with one row per subject and one column per medical query. Each medical query column is assigned a value of 1 if the query occurred for a subject and 0 if it did not.
These medical query columns are specified in the Y, Response role, and the treatment variable is specified in the X role. The calculated values for risk difference, relative risk, and odds ratio, along with their 95% confidence intervals, are saved from the 2 by M Results table. Confidence intervals are calculated using JMP's Response Screening report. See Response Screening Report Tables for more information.
Additional information on the Response Screening platform and the resulting statistics can be found at: https://www.jmp.com/support/help/en/19.1/?os=win&source=application#page/jmp/response-screening.shtml#.