Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The data Analysis dataset (ADaM) is created from the SDTM examples for ejection fraction can be used for multiple endpoint analysescollected data stored in SDTM. It should have full traceability back to the input datasets. For this example we show the following endpoints:

  • From CV domain
    • Percent change in ejection fraction
    • Decline in ejection fraction over a time period (yearly) grouped by a decline greater than x.x%.
  • From the LB domain
    • Percent change in NTproBNP over a period of time (yearly).

The SDTM examples example datasets from which this data is drawn are in the section "Basic CMR tests -Systolic Function" (make link) . The example datasets show visits 1 and 6 for one subject. As mentioned in the SDTM text, for the purposes of this example, the participant was enrolled in the study on 20-May-2021 and the study visits were every two months months. Visit 1 represents the visit at day 1 of the study, and visit 6 represents the visit at month 12 of the study. The associated laboratory test, N-Terminal ProB-type Natriuretic Peptide, is used in conjunction with ejection fraction as a biomarker and is important for diagnosis and treatment. It is also used separately to identify the percent change over a period of time.

The analysis dataset also includes treatment and demographic information drawn from the ADSL. In this example, we only show some of the required variables plus important stratification variables from ADSL. One variable mentioned body surface area (BSA), can be computed and added to ADSL. However, since the subjects are children their body surface area changes over time. Therefore it would probably be better to have a separate dataset to capture this. In this example, we will show one variable for BSA with the label "BASELINE Body Surface Area".


Questions. 

Is screening considered visit 1, or is it to include the subject into the study? SDTM team agreed to change to VISIT 1 instead of SCREENING.

Are these Real World Evidence (RWE) studies only or clinical trials?

Should both endpoints be shown in one efficacy dataset or two?  I will be showing 3 datasets.

bWhat is a good surface area to use for the child subject?

Should i use Male and 6 years? please advise.

Analysis Datasets

Below is the table of analysis datasets and unique parameters created for the example. The ADSL is required as part of the process of creating the subsequent analysis datasets.

ADCVEF is a dataset capturing only the tests required for this analysis, selecting for CVTESTCD equal to "LVEF_C" or "LVCO".  The relationship dataset RELREC is merged in with ADCVEF in preprarion to add the tests from LB to the efficacy dataset.
ADLBNTRP is a subset of LB selecting for LBTESTCD  equal to "BNPPRONT", and LBLINKID not missing. In this case, many lab draws may occur throughout the year, but we are only interested in the ones linked to a specific visit.

ADCMRI is an efficacy analysis dataset with only a few records for more complex modeling of changes in ejection fraction plus the ProB-type test results. It is a Basic Structure dataset with additional variables added from ADCVEF.

Definexmltable
Multipletrue
LevelDataset
PurposeAnalysis

Dataset Name

Dataset Description

Class of Dataset

Structure

Location

Keys

Documentation

ADSL

Subject-Level Analysis Dataset

SUBJECT LEVEL ANALYSIS DATASETadsl.xptOne record per subjectUSUBJIDADaMIG v1.3 section 3.1.1
ADCVEFCardiac Ejection Fraction Analysis Dataset

BASIC DATA STRUCTURE

One record per subject per analysis visit per parameter.adcvef.xptUSUBJID, AVISITN, PARAMCD

 Analysis Dataset

ADNTRPOADLBNTRPCardia Cardiac NTproBNP Laboratory Analyis Analysis Dataset

BASIC DATA STRUCTURE

One record per subject per analysis visit per parameter.adntpro.xptUSUBJID, AVISITN, PARAMCD

 Analysis Dataset

ADCMRICardiac Magnetic Resonance Imaging Measurements Analysis Dataset

BASIC DATA STRUCTURE

One record per subject per analysis visit per parameter.adcmri.xptUSUBJID, AVISITN, PARAMCD

Analysis Dataset

ADCV Analysis Dataset

This example analysis dataset used the SDTM CV dataset for input which shows the findings associated with a Cardiac Magnetic Resonance Imaging procedure related to ejection fraction. 

CVDTC is the date of the CMR procedure, CVDY is the study. For the purposes of this example, the participant was enrolled in the study on 20-May-2021 and the study visits were every twp months.The CVLNKID variable is used to identify a record to show a relationship between records in separate domains.

