Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Added specs and example dataset

...

The SDTM 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. 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  dataset 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 over time. In this example, we will show one variable for BSA with the variable "Baseline Body Surface Area (m2)" which can be added to ADSL.

...

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

...

ADCVEF is a dataset capturing only the tests required for this analysis, selecting for CVTESTCD equal to "LVEF_C" or "RVEF_C".   The relationship dataset RELREC shows the datset relationships. There is a many to one relationship between the tests from CV and the laboratory data collected at the same visits. Therefore by subsetting the LB with LBLNKID not missing, this selects the laboratory data that can be merged with CV by USUBJID and VISIT  VISIT (or USUBJID and AVISIT in ADaM)   In ADaM analysis datasets we can also use a windowing strategy to select the laboratory draw closest to that visit to merge with CV which is computed in AVISIT in which case all LB records would be kept for the tests of interest.

ADLBNTRP is a subset of LB selecting for LBTESTCD  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.

...

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
ADCVNTRPCardiac Ejection Fraction  Fraction and NTproBNP Analysis Dataset

BASIC DATA STRUCTURE

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

 Analysis Dataset

ADCMRICardiac Magnetic Resonance Imaging Measurements Analysis Dataset

BASIC DATA STRUCTURE

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

Analysis Dataset

Definexmltable
DatasetADCVNTRP
LevelValue
PurposeAnalysis
OIDAVAL
DatasetVariableWhereTypeOriginDerivation/Comment
ADCVNTRPAVALPARAMCD = " LVEFC"NumPredecessor Set to CV. CVSTRESN where CV.CVTESTCD ="LVEF_C".
ADCVNTRPAVALPARAMCD = "RVEFC"NumPredecessor Set to CV. CVSTRESN where CV.CVTESTCD ="RVEF_C". 
ADLBNTRPADCVNTRPAVALPARAMCD = "BNPPRONT"NumPredecessorSet to LB.LBSTRESN where LB.LBTESTCD = "BNPPRONT"
ADCMRI




Analysis Datasets

The following are the data structures for the example ADaM datasets. Note that the columns for derived variables, BASE, and CHG, PCHG and CHGCAT1 have been added for the efficacy analysis of endpoints. The example demographics for ADSL were created for an 8 year old male child. The ADaM standard only suggests variable order, so the demographics and treatment variables have been put at the end, so that the variables of interest are shown at the beginning of the dataset. Since we are combining two SDTM domains into one analysis dataset, some variables unique to LB will be blank for records from CV.

...

Definexmltable
DatasetADCV
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

CV.CVSEQ

Number records 1 to n after sorting by keys.
BSABASEBody Surface Area (m2) at BaselineNum
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)


For tests from CV, set to the values of CV.CVTEST plus CV.CVTESTU with spaces and parentheses as shown.   

For tests from LB, set to the value of LB.LBTEST plus 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.LBTESTDC = "BNPPRONT" then PARAMCD = "BNPPRONT.

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

AVALAnalysis ValueNum


See Parameter Value List 

AVISITAnalysis VisitChar



If CV.VISIT = "VISIT 1" then AVISIT = "Visit 1 (Baseline)".

Else if CV.VISIT = "VISIT 6" then AVISIT = "Visit 6 (1 Year)".

AVISITNAnalysis Visit (N)Num

Set to value of CV.VISITNUM or LB.VISITNUM
VISITVisitNum
CV.VISIT LB.VISIT
ADTAnalysis DateNumdate9.
Date portion of CV.CVDTC or LB.LBDTC converted to numeric and displayed in a format such as date9. 
ABLFLBaseline Record FlagCharY

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 visits by merging by USUBJID 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



LBSTRNRLOReference Range Lower Limit-Std Units


LB.LBSTRNRLO
LBSTRNHIReference Range Upper Limit-Std Units


LB.LBSTRNHI
LBNRINDReference Range
Indicator

(NRIND)

LB.LBNRIND
TRT01P

Planned Treatment for Period 01

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

ITTFL

Intent-to-Treat Population Flag

Char

Y; N

ADSL.ITTFL

Pick other population? POSSIBLE  POSSIBLE RWE STUDY

AGEAgeNum
ADSL.AGE
AGEUAge UnitsChar(AGEU)ADSL.AGEU
SEXSexChar(SEX)ADSL.SEX
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.


Example 1 

