Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: changed multivariat to multiple covariates

...

  • Percent change in ejection fraction over time (1 year)
  • Decline in ejection fraction over time (1 year) grouped by a decline greater than 5%-5.0%
  • Percent change in NT-proBNP over time (1 year)

...

The SDTM examples used as the source data are from Section 2.1, Basic Systolic FunctionThe records in the CV dataset for which CVTESTCD = "LVEF_C" and "RVEF_C" were selected for analysis. The records in the LB dataset where LBTESTCD = "BNPPRONT" were used to compute the percent change over time and as a potential covariate. Both SDTM domains are used in one analysis dataset to demonstrate the flexibility of ADaM and to show that the various SDTM domains can be combined into one dataset both as rows and also as covariates.

Example Analysis Datasets

The following tables show the analysis dataset metadata

Jira
showSummaryfalse
serverIssue Tracker (JIRA)
serverId85506ce4-3cb3-3d91-85ee-f633aaaf4a45
keyTAUGDMDCIS-3
and metadata and parameters used for this example.

-

Definexmltable
Multipletrue
LevelDataset
PurposeAnalysis
false

Dataset Name

Description

Class

Structure

Purpose

Keys

Location

Documentation

ADSL

Subject-Level Analysis Dataset

SUBJECT LEVEL ANALYSIS DATASET

One record per subject.

AnalysisUSUBJIDadsl.xptADSL.SAS
ADEFNTPCV MRI EF and NT-proBNP Analysis

BASIC DATA STRUCTURE

One record per subject per analysis visit per parameter.AnalysisUSUBJID, AVISITN, PARAMNadefntp.xpt

ADEFNTP.SAS/SAP

Jira
showSummary
serverIssue Tracker (JIRA)
serverId85506ce4-3cb3-3d91-85ee-f633aaaf4a45
keyTAUGDMDCIS-4
ADEFMRICV MRI Ejection Fraction Analysis

BASIC DATA STRUCTURE

One record per subject per analysis visit per parameter.AnalysisUSUBJID, AVISITN, PARAMNadefmri.xpt

ADEFMRI.SAS/SAP

ADSL

The ADSL contains subject characteristics and covariates that are important for analyses. Stratification variables can be created in the ADSL to subset the data. More than one SDTM dataset may be used as input to the ADSL. This is a simplified example ADSL dataset; the ADaMIG should be referenced for additional variables.

...

Definexmltable
DatasetADSL
LevelVariable
PurposeAnalysis
NameVariable
Variable NameVariable LabelTypeCodelist/Controlled TermsSource/Derivation/Comment
STUDYIDStudy Identifiertext
Predecessor: DM.STUDYID
USUBJIDUnique Subject Identifiertext
Predecessor: DM.USUBJID
BRTHDTDate of Birthintegerdate9yymmdd10.

Derived: Date portion of DM.BRTHDTC converted to numeric and displayed in a format, such as date9yymmdd10. 

AAGEAnalysis Agefloat
Derived: Age as screening, computed by DM.RFICDTC - BRTHDTC as continuous variable. Note that some countries do not allow capturing date of birth, so this could be computed by capturing age in years and months on a CRF.
AGEAgeinteger
Predecessor: DM.AGE
AGEUAge UnitstextYEARSPredecessor: DM.AGEU

SEX

Sextext(SEX)Predecessor: DM.SEX

RACE

Racetext(RACE)Predecessor: DM.RACE
TRTSDTDate of First Exposure to Treatmentintegerdate9yymmdd10.Derived: Date portion of DM.RFSTDTC converted to numeric and displayed in a format such as date9yymmdd10.
RFICDT

Date of Informed Consent

integerdate9yymmdd10.Derived: Date portion of DM.RFICDTC converted to numeric and displayed in a format such as date9yymmdd10.
DTHDT

Date of Death

integerdate9yymmdd10.

Derived: Date portion of DM.DTHDT converted to numeric and displayed in a format such as date9yymmdd10.