Definexmltable
Multipletrue
DatasetADCEF, ADLBNTRP
LevelValue
PurposeAnalysis
OIDAVAL
DatasetVariableWhereTypeOriginDerivation/Comment
ADCEFAVALPARAMCD = " LVEFC"NumPredecessor Set to CV. CVSTRESN where CV.CVTESTCD ="LVEFC".
ADCEFAVALPARAMCD = "RVEFC"NumPredecessor Set to CV. CVSTRESN where CV.CVTESTCD ="LVEFC". 
ADLBNTRPAVALPARAMCD = "BNPPRONT"NumPredecessorSet to LB.LBSTRESN where LB.LBTESTCD = "BNPPRONT"

Analysis Datasets

The following are the data structures for the example ADaM datasetThe following are the parameters for the example ADaM datasets. Note that the columns for derived variables, BASE, and CHG, PCHG and CHGCAT1 have been added , as well as selected variables from ADSL. The rows needed from the spirometry and 6MWT for ranking change from baseline were created in the safety analysis datasets. These derived rows were then copied to ADCOMPOS. The ADCOMPOS example shows the final rows required. the efficacy analysis of endpoints. The example demographics for ADSL were created for a xx year old male child.


Definexmltable
DatasetADSPIROADCV
LevelVariable
PurposeAnalysis
NameVariable
Variable NameVariable LabelTypeCodelist/Controlled Terms/FormatSourceDerivation/Comment
STUDYIDStudy IdentifierChar

CV.STUDYID


USUBJIDUnique Subject IdentifierChar

CV.USUBJID

Select for records with RE data.
ASEQAnalysis Sequence NumberNum
Sequence number given to ensure uniqueness of subject records within an ADaM dataset. Number the

CV.CVSEQ

Number records 1 to n after sorting by
the key variablesSet to  "
keys.
TRT01P

Planned Treatment for Period 01

Char"Treatment A"ADSL.TRT01PFor this example we are putting "Treatment A". In a Real World Evidence study this could be non-treatment related, e.g. "Group A".

COMPLFL

Completers Population Flag

Char

Y; N

ADSL.COMPLFL

Pick other population? for RWE this does not apply

AGEAgeNum
ADSL.AGE
AGEUAge UnitsChar(AGEU)ADSL.AGEU
SEXSexChar(SEX)ADSL.SEX
BSABASEBody Surface Area at Baseline (m2)Num
ADSL.BSABSECompute in ADSL where VS.VSTESTCD = "BSA".
PARAMParameterChar

Left Ventricular Ejection Fraction, Calculated (%)

Right Ventricular Ejection Fraction, Calculated (%)

N-Terminal ProB-type Natriuretic Peptide (pg/mL)

Move to PVLM Table



For tests from CV, set to the values of CV.CVTEST

"

plus

"(

CV.CVTESTU

)"

with spaces and parentheses as shown.

 Set to "

  

For tests from LB, set to the value of LB.LBTEST

"

plus

"(CV.CVTESTU)"

LB.LBTESTU with spaces and parentheses as shown. 

PARAMCDParameter CodeChar

LVEFC

RVEFC

BNPPRONT




If CV.CVTESTCD = "LVEF_C" then PARAMCD = "LVEFC"

If CV.CVTESTCD = "RVEF_C" then PARAMCD = "RVEFC".

If LB.

LBTESTCD

LBTESTDC = "BNPPRONT" then PARAMCD =

 

"BNPPRONT

Set to value of  CV.CVTESTCD.

.

Note: for this example dataset, select the records where the test values shown above are included.

AVALAnalysis ValueNum

Set to value of CV.CVSTRESN.

Set to value of LB.LBSTRESN.


See Parameter Value List 

AVISITAnalysis VisitChar

??????



If CV.VISIT = "

SCREENING

VISIT 1" then AVISIT = "

XXX

Visit 1 (Baseline)".

Else if CV.VISIT = "VISIT 6" then AVISIT = "

XXXX

Visit 6 (1 Year)".

AVISITNAnalysis Visit (N)Num1,  6
Set to value of CV.VISITNUM.
VISITVisitChar

CV.VISIT


ADTAnalysis DateNumdate9.
Date portion of CV.CVDTC converted to numeric and displayed in a format such as date9.
Date in SDTM represents date of CMR procedure.
 
ABLFLBaseline Record FlagCharY
Check on visit numbering

If CV.VISIT = 1 then ABLFL = "Y".

BASEBaseline ValueNum

Set BASE to AVAL from the record for that subject and parameter where ABLFL = "Y".

Populate BASE for additional visit by merging by USUJID and ADT. (Or by AVISIT if ADT varies for labs, and windowing is applied to select record closest to the visit)

CHGChange from BaselineNum

Compute CHG = AVAL - BASE for that record. Only compute for post-baseline records.
PCHGPercent Change from BaselineNum

Compute PCHG = (CHG / BASE) * 100. Only compute for post-baseline records.
CHGCAT1Change from Baseline Category 1

>1.0 g/dL;

<=1.0 g/dL



SRCDOMSource DataChar

CV

LB


 Set to the SDTM domain name that relates to the analysis value.
SRCSEQSource Sequence NumberNum

CV.CVSEQ

LB.LBSEQ


Set to the SDTM domain sequence number that relates to the analysis
value.
Definexmltable
Multipletrue
DatasetADSPIRO, AD6MWT, ADCOMPOS
LevelValue
PurposeAnalysis
OIDAVAL
NameParameter Value List - ADCOMPOS
Dataset wrap
Namecv
RowcapsRows 1-8:Show the baseline CMR ejection fraction measurements for participant 101 at Screening.Rows 9-16:Show the CMR ejection fraction measurements for participant 101 at VISIT 6. Dataset2
tableidcv
RowSTUDYIDDOMAINUSUBJIDCVSEQCVLNKIDCVTESTCDCVTESTCVORRESCVORRESUCVSTRESCCVSTRESNCVSTRESUCVMETHODVISITNUMVISITCVDTCCVDY1DMD-EFLGECV1011

LVESV

Left Ventricle End Systolic Volume32mL3232mLCARDIAC MAGNETIC RESONANCE IMAGING1SCREENING2022-05-162DMD-EFLGECV1012

LVEDV

Left Ventricle End Diastolic Volume95mL9595mL

CARDIAC MAGNETIC RESONANCE IMAGING

1SCREENING2022-05-163DMD-EFLGECV10132LVEF_CLeft Ventricular Ejection Fraction, Calculated67%6767%CARDIAC MAGNETIC RESONANCE IMAGING1SCREENING2022-05-164DMD-EFLGECV10142LVCOLV Cardiac Output5.4L/min5.45.4L/min

CARDIAC MAGNETIC RESONANCE IMAGING

1SCREENING2022-05-165DMD-EFLGECV1015

RVESV

Right Ventricle End Systolic Volume24mL2424mL

CARDIAC MAGNETIC RESONANCE IMAGING

1SCREENING2022-05-166DMD-EFLGECV1016

RVEDV

Right Ventricle End Diastolic Volume90mL9090mLCARDIAC MAGNETIC RESONANCE IMAGING1SCREENING2022-05-167DMD-EFLGECV10172RVEF_CRight Ventricular Ejection Fraction, Calculated74%7474%

CARDIAC MAGNETIC RESONANCE IMAGING

1SCREENING2022-05-168DMD-EFLGECV10182RVCORV Cardiac Output5.6L/min5.65.6L/min

CARDIAC MAGNETIC RESONANCE IMAGING

1SCREENING2022-05-169DMD-EFLGECV1019

LVESV

Left Ventricle End Systolic Volume37mL3737mLCARDIAC MAGNETIC RESONANCE IMAGING6VISIT 62023-06-0137610DMD-EFLGECV10110

LVEDV

Left Ventricle End Diastolic Volume94mL9494mL

CARDIAC MAGNETIC RESONANCE IMAGING

6VISIT 62023-06-0137611DMD-EFLGECV101112LVEF_CLeft Ventricular Ejection Fraction, Calculated60%6060%CARDIAC MAGNETIC RESONANCE IMAGING6VISIT 62023-06-0137612DMD-EFLGECV101122LVCOLV Cardiac Output4
DatasetVariableWhereTypeOriginDerivation/CommentADCMRIAVALPARAMCD = " XXXX"NumDerivedWithin each component (FVCPP), the change from baseline
value
is sorted by lowest CHG, then ranked across all pooled subjects. The lowest change value is assigned a rank of 1, the next lowest a rank of 2, and so on.ADCMRIAVALPARAMCD = "XXXX"NumPredecessorSet to CV.CVSTRESN where CV.CVTESTCD = "FVC".ADCMRIAVALPARAMCD = "NTPROBNP"NumPredecessorSet to CV.CVSTRESN where CV.CVTESTCD = "FVCPP".
Dataset wrap
Namecv
RowcapsRows 1-8:Show the baseline CMR ejection fraction measurements for participant 101 at Screening.Rows 9-16:Show the CMR ejection fraction measurements for participant 101 at VISIT 6. Dataset2
tableidcv
RowSTUDYIDUSUBJIDPARAMCDPARAMAVALCVMETHODVISITNUMVISITADTABLFLBASECHGPCHGCHGCATSRCDOMSRCSEQ1DMD-EFLGE101LVEF_CLeft Ventricular Ejection Fraction, Calculated (%)67CARDIAC MAGNETIC RESONANCE IMAGING1SCREENING2022-05-16Y67CV32DMD-EFLGE101LVCO

LV Cardiac Output (L/min)

5.4

CARDIAC MAGNETIC RESONANCE IMAGING

1SCREENING2022-05-16Y5.4CV43DMD-EFLGE101RVEF_CRight Ventricular Ejection Fraction, Calculated (%)74

CARDIAC MAGNETIC RESONANCE IMAGING

1SCREENING2022-05-16Y74CV74DMD-EFLGE101RVCORV Cardiac Output (L/min)5.6

CARDIAC MAGNETIC RESONANCE IMAGING

1SCREENING2022-05-16Y67CV85DMD-EFLGE101BNPPRONTN-Terminal ProB-type Natriuretic Peptide (pg/mL)1SCREENING2022-05-16YLB16DMD-EFLGE101LVEF_CLeft Ventricular Ejection Fraction, Calculated (%)60CARDIAC MAGNETIC RESONANCE IMAGING6VISIT 62023-06-01Y5.4CV117DMD-EFLGE101LVCOLV Cardiac Output (L/min)4.0

CARDIAC MAGNETIC RESONANCE IMAGING

6VISIT 62023-06-01Y74CV128DMD-EFLGE101RVEF_CRight Ventricular Ejection Fraction, Calculated (%)61

CARDIAC MAGNETIC RESONANCE IMAGING

6VISIT 62023-06-01YCV159DMD-EFLGE101RVCORV Cardiac Output (L/min)4.0

CARDIAC MAGNETIC RESONANCE IMAGING

6VISIT 62023-06-01YCV1610DMD-EFLGE101BNPPRONTN-Terminal ProB-type Natriuretic Peptide (pg/mL)6VISIT 62023-06-01YLB2

(Copied from the SDTM page for reference until I create the sample ADaM dataset

376
.
0
L/min4.04.0L/min

CARDIAC MAGNETIC RESONANCE IMAGING

6VISIT 62023-06-0137613DMD-EFLGECV10113

RVESV

Right Ventricle End Systolic Volume36mL3636mL

CARDIAC MAGNETIC RESONANCE IMAGING

6VISIT 62023-06-0137614DMD-EFLGECV10114

RVEDV

Right Ventricle End Diastolic Volume93mL9393mLCARDIAC MAGNETIC RESONANCE IMAGING6VISIT 62023-06-01376
15DMD-EFLGECV101152RVEF_CRight Ventricular Ejection Fraction, Calculated61%6161%

CARDIAC MAGNETIC RESONANCE IMAGING

6VISIT 62023-06-01376
16DMD-EFLGECV101162RVCORV Cardiac Output4.0L/min4.04.0L/min

CARDIAC MAGNETIC RESONANCE IMAGING

6VISIT 62023-06-01










Info

Ejection Fraction

  • change in ejection fraction, would expect a decline in EF 2-3% per year, would prefer an improvement or no change. Concerning if rapid progression, 10% decline or more, for example.

NTproBNP

  • % change over a period of time – a decrease would mean improvement, annually is appropriate

SDTM Examples: Basic CMR tests - Systolic Function

...