Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Added ADSL and ACEINHFL

...

Definexmltable
Multipletrue
LevelDataset
PurposeAnalysis

Dataset Name

Dataset Description

Class of Dataset

Structure

Location

Keys

Documentation

ADSL

Subject-Level Analysis Dataset

SUBJECT LEVEL ANALYSIS DATASET

One record per subject

adsl.xptUSUBJIDADaMIG
ADCVNTPCardiac Ejection Fraction and NTproBNP Analysis Dataset

BASIC DATA STRUCTURE

One record per subject per analysis visit per parameteradcvntp.xptUSUBJID, AVISITN, PARAMN

Analysis Dataset

ADCVCMRCardiovascular CMR Ejection Fraction Analysis Dataset

BASIC DATA STRUCTURE

One record per subject per analysis visit per parameteradcvcmr.xptUSUBJID, AVISITN, PARAMN

Analysis Dataset

ADSL Analysis Dataset

...


Definexmltable
DatasetADSL
LevelVariable
PurposeAnalysis
NameVariable

shown below is an abbreviated specification of ADSL for the example. As mentioned,

...

only a few of the required variables are shown.

...

Variable
Definexmltable
DatasetADSL
LevelVariable
PurposeAnalysis
Name

Variable NameVariable LabelTypeCodelist/Controlled Terms/FormatSourceDerivation/Comment
STUDYIDStudy IdentifierChar

DM.STUDYID


USUBJIDUnique Subject IdentifierChar

DM.USUBJID


BRTHDTDate of BirthNumdate9.

ADSL.BRTHDTC

Convert BRTHDTC from ISO 8601 format to numeric date. (Note that if exact date is not found then use two variables to capture year and month.)
TRTSDTDate of First Exposutre to Treatment.Numdate9.
Date portion of DM.RFSTDTC converted to numeric and displayed in a format such as DATE9.
TRT01P

Planned Treatment for Period 01

CharTreatment AADSL.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


BSABASEBody Surface Area (m2) at BaselineNum
ADSL.BSABASE

Set to VS.VSSTRESN in ADSL where VS.VSTESTCD = "BSA" and selecting for baseline visit.

ACEINHFL

ACE Inhibitor Medications Flag

Char

Y


Select a list of ACE inhibitor medications from concomitant medications (CM) domain, and from treatment (EX or EC) domains. Code 'Y' if the medication was taken during the study. Can be used to subset or to exclude the population who took ACE inhibitors.

AnalysisOID
Definexmltabledataset-wrap
Purpose
DatasetShowADCVNTPtrue
LevelNameValueADSl
Dataset2
tableid
adcvcmr
AVAL
RowSTUDYIDUSUBJIDBRTHDTTRTSDTTRT01PITTFLBSABASEACENHFL
1DMD-EFLGEDMD-EFLGE-10115FEB202116MAY2022Treatment AY0.65Y



Definexmltable
DatasetADCVNTP
LevelValue
PurposeAnalysis
OIDAVAL
DatasetVariableWhereTypeOriginDerivation/Comment
ADCVNTPAVALPARAMCD = "LVEFC"NumPredecessorSet to CV.CVSTRESN where CV.CVTESTCD = "LVEF_C"
ADCVNTPAVALPARAMCD = "RVEFC"NumPredecessorSet to CV.CVSTRESN where CV.CVTESTCD = "RVEF_C"
ADCVNTPAVALPARAMCD = "BNPPRONT"NumPredecessorSet to LB.LBSTRESN where LB.LBTESTCD = "BNPPRONT"

...

Definexmltable
DatasetADCVNTP
LevelVariable
PurposeAnalysis
NameVariable
Select a list of ACE inhibitor medications from concomitant medications (CM) domain, and from treatment (EX or EC) domains. Code 'Y' if the medication was taken during the study. Can be used to subset or to exclude the population who took ACE inhibitors.
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.
BRTHDTDate of BirthNumDate9.

ADSL.BRTHDTC

Convert BRTHDTC from ISO 8601 format to numeric date. (Note that if exact date is not found then use two variables to capture year and month.)
TRT01P

Planned Treatment for Period 01

CharTreatment ABSABASEBody Surface Area (m2) at BaselineNumADSL.BSABASECompute in ADSL where VS.VSTESTCD = "BSA".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


BSABASEBody Surface Area (m2) at BaselineNum
ADSL.BSABASECompute in ADSL where VS.VSTESTCD = "BSA".

ACEINHFL

ACE Inhibitor Medications Flag

Char

Y


Select a list of ACE inhibitor medications from concomitant medications (CM) domain, and from treatment (EX or EC) domains. Code 'Y' if the medication was taken during the study. Can be used to subset or to exclude the population who took ACE inhibitors.

BSABody Surface Area (m2) by VisitNum



Compute from VS.HEIGHT and VS.WEIGHT by visit, using the Du Bois method. Note that there are multiple methods to compute, and the study protocol should describe which one to use. (

BSABody Surface Area (m2) by VisitNum

Compute from VS.HEIGHT and VS.WEIGHT by visit, using the Du Bois method. Note that there are multiple methods to compute, and the study protocol should describe which one to use. (e.g. other methods may be Mosteller, Haycock, Gehan & George, Boyd, Fujimoto, Takahira, and Schlich)

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 (N)Num



Number PARAMCD as follows:

LVEFC = "1"

RVEFC = "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

Decline >=10.0;

Decline < 10.0; 

Increase


Categorize the value of CHG for Left Ventricular Ejection Fraction, and Calculated (%) (LVEFC) and for Right Ventricular Ejection Fraction, Calculated (%) (RVEFC)
CHGCAT2Change from Baseline Category 2Chart



ITTFL

Intent-To-Treat Population Flag

Char

Y; N

ADSL.ITTFL

ACEINHFL

ACE Inhibitor Medications Flag

Char

Y

Categorize the value of CHG for N-Terminal ProB-type Natriuretic Peptide (pg/mL) (BNPPRONT)
TRT01P

Planned Treatment for Period 01

CharTreatment AADSL.TRT01PFor this example we are using "Treatment A". In a Real World Evidence study this could be non-treatment related, e.g. "Group A".
/mL) (BNPPRONT)
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.

...

Y
Dataset wrap
Nameadcvntp
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.
ACEINHFL
Dataset2
tableidadcvntp
RowSTUDYIDUSUBJIDASEQBRTHDTTRT01PITTFLBSABASEACEINHFLBSAPARAMPARAMCDPARAMNAVALAVISITAVISITNVISITADTABLFLBASECHGPCHGCHGCAT1
TRT01PITTFL
SRCDOMSRCSEQ
1DMD-EFLGEDMD-EFLGE-101115FEB2021Treatment AY0.65Y0.65Left Ventricular Ejection Fraction, Calculated (%)LVEFC167Visit 1 (Baseline)1VISIT 116MAY2022Y67
Treatment AY



CV3
2DMD-EFLGEDMD-EFLGE-101215FEB2021Treatment AY0.65Y
Right Ventricular Ejection Fraction, Calculated (%)RVEFC274Visit 1 (Baseline))1VISIT 116MAY2022Y74
Treatment AYY



CV7
3DMD-EFLGEDMD-EFLGE
-1013
-101315FEB2021Treatment AY0.65Y
N-Terminal ProB-type Natriuretic Peptide (IU/L)BNPPRONT340Visit 1 (Baseline)1VISIT 116MAY2022Y40
Treatment AYY



LB1
4DMD-EFLGEDMD-EFLGE-101415FEB2021Treatment AY0.65Y
Left Ventricular Ejection Fraction, Calculated (%)LVEFC160Visit 6 (1 Year)6VISIT 601JUN2023
67-7-10.447761Decline >=10.0
Treatment AYY
CV11
5DMD-EFLGEDMD-EFLGE-101515FEB2021Treatment AY0.65Y
Right Ventricular Ejection Fraction, Calculated (%)RVEFC261Visit 6 (1 Year)6VISIT 601JUN2023
74-13-17.567568Decline >=10.0
Treatment AYY
CV15
6DMD-EFLGEDMD-EFLGE-101615FEB2021Treatment AY0.65Y
N-Terminal ProB-type Natriuretic Peptide (IU/L)BNPPRONT3900Visit 6 (1 Year)6VISIT 101JUN2023
40
8602,150
8602,150Treatment AYY

LB2

Example 2 

The dataset above can also be set up to provide multivariate analyses by taking the lab tests of interest, transposing and merging with the ADCVNTP dataset. In that case, the records from LB are not needed as a row.

...

Y
Dataset wrap
Nameadcvcmr
ITTFL
Dataset2
tableidadcvcmr
RowSTUDYIDUSUBJIDASEQTRT01PITTFLBSABASEACEINHFLBSABNPPRONTBNPCHGPARAMPARAMCDPARAMNAVALAVISITAVISITNVISITADTABLFLBASECHGPCHG
TRT01P
SRCDOMSRCSEQ
1DMD-EFLGEDMD-EFLGE-1011Treatment AY0.65Y
40
Left Ventricular Ejection Fraction, Calculated (%)LVEFC167Visit 1 (Baseline)1VISIT 116MAY2022Y67
Treatment A


CV3
2DMD-EFLGEDMD-EFLGE-1012Treatment AY0.65Y
40
Right Ventricular Ejection Fraction, Calculated (%)RVEFC274Visit 1 (Baseline)1VISIT 116MAY2022Y74
Treatment AY


CV7
3DMD-EFLGEDMD-EFLGE-1013Treatment AY0.65Y
9002150Left Ventricular Ejection Fraction, Calculated (%)LVEFC160Visit 6 (1 Year)6VISIT 601JUN2023
67-7-10.447761
Treatment AY
CV11
4DMD-EFLGEDMD-EFLGE-1014Treatment AY0.65Y
9002150Right Ventricular Ejection Fraction, Calculated (%)RVEFC261Visit 6 (1 Year)6VISIT 601JUN2023
74-13-17.567568
Treatment AY
CV15

Example Analysis Results Metadata (ARM) Tables

...