DTHFL

Subject Death
Flag

textYPredecessor: DM.DTHFL
TRT01P

Planned Treatment for Period 01

textDrug A; Drug B

Predecessor: DM.ARM.

May be changed to lower case or more descriptive term for use in tables and listings.

TRT01A

Actual Treatment for Period 01

textDrug A; Drug B

Predecessor: DM.ACTARM.

Note: Actual treatment matches planned treatment unless there is a reason subject does not take planned drug.

ITTFL

Intent-To-Treat Population Flag

text

Y; N

Derived: Derive the intent-to-treat population as per the protocol and SAP.

ACEINHFL

ACE Inhibitor Medications Flag

text

Y; N

Derived: Select a list of ACE inhibitor medications from concomitant medications (CM) domain as per SAP or protocol. Set to "Y" if these medications were taken during the study, and "N" if they are absent. Can be used to subset or to exclude the population who took ACE inhibitors.

HEIGHTSC

Height (cm) at Screening

float


Predecessor: Set to VS.VSSTRESN where VS.VSTESTCD = "HEIGHT" and VISITNUM= 1 (or screening visit).

WEIGHTSC

Weight (kg) at Screening

float


Predecessor: Set to VS.VSSTRESN where VS.VSTESTCD = "WEIGHT" and VISITNUM = 1 (or screening visit).

BSASC

Body Surface Area at Screening

float


Derived: Select where VISITNUM = 1 (or screening visit). Compute from HEIGHT and WEIGHT, using the Du Bois method. BSA = 0.007184 × W0.425 × H0.725

There are multiple methods for calculating BSA (e.g., Du Bois, Mosteller, Haycock, Gehan & George, Boyd, Fujimoto, Takahira, Schlich); the study protocol should describe which to use.

13JUN2022
Dataset wrap
Showtrue
NameADSL
16JUN2022
Dataset2
tableidadsl
RowSTUDYIDUSUBJIDBRTHDTAAGEAGEAGEUSEXRACETRTSDTRFICDTDTHDTDTHFLTRT01PITTFLACEINHFLHEIGHTSCWEIGHTSCBSASC
1DMD-EFLGEDMD-EF-01-101
07FEB2010
2010-02-0712.312YEARSMBLACK OR AFRICAN AMERICAN
16JUN2022
2022-06-162022-06-16

Drug AYY119200.82
2DMD-EFLGEDMD-EF-01-101
01MAY2008

2008-05-01

14.114YEARSMASIAN
13JUN2022

2022-06-13

2022-06-13

Drug AYY115300.95
3DMD-EFLGEDMD-EF-01-101
10JUL2003
2003-07-1019.019YEARSMNATIVE HAWAIIAN OR OTHER PACIFIC ISLANDER

15JUL2022

15JUL2022

2022-07-15

2022-07-15

Drug BYN140451.30
4DMD-EFLGEDMD-EF-01-101
15JAN1999
1999-01-1523.723YEARSMWHITE
06SEP202206SEP202223NOV2023

2022-09-06

2022-09-06

2023-11-23

YDrug BYY132421.21

ADEFNTP

The ADEFNTP includes tests pertinent to analyses. The records from CV (CVTESTCD = "LVEF_C" and "RVEF_C") and the records from LB (LBTESTCD = "BNPPRONT") were selected. Many lab draws may occur throughout the year, but only those linked to a specific visit were included. By subsetting the LB dataset by LBLNKID not missing, laboratory data that aligns with CV data can be filtered out and sorted using USUBJID and VISIT. If LBLNKID is not available or the LB dataset does not contain VISIT, a windowing strategy could be used to select the laboratory draw closest to that visit using date of lab draw (LB.LBDTC.).

...

Definexmltable
DatasetADEFNTP
LevelVariable
PurposeAnalysis
NameVariable

