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.