The JMPC_ Internal Model Variables Table
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.
Note: When generating the JMPC_ internal model variables, the ADaM variable(s) always take precedence over their SDTM equivalents.
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. |
JMPC_ Variable Name | Variable Type | Description |
---|---|---|
JMPC_EXSTDTC | Character |
Earliest non-missing value of EXSTDTC per subject. This variable is added only to the TADSL data table. |
JMPC_EXSTDTM | Numeric |
Numeric datetime version of JMPC_EXSTDTC. This variable is created only if EXSTDTC is datetime (has time). This variable is added only to the TADSL data table. |
JMPC_EXSTDT | Numeric |
Numeric date version of JMPC_EXSTDTC. It is added only to the TADSL data table. |
JMPC_EXENDTC | Character |
Latest non-missing value of EXENDTC per subject. EXSTDTC is used if EXENDTC is missing. This variable is added only to the TADSL data table. |
JMPC_EXENDTM | Numeric |
Numeric datetime version of JMPC_EXENDTC which only gets created if EXENDTC is datetime (has time). EXSTDTC is used if EXENDTC is missing. This variable is added only to the TADSL data table. |
JMPC_EXENDT | Numeric |
Numeric date version of JMPC_EXENDTC. EXSTDTC is used if EXENDTC is missing. This variable is added only to the TADSL data table. |
JMPC_TREATMENTSTARTDATE | Numeric |
This is the anchor date that gets used in study day calculation. If Use treatment start date was selected for anchor date under Advanced options, then we verify the existence of the following variables in this order: TRTSDTM, TRTSDT, RFXSTDTC, JMPC_EXSTDTM, JMPC_EXSTDT. The first variable that exists and has non-missing values is used to create JMPC_TREATMENTSTARTDATE. If Use reference start date was selected under Advanced options, then RFSTDTC is used as JMPC_TREATMENTSTARTDATE. This variable is added only to the TADSL data table. |
JMPC_TREATMENTENDDATE | Numeric |
The existence of the following variables is verified in this order: TRTEDTM, TRTEDT, RFXENDTC, JMPC_EXENDTM, JMPC_EXENDT, RFENDTC. The first variable that exists and has non-missing values is used to create JMPC_TREATMENTENDDATE. This variable is added only to the TADSL data table. |
JMPC_ALSBFL | Character |
All Subjects population flag variable. It has a value of Y for all subjects. This variable is added to the ADSL, DM, and TADSL data tables. |
JMPC_ALSBXSFL | Character |
All Subjects Excluding Screen Failures population flag. It has a value of Y for all subjects that are not screen failures, and a value of N for screen failures. ARM/ARMCD and ARMNRS variables are used to identify Screen Failures. It gets added to the ADSL, DM, and TADSL data tables. |
JMPC_SAFFL | Character |
Safety Population Flag This variable is created by checking the existence of the following ADSL/DM variables in this order: SAFFL, SAFETY. The first variable that exists and has non-missing values is used to create JMPC_SAFFL. If the values are 1 and 0 instead of Y and N, then 1 is converted to Y and 0 to N. |
JMPC_COMPLFL | Character |
Completers Population Flag This variable is created by checking the existence of the following ADSL/DM variables in this order: COMPLFL, COMPFL, COMPLT, COMPLETED. The first variable that exists and has non-missing values is used to create JMPC_COMPLFL. If the values are 1 and 0 instead of Y and N, then 1 is converted to "Y" and 0 is converted to N. |
JMPC_ENRLFL | Character |
Enrolled Population Flag This variable is created by checking the existence of the following ADSL/DM variables in this order: ENRLFL, ENRL, ENROLLED. The first variable that exists and has non-missing values is used to create JMPC_ENRLFL. If the values are 1 and 0 instead of Y and N, then 1 is converted to "Y" and 0 is converted to N. |
JMPC_FASFL | Character |
Full Analysis Set Population Flag. This variable is created by checking the existence of the following ADSL/DM variables in this order: FASFL, FULLSET. The first variable that exists and has non-missing values is used to create JMPC_FASFL. If the values are 1 and 0 instead of Y and N, then 1 is converted to "Y" and 0 is converted to N. |
JMPC_ITTFL | Character |
Intent-to-Treat Population Flag. This variable is created by checking the existence of the following ADSL/DM variables in this order: ITTFL, ITT. The first variable that exists and has non-missing values is used to create JMPC_ITTFL. If the values are 1 and 0 instead of Y and N, then 1 is converted to "Y" and 0 is converted to N. |
JMPC_PPROTFL | Character |
Per-Protocol Population Flag. This variable is created by checking the existence of the following ADSL/DM variables in this order: PPROTFL, PPROT. The first variable that exists and has non-missing values is used to create JMPC_PPROTFL. If the values are 1 and 0 instead of Y and N, then 1 is converted to "Y" and 0 is converted to N. |
JMPC_RANDFL | Character |
Randomized Population Flag. This variable is created by checking the existence of the following ADSL/DM variables in this order: RANDFL, RAND, RANDOMIZED, RANDOM. The first variable that exists and has non-missing values is used to create JMPC_PPROTFL. If the values are 1 and 0 instead of Y and N, then 1 is converted to "Y" and 0 is converted to N. |
JMPC_PARAM | Character |
If the ADaM PARAM variable exists, then the values of PARAM are used to create JMPC_PARAM. If the ADaM PARAM variable does not exist, the SDTM variables XXTEST, XXCAT, XXSCA, XXSPEC, XXMETHOD, XXLOC, XXPOS, XXSTRESU/XXORRESU. are concatenated to createJMPC_PARAM. Note: Only the values of XXTEST are used to create JMPC_PARAM for SDTM TU, TR, and RS domains. |
JMPC_PARAMCD | Character |
If the ADaM PARAMCD variable exists, then the values of PARAMCD are used to create JMPC_PARAMCD. If the ADaM PARAMCD variable does not exist, the SDTM variables XXTESTCD, XXCAT, XXSCAT, XXSPEC, XXMETHOD, XXLOC, XXPOS, XXSTRESU/XXORRESU are concatenated to createJMPC_PARAM. Note:Only the values of XXTESTCD are used to create JMPC_PARAMCD for SDTM TU, TR, and RS domains |
JMPC_PARCAT1 | Character |
If the ADaM PARCAT1 variable exists, then the values of PARCAT1 are used to create JMPC_PARCAT1. If the ADaM PARCAT1 variable does not exist, the SDTM variable XXCAT is used to create JMPC_PARCAT1. |
JMPC_AVAL | Numeric |
If the ADaM AVAL variable exists, then the values of AVAL are used to create JMPC_AVAL. If the ADaM AVAL variable does not exist, the standard or original results (XXSTRESN/XXORRES) from SDTM are used, based on which Advanced option isselected during the Add Study... process. |
JMPC_AVALC | Character |
If the ADaM AVALC variable exists, then the values of AVALC are used to create JMPC_AVALC. If the ADaM AVALC variable does not exist, the standard or original results (XXSTRESC/XXORRES) from SDTM are used, based on which Advanced option isselected during the Add Study... process. |
JMPC_AVISIT | Character |
AVISIT/VISIT is used to create JMPC_AVISIT. If the domain contains only a numeric visit variable, then ADSV/SV is used to look up the character visit values. If there is a visit variable in DM/ADSL, then JMPC_DMVISIT/JMPC_ADSLVISIT is created. |
JMPC_AVISITN | Numeric |
AVISITN/VISITNUM is used to create JMP_AVISITN. If the domain contains only a character visit variable, then ADSV/SV is used to look up the numeric visit values. If there is a visit number variable in DM/ADSL, then JMPC_DMVISITN/JMPC_ADSLVISITN is created. |
JMPC_RFSTDTM | Numeric |
RFSTDTC is used to create JMPC_RFSTDTM. This variable is created only created if RFSTDTM has both date and time values. |
JMPC_RFSTDT | Numeric |
RFSTDTC is used to create JMPC_RFSTDT. This variable is created only created if RFSTDT has date (but not time) values. |
JMPC_RFENDTM | Numeric |
RFENDTC is used to create JMPC_RFENDTM. This variable is created only created if RFENDTMhas both date and time values. |
JMPC_RFENDT | Numeric |
RFENDTC is used to create JMPC_RFENDT. This variable is created only created if RFENDTM has date (but not time) values. |
JMPC_RFXSTDTM | Numeric |
RFXSTDTC is used to create JMPC_RFXSTDTM. This variable is created only created if RFXSTDTMhas both date and time values. |
JMPC_RFXSTDT | Numeric |
RFSTDTC is used to create JMPC_RFXSTDT. This variable is created only created if RFXSTDTMhas date (but not time) values. |
JMPC_RFXENDTM | Numeric |
RFXENDTC is used to create JMPC_RFXENDTM. This variable is created only created if RFXENDTMhas both date and time values. |
JMPC_RFXENDT | Numeric |
RFXENDTC is used to create JMPC_RFXENDT. This variable is created only created if RFXENDTMhas date (but not time) values. |
JMPC_RFPENDTM | Numeric |
RFPENDTC is used to create JMPC_RFPENDTM. This variable is created only created if RFPENDTMhas both date and time values. |
JMPC_RFPENDT | Numeric |
RFPENDTC is used to create JMPC_RFPENDT. This variable is created only created if RFPENDTM has date (but not time) values. |
JMPC_ADT | Numeric |
This variable is generated from either the ADaM ADT/ADTM or the SDTM XXDTC variables. If the date variable is in DM/ADSL, then JMPC_DMDT/JMPC_ADSLDT is created. |
JMPC_ADTM | Numeric |
This variable is generated from either the ADaM ADTM or the SDTM XXDTC variables. This variable is created only when the original variable has both date and time values. If the datetime variable is in DM/ADSL, then JMPC_DMDTM/JMPC_ADSLDTM gets created. |
JMPC_ASTDT | Numeric |
The ADaM ASTDT/ASTDTM or the SDTM XXDTC is used to create this variable. If the date variable is in DM/ADSL, then JMPC_DMSTDT/JMPC_ADSLSTDT is created. |
JMPC_ASTDTM | Numeric |
This variable is generated from either the ADaM ASTDTM or the SDTM XXDTC variables. This variable is created only when the original variable has both date and time values. If the datetime variable is in DM/ADSL, then JMPC_DMSTDTM/JMPC_ADSLSTDTM gets created. |
JMPC_AENDT | Numeric | The ADaM AENDT/AENDTM or the SDTM XXDTC is used to create this variable. |
JMPC_ADTM | Numeric |
This variable is generated from either the ADaM AENDTM or the SDTM XXDTC variables. This variable is created only when the original variable has both date and time values. |
JMPC_ADY | Numeric |
This variable is generated from either the ADaM ADY or the SDTM XXDY variables. When there is no study day variable, then this variable is calculated using the domain’s date variable and the anchor date specified for study day calculation (treatment start date/reference start date). Even if a study day variable is present, users can choose the option to recalculate the values. If there is a study day variable in DM/ADSL, then JMPC_DMDY/JMPC_ADSLDY gets created. |
JMPC_ASTDY | Numeric |
This variable is generated from either the ADaM ASTDY or the SDTM XXSTDY variables. If there is no start study day variable, then this variable is calculated using the domain’s start date variable and the anchor date specified for study day calculation (treatment start date/reference start date). Even if end study day variable is present, users can choose the option to recalculate the values. If there is a study start day variable in DM/ADSL, then JMPC_DMSTDY/JMPC_ADSLSTDY gets created. |
JMPC_AENDY | Numeric |
This variable is generated from either the ADaM AENDY or the SDTM XXENDY variables. If there is no end study day variable, this variable is calculated using the domain’s end date variable and the anchor date specified for study day calculation (treatment start date/reference start date). Even if end study day variable is present users can choose the option to recalculate the values. |
JMPC_ATPT | Character | This variable is generated from either the ADaM ATPT or the SDTM XXTPT variables. |
JMPC_ATPTN | Numeric | This variable is generated from either the ADaM ATPTN or the SDTM XXTPTN variables. |
JMPC_ANRLO | Numeric |
This variable is generated from either the ADaM ANRLO or SDTM XXSTNRLO/XXORNRLO variables. If the data is SDTM, then standard or original reference ranges are loaded based on which option was selected for Test Results under Advanced options when the study was added. |
JMPC_ANRLOC | Character |
This variable is generated from either the ADaM ANRLOC or SDTM XXSTNRLOC/ XXSTNRLO/XXORNRLO variables. If the data is SDTM, then standard or original reference ranges are loaded based on what was selected for Test Results under Advanced options when the study was added. |
JMPC_ANRHI | Numeric |
This variable is generated from either the ADaM ANRHI or SDTM XXSTNRHI/XXORNRHI variables. If the data is SDTM, then standard or original reference ranges are loaded based on what was selected for Test Results under Advanced options when the study was added. |
JMPC_ANRHIC | Character |
This variable is generated from either the ADaM ANRHIC or SDTM XXSTNRHIC/ XXSTNRHI/XXORNRHI variables. If the data is SDTM, then standard or original reference ranges are loaded based on what was selected for Test Results under Advanced options when the study was added. |
JMPC_ANRIND | Character |
This variable is generated from either the ADaM ANRIND or SDTM XXNRIND variables. If there is no normal reference range indicator variable, then the value is imputed using the test result value and the lower and upper reference range values. In this case JMPC_ANRIND gets populated with the following values: NORMAL, LOW, and HIGH. |
JMPC_ABLFL | Character | This variable is generated from either the ADaM ABLFL or SDTM XXBLFL variables. |
JMPC_ASEV | Character | The ADaM ASEV or SDTM XXSEV is used to create this variable. |
JMPC_ATOXGR | Character | This variable is generated from either the ADaM ATOXGR or SDTM XXTOXGR variables. |
JMPC_ATOXGRSEV | Character | First we look for ATOXGR/xxTOXGR and if it is missing, then we use the values of ASEV/xxSEV. |
JMPC_TRTEMFL | Character | This variable is generated from either the ADaM TRTEMFL or SDTM XXTRTEM variables. |
JMPC_ACN | Character |
This variable is generated from the AEACN variable. If we are dealing with a multiple treatment study, then multiple JMPC_ACN variables are created in this form JMPC_ACN_<treatment x>. The name of the treatment is extracted from the label. |
JMPC_AREL | Character |
The ADaM AREL or SDTM AEAREL is used to create this variable. If we are dealing with a multiple treatment study, then multiple JMPC_AREL variables are created in this form JMPC_AREL_<treatment x>. The name of the treatment is extracted from the label. |
JMPC_APERIOD | Numeric |
This variable is added to findings/events/interventions domains for crossover studies. If APERIOD exists in the data, then the values of APERIOD are used. If it doesn't exist, then the treatment start date ADSL variables (TRTxxSDTM/TRTxxSTDT) are used to assign a numeric value to JMPC_APERIOD. The pre-treatment findings/events/interventions are assigned a value of 0. |
JMPC_TRTA | Character |
This variable is added to findings/events/interventions domains for crossover studies. If TRTA exists in the data, then the values of TRTA are used. If it doesn't exist, then the treatment start date (TRTxxSTDM/TRTxxSTDT) and planned treatment period (TRTxxP) ADSL variables are used to identify in which planned treatment period the finding/event/intervention occurred. |
JMPC_TRTP | Character |
This variable is added to findings/events/interventions domains for crossover studies. If TRTP exists in the data, then the values of TRTP are used. If it doesn't exist, then the treatment start date (TRTxxSTDM/TRTxxSTDT) and actual treatment period (TRTxxA) ADSL variables are used to identify in which actual treatment period the finding/event/intervention occurred. |