Variable NameVariable LabelTypeCodelist/Controlled TermsSource/Derivation/Comment
STUDYIDStudy Identifiertext
Predecessor: CV.STUDYID
USUBJIDUnique Subject Identifiertext
Predecessor: CV.USUBJID
BRTHDTDate of Birthintegerdate9yymmdd10.Predecessor: ADSL.BRTHDT
AAGEAnalysis Agefloat
Predecessor: ADSL.AAGE
AGEUAge Unittext

Predecessor: ADSL.AGEU

SEX

Sextext(SEX)

Predecessor: ADSL.SEX

RACE

Racetext(RACE)Predecessor: ADSL.RACE
TRTSDT

Date of First Exposure to Treatment

integerdate9yymmdd10.Predecessor: ADSL.TRTSDT
TRT01P

Planned Treatment for Period 01

textDrug A; Drug BPredecessor: ADSL.TRT01P
TRT01A

Actual Treatment for Period 01

textDrug A; Drug BPredecessor: ADSL.TRT01A

ITTFL

Intent-To-Treat Population Flag

text

Y; N

Predecessor: ADSL.ITTFL

HEIGHT

Height (cm)

float


Set to VS.VSSTRESN where VS.VSTEST = "HEIGHT" by visit.

WEIGHT

Weight (kg)

float


Set to VS.VSSTRESN where VS.VSTEST = "WEIGHT" by visit.

BSABody Surface Area (m2)float


Derived:

Compute from HEIGHT and WEIGHT at each visit, using the Du Bois method. BSA = 0.007184 × W0.425 × H0.725

There are multiple methods for calculating BSA; the study protocol should describe which to use.

ACEINHFL

ACE Inhibitor Medications Flag

text

Y; N

Predecessor: ADSL.ACEINHFL
PARAMParametertext

Left Ventricular Ejection Fraction, Cal (%);

Right Ventricular Ejection Fraction, Cal (%);

N-Terminal ProB-type Natriuretic Peptide (ng/L)

Predecessor:

CV.CVTEST

LB.LBTEST

PARAMCDParameter Codetext

LVEF_C;

RVEF_C;

BNPPRONT

Predecessor:

CV.CVTESTCD

LB.LBTESTCD

PARAMNParameter (N)integer

1; 2; 3;

Assigned:

Number PARAMCD as follows:

LVEF_C = "1"

RVEF_C = "2"

BNPPRONT = "3"

AVALAnalysis Valuefloat

See Parameter Value Metadata

AVISITAnalysis Visittext

Visit 1 (Baseline); Visit  Visit 6 (1 Year)

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

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

AVISITNAnalysis Visit (N)integer1; 6

Predecessor:

CV.VISITNUM

LB.VISITNUM

VISITVisitinteger

VISIT 1; VISIT 6

Predecessor:

CV.VISIT

LB.VISIT

ADTAnalysis Dateintegerdate9yymmdd10.Date portion of CV.CVDTC or LB.LBDTC converted to numeric and displayed in a format such as date9yymmdd10
ABLFLBaseline Record FlagtextY

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

BASEBaseline Valuefloat

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

Populate BASE for additional visits by merging the value of BASE in the baseline record by USUBJID and PARAMCD.

CHGChange from Baselinefloat
Derived: Compute CHG = AVAL - BASE for that record. Only compute for post-baseline records.
PCHGPercent Change from Baselinefloat
Derived: Compute PCHG = (CHG / BASE) * 100. Only compute for post-baseline records.
CHGCAT1Change from Baseline Category 1text

Decline >=5%-5.0%; Decline <5%<-5.0%; No declineDecline

See Parameter Value Metadata
SRCDOMSource Datatext

CV; LB

Assigned: Set to the SDTM domain name that relates to the analysis value.

SRCVARSource Variabletext

CVSTRESN; LBSTRESN

Assigned: Set to the SDTM variable that relates to the analysis value.

Jira
showSummaryfalse
serverIssue Tracker (JIRA)
serverId85506ce4-3cb3-3d91-85ee-f633aaaf4a45
keyTAUGDMDCIS-12
SRCSEQSource Sequence Numberinteger


Predecessor: Set to the SDTM domain sequence number that relates to the analysis value, CV.CVSEQ or LB.LBSEQ.

In this example, variables BASE, CHG, PCHG, and CHGCAT1 were added to facilitate analyses of the efficacy endpoints. the variables SRCDOM, SRCVAR, and SRCSEQ provide traceability to the combined source datasets. The tables below represent parameter value level lists for applicable variables.

Definexmltable
DatasetADEFNTP
Exampletrue
LevelCodelist
PurposeAnalysis
OIDPARAM.ADCVNTPADEFNTP
NameParameter
Permitted Value (code)

Left Ventricular Ejection Fraction, Cal (%)

Right Ventricular Ejection Fraction, Cal (%)
N-Terminal ProB-type Natriuretic Peptide (ng/L)
Definexmltable
DatasetADEFNTP
Exampletrue
LevelCodelist
PurposeAnalysis
OIDPARAMCD.ADEFNTP
NameParameter Code
Permitted Value (code)Display Value (Decode)

LVEF_C

Left Ventricular Ejection Fraction, Cal (%)

RVEF_CRight Ventricular Ejection Fraction, Cal (%)
BNPPRONTN-Terminal ProB-type Natriuretic Peptide (ng/L)
Definexmltable
DatasetADCVNTPADEFNTP
LevelVariableValue
PurposeAnalysis
NameAVAL
VariableWhereTypeControlled Terms or FormatOriginDerivation/Comment
AVALCV.CVSTRESN INin ("LVEF_C", "RVEF_C")float
PredecessorCV.CVSTRESN
AVALLB.LBTESTCD = "BNPPRONT"float
PredecessorLB.LBSTRESN

In this table the ADaM parameters are used rather than the source SDTM data.

Definexmltable
DatasetADCVNTPADEFNTP
LevelValue
PurposeAnalysis
NameCHGCAT1
VariableWhereTypeControlled Terms or FormatOriginDerivation/Comment
CHGCAT1PARAMCD in ("LVEF_C", "RVEF_C")text

Decline >=5%-5.0%;

Decline <5%<-5.0%;

No Decline

Derived

Categorize the value of CHG as follows: If CHG >= 5.00 THEN CHGCAT1 = "Decline >=5%-5.0%".

Jira
showSummaryfalse
serverIssue Tracker (JIRA)
serverId85506ce4-3cb3-3d91-85ee-f633aaaf4a45
keyTAUGDMDCIS-9

Else if CHG GT 0 and CHG < 5.00 THEN CHGCAT1 = "Decline <5%<-5.0%"

Else if CHG <0 then CHGCAT1 = "No Decline"

Jira
showSummaryfalse
serverIssue Tracker (JIRA)
serverId85506ce4-3cb3-3d91-85ee-f633aaaf4a45
keyTAUGDMDCIS-10

CHGCAT1PARAMCD = "BNPPRONT"text

Increase >100 ng/L;

Increase <=100 ng/L;

No increaseIncrease

Derived

Categorize the value of CHCAT1 as follows: "Increase >100 ng/L"; "Increase <=100 ng/L"; "No increaseIncrease"

Jira
showSummaryfalse
serverIssue Tracker (JIRA)
serverId85506ce4-3cb3-3d91-85ee-f633aaaf4a45
keyTAUGDMDCIS-11

Dataset wrap
Showtrue
NameadcvntpADEFNTP
Dataset2
tableidadefntp
RowSTUDYIDUSUBJIDAAGEAGEUSEXRACETRT01PTRT01AITTFLHEIGHTWEIGHTBSAACEINHFLPARAMPARAMCDPARAMNAVALAVISITAVISITNVISITADTABLFLBASECHGPCHGCHGCAT1SRCDOMSRCVARSRCSEQ
1DMD-EFLGEDMD-EF-01-10112.3YEARSMBLACK OR AFRICAN AMERICANDrug ADrug AY119200.82YLeft Ventricular Ejection Fraction, Cal (%)LVEF_C167Visit 1 (Baseline)1VISIT 116MAY20222022-05-16Y67


CVCVTESTCD
Jira
showSummaryfalse
serverIssue Tracker (JIRA)
serverId85506ce4-3cb3-3d91-85ee-f633aaaf4a45
keyTAUGDMDCIS-13
3
2DMD-EFLGEDMD-EF-01-10112.3YEARSMBLACK OR AFRICAN AMERICANDrug ADrug AY119200.82YRight Ventricular Ejection Fraction, Cal (%)RVEF_C274Visit 1 (Baseline)1VISIT 116MAY20222022-05-16Y74


CVCVTESTCD7
3DMD-EFLGEDMD-EF-01-10112.3YEARSMBLACK OR AFRICAN AMERICANDrug ADrug AY119200.82YN-Terminal ProB-type Natriuretic Peptide (ng/L)BNPPRONT340Visit 1 (Baseline)1VISIT 116MAY20222022-05-16Y40


LBLBTESTCD1
4DMD-EFLGEDMD-EF-01-10112.3YEARSMBLACK OR AFRICAN AMERICANDrug ADrug AY132321.08YLeft Ventricular Ejection Fraction, Cal (%)LVEF_C160Visit 6 (1 Year)6VISIT 606APR20232023-04-23
67-7-10.447761Decline >=-5.0%CVCVTESTCD11
5DMD-EFLGEDMD-EF-01-10112.3YEARSMBLACK OR AFRICAN AMERICANDrug ADrug AY132321.08YRight Ventricular Ejection Fraction, Cal (%)RVEF_C261Visit 6 (1 Year)6VISIT 606APR20232023-04-23
74-13-17.567568Decline >=-5.0%CVCVTESTCD15
6DMD-EFLGEDMD-EF-01-10112.3YEARSMBLACK OR AFRICAN AMERICANDrug ADrug AY132321.08Y

N-Terminal ProB-type Natriuretic Peptide (ng/L)

BNPPRONT3900Visit 6 (1 Year)6VISIT 606APR20232023-04-23
408602,150Increase >100 ng/LLBLBTESTCD2

ADEFMRI

The ADCVMR ADEFMRI 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 an ADaM Basic Data Structure (BDS) dataset

Jira
showSummaryfalse
serverIssue Tracker (JIRA)
serverId85506ce4-3cb3-3d91-85ee-f633aaaf4a45
keyTAUGDMDCIS-15
, with additional variables added from ADEFNTP dataset.

The dataset can can be used for multivariate analyses with multiple covariates

Jira
showSummaryfalse
serverIssue Tracker (JIRA)
serverId85506ce4-3cb3-3d91-85ee-f633aaaf4a45
keyTAUGDMDCIS-14
by taking the lab tests of interest (PARAMCD = "BNPPRONT") or other analysis datasets, and merging variables of interest with the ADEFNTP dataset. This summary dataset is created from other ADaM datasets and only variables used in the analysis are kept.

Definexmltable
DatasetADCVCMRADEFMRI
LevelVariable
PurposeAnalysis
NameVariable
Variable NameVariable LabelTypeCodelist/Controlled TermsSource/Derivation/Comment
STUDYIDStudy Identifiertext

Predecessor: ADEFNTP.STUDYID

USUBJIDUnique Subject Identifiertext

Predecessor: ADEFNTP.USUBJID

BRTHDTDate of Birthintegerdate9yymmdd10.

Predecessor: ADEFNTP.BRTHDT

AAGEAnalysis Agefloat

Predecessor: ADEFNTP.AAGE

AGEUAge UnittextYEARS

Predecessor: ADEFNTP.AGEU

SEX

Sextext(SEX)

Predecessor: ADEFNTP.SEX

RACE

Racetext(RACE)

Predecessor: ADEFNTP.RACE

TRTSDT

Date of First Exposure to Treatment

Numdate9yymmdd10.Predecessor: ADEFNTP.TRTSDT
TRT01P

Planned Treatment for Period 01

textDrug A; Drug BPredecessor: ADEFNTP.TRT01P

ITTFL

Intent-To-Treat Population Flag

text

Y; N

Predecessor: ADEFNTP.ITTFL

BSABody Surface Area (m2)float


Predecessor: ADEFNTP.BSA

ACEINHFL

ACE Inhibitor Medications Flag

text

Y; N

Predecessor: ADEFNTP.ACEINHFL

BNPPRONT


integer


Derived: BNPPRONT = AVAL where PARAMCD =   ADEFNTP.BNPPRONT, and merge by USUBJID and AVISITN.

Note: There are many ways to add this including transposing the data.

PARAMParametertext

Left Ventricular Ejection Fraction, Cal (%);

Right Ventricular Ejection Fraction, Cal (%)

Predecessor: ADEFNTP.PARAM

PARAMCDParameter Codetext

LVEF_C;

RVEF_C

Predecessor: ADEFNTP.PARAMCD

PARAMNParameter (N)integer


Predecessor: ADEFNTP.PARAMN

AVALAnalysis Valuefloat

Predecessor: ADEFNTP.AVAL

AVISITAnalysis Visittext

Visit 1 (Baseline);

Visit 6 (1 Year)

Predecessor: ADEFNTP.AVISIT

AVISITNAnalysis Visit (N)integer1; 6

Predecessor: ADEFNTP.AVISITN

ADTAnalysis Datefloatdate9yymmdd10.Predecessor: ADEFNTP.ADT
ABLFLBaseline Record FlagtextYPredecessor: ADEFNTP.ABLFL
BASEBaseline Valuefloat
Predecessor: ADEFNTP.BASE
CHGChange from Baselinefloat
Predecessor: ADEFNTP.CHG
PCHGPercent Change from Baselinefloat
Predecessor: ADEFNTP.PCHG
CHGCAT1Change from Baseline Category 1text

Decline >=5.0%;

Decline <5<-5.0%;

Increase >100 ng/L

Predecessor: ADEFNTP.CHGCAT1
Dataset wrap
Showtrue
Nameadefmri
Dataset2
tableidadefmri
RowSTUDYIDUSUBJIDBRTHDTTRT01PAAGEAGUSEXRACETRT01AITTFLBSAACEINHFLBNPPRONTPARAMPARAMCDPARAMNAVALAVISITAVISITNADTABLFLBASECHGPCHGCHGCAT1
1DMD-EFLGEDMD-EF-01-10107FEB20102010-02-07Drug A12.3YEARSMBLACK OR AFRICAN AMERICANDrug AY0.82Y40Left Ventricular Ejection Fraction, Cal (%)LVEF_C170Visit 1 (Baseline)116MAY20222022-05-16Y70


2DMD-EFLGEDMD-EF-01-10107FEB20102010-02-07Drug A12.3YEARSMBLACK OR AFRICAN AMERICANDrug AY0.82Y40Right Ventricular Ejection Fraction, Cal (%)RVEF_C275Visit 1 (Baseline)116MAY20222022-05-16Y75


3DMD-EFLGEDMD-EF-01-10107FEB20102010-02-07Drug A12.3YEARSMBLACK OR AFRICAN AMERICANDrug AY1.08Y900Left Ventricular Ejection Fraction, Cal (%)LVEF_C165Visit 6 (1 Year)606APR20232023-04-23
70-5-10.447761Decline >==5.0%
4DMD-EFLGEDMD-EF-01-10107FEB20102010-02-07Drug A12.3YEARSMBLACK OR AFRICAN AMERICANDrug AY1.08Y900Right Ventricular Ejection Fraction, Cal (%)RVEF_C270Visit 6 (1 Year)606APR20232023-04-23
75-5-17.567568Decline >==5.0%

Pagenav2