Versions Compared

Key

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

...

Definexmltable
DatasetADCVNTP
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.BSABASECompute 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.

PARAMNParameter NumberNum



Number PARAMCD as follows:

"LVEFC = 1"

"LVRFC = 2"

BNPPRONT = "3"

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 copying the value of BASE in the baseline record by USUBJID and ADT. (Or by AVISIT if ADT varies for labs, where 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 1Char

>1> 1.0 (IU/L);

<= 1.0 (IU/L)


Categorise the value of CHG.
LBSTRNRLOReference Range Lower Limit-Std UnitsNum


LB.LBSTRNRLO
LBSTRNHIReference Range Upper Limit-Std UnitsNum


LB.LBSTRNHI
LBNRINDReference Range
Indicator
Char

(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 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.

...

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





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





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


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



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



Treatment AY8YEARSMCV15
6DMD-EFLGEDMD-EFLGE-10160.65N-Terminal ProB-type Natriuretic Peptide (IU/L)BNPPRONT3900Visit 6 (1 Year)6VISIT 11Jun2023
408602150>1> 1.0 (IU/L)100900HIGHTreatment AY8YEARSMLB2

...

Dataset wrap
Nameadcvntp
Dataset2
tableidadcvntp
RowSTUDYIDUSUBJIDASEQBSABASEBNPPRONTBNPPRCHGPARAMPARAMCDPARAMNAVALAVISITAVISITNVISITADTABLFLBASECHGPCHGTRT01PITTFLAGEAGEUSEXSRCDOMSRCSEQ
1DMD-EFLGEDMD-EFLGE-10110.6540
Left Ventricular Ejection Fraction, Calculated (%)LVEFC167Visit 1 (Month 1)1VISIT 116May2022Y67

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

Treatment AY8YEARSMCV7
3DMD-EFLGEDMD-EFLGE-10130.65900>1> 1.0 (IU/L)Left Ventricular Ejection Fraction, Calculated (%)LVEFC160Visit 6 (Month 12)6VISIT 601Jun2023
67-7-10.447761Treatment AY8YEARSMCV11
4DMD-EFLGEDMD-EFLGE-10140.65900>1> 1.0 (IU/L)Right Ventricular Ejection Fraction, Calculated (%)RVEFC261Visit 6 (Month 12)6VISIT 601Jun2023
74-13-17.567568Treatment AY8YEARSMCV15

...