This example dataset shows the findings and additional analysis variables associated with :

  • Left Ventricular Ejection Fraction, Calculated (%)
  • Right Ventricular Ejection Fraction, Calculated (%)
  • N-Terminal ProB-type Natriuretic Peptide (pg/mL)


Dataset wrap
Nameadcvntpr
Rowcaps
Rows 1-4:Show the baseline CMR ejection fraction measurements for participant 101 at VISIT 1.
Row 5:Shows the baseline NTProbTest for participant 101 at VISIT 1.
Rows 6-9:ShowS the CMR ejection fraction measurements for participant 101 at VISIT 6.
Row 10:Shows the NTProbTest for participant 101 at VISIT 6.
Dataset2
tableidadcvntpr
STUDYIDUSUBJIDASEQBSABASEPARAMPARAMCDAVALAVISITAVISITNVISITADTABLFLBASECHGPCHGCHGCAT1LBSTRNRLOLBSTRNHILBNRINDTRT01PITTFLAGEAGEUSEXSRCDOMSRCSEQ
DMD-EFLGEDMD-EFLGE-10110.65Left Ventricular Ejection Fraction, Calculated (%)LVEFC67Visit 1 (Month 1)1VISIT 116May2022Y67





Treatment AY8YEARSMCV3
DMD-EFLGEDMD-EFLGE-10120.65Right Ventricular Ejection Fraction, Calculated (%)RVEFC74Visit 1 (Month 1)1VISIT 116May2022Y74





Treatment AY8YEARSMCV7
DMD-EFLGEDMD-EFLGE-10130.65N-Terminal ProB-type Natriuretic Peptide (IU/L)BNPPRONT40Visit 1 (Baseline)1VISIT 116May2022Y40


10040NORMALTreatment AY8YEARSMLB1
DMD-EFLGEDMD-EFLGE-10140.65Left Ventricular Ejection Fraction, Calculated (%)LVEFC60Visit 6 (Month 12)6VISIT 601Jun2023
67-7-10.447761



Treatment AY8YEARSMCV11
DMD-EFLGEDMD-EFLGE-10150.65Right Ventricular Ejection Fraction, Calculated (%)RVEFC61Visit 6 (Month 12)6VISIT 601Jun2023
74-13-17.567568



Treatment AY8YEARSMCV10
DMD-EFLGEDMD-EFLGE-10160.65N-Terminal ProB-type Natriuretic Peptide (IU/L)BNPPRONT900Visit 6 (1 Year)6VISIT 11Jun2023
408602150
100900HIGHTreatment AY8YEARSMLB11.8
RowSTUDYIDUSUBJIDASEQBSABASEPARAMPARAMCDAVALAVISITAVISITNVISITADTABLFLBASECHGPCHGCHGCAT1LBSTRNRLOLBSTRNRHILBNRINDTRT01PITTFLAGEAGEUSEXSRCDOMSRCSEQ
1DMD-EFLGEDMD-EFLGE-10110.65Left Ventricular Ejection Fraction, Calculated (%)LVEFC67Visit 1 (Month 1)1VISIT 116May2022Y67





Treatment AY8YEARSMCV3
2DMD-EFLGEDMD-EFLGE-10120.65Right Ventricular Ejection Fraction, Calculated (%)RVEFC74Visit 1 (Month 1)1VISIT 116May2022Y74





Treatment AY8YEARSMCV7
3DMD-EFLGEDMD-EFLGE-10130.65N-Terminal ProB-type Natriuretic Peptide (IU/L)BNPPRONT40Visit 1 (Baseline)1VISIT 116May2022Y40


10040NORMALTreatment AY8YEARSMLB1
4DMD-EFLGEDMD-EFLGE-10140.65Left Ventricular Ejection Fraction, Calculated (%)LVEFC60Visit 6 (Month 12)6VISIT 601Jun2023
67-7-10.447761



Treatment AY8YEARSMCV11
5DMD-EFLGEDMD-EFLGE-10150.65Right Ventricular Ejection Fraction, Calculated (%)RVEFC61Visit 6 (Month 12)6VISIT 601Jun2023
74-13-17.567568



Treatment AY8YEARSMCV10
6DMD-EFLGEDMD-EFLGE-10160.65N-Terminal ProB-type Natriuretic Peptide (IU/L)BNPPRONT900Visit 6 (1 Year)6VISIT 11Jun2023
408602150
100900HIGHTreatment AY8YEARSMLB2
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

...