Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Added examples 1 and 2

...

The analysis 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.

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.

...

Should i use Male and 6 years? please advise.

Analysis Datasets

Below is the table of The table below presents the analysis datasets and unique parameters created generated for the this example. The Subject Level Analysis Dataset (ADSL is required as part of the process of creating the )  is a necessary component in the creation process of subsequent analysis datasets for human trials.

The ADSL includes incorporates demographics, treatment groups, study dates, and stratification variables. For In this example, the ADSL is not shown other than displayed directly but serves as a source for standard ADaM variables. See Additional information on this can be found in Section 2.3.1 of the ADaM Implementation Guide (ADaMIG) v1.3 for additional information.

The ADCVEF is a dataset capturing only the tests required for dataset selectively captures tests pertinent to this analysis, selecting for specifically those with CVTESTCD equal to "LVEF_C" or "RVEF_C". The relationship dataset RELREC shows the datset relationshipsillustrates the connections between datasets. There is exists a many-to-one relationship between the cardiovascular tests from (CV) and the laboratory data collected at during 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 (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. 

ADCVNTRP 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. By subsetting the Laboratory Results (LB) dataset with LBLNKID not missing, we can select laboratory data that aligns with CV data and sort using USUBJID and VISIT. If LBLNKID were not available, a windowing strategy could be employed to select the laboratory draw closest to that visit for merging with CV, computed in AVISIT.

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

BASIC DATA STRUCTURE

One record per subject per analysis visit per parameter.adcvntrp.xptUSUBJID, AVISITN, PARAMCDPARAMN

 Analysis Analysis Dataset

ADCMRICardiac Magnetic Resonance Imaging Measurements Summary Analysis Dataset

BASIC DATA STRUCTURE

One record per subject per analysis visit per parameter.adcmrief.xptUSUBJID, AVISITN, PARAMCDPARAMN

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". 
ADCVNTRPAVALPARAMCD = "BNPPRONT"NumPredecessorSet to LB.LBSTRESN where LB.LBTESTCD = "BNPPRONT"ADCMRI

Analysis Datasets

The following are subsequent section outlines the data structures for the example ADaM datasets. Note that the In this example, columns for derived variables, BASE, and CHG, PCHG and CHGCAT1 have been added for the efficacy analysis of fto facilitate analyses of efficacy endpoints. The Specifically, example demographics demographic data for ADSL were created for an 8 year old male child. Also, BSA at baseline (BSABASE), an example of a custom variable, was added from ADSL. 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 right 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.BSABSEBSABASECompute 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 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 1Char

>1.0 g(IU/dLL);

<=1.0 g/dL(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-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:Show the CMR ejection fraction measurements for participant 101 at VISIT 6.
Row 10: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 AY8YEARSMCV
10
15
6DMD-EFLGEDMD-EFLGE-10160.65N-Terminal ProB-type Natriuretic Peptide (IU/L)BNPPRONT3900Visit 6 (1 Year)6VISIT 11Jun2023
408602150>1.0 (IU/L)100900HIGHTreatment AY8YEARSMLB2

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 ADCVNTPR dataset. In that case, the records from LB are not needed as a row.

The variables transposed are:

DatasetValueWhere Variable Variable Label
ADCVNTPRAVALPARAMCD ="BNPPRONT"BNPPRONTN-Terminal ProB-type Natriuretic Peptide (IU/L)
ADCVNTPRCHGCAT1PARAMCD ="BNPPRONT"BNPPRCHGN-Term ProB-type N Pep Change Category
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:Show the CMR ejection fraction measurements for participant 101 at VISIT 6.
Row 10:Shows the NTProbTest for participant 101 at VISIT 6.
Dataset2
tableidadcvntpr
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-10140.65900>1.0 (IU/L)Left Ventricular Ejection Fraction, Calculated (%)LVEFC160Visit 6 (Month 12)6VISIT 601Jun2023
67-7-10.447761Treatment AY8YEARSMCV11
4DMD-EFLGEDMD-EFLGE-10150.65900>1.0 (IU/L)Right Ventricular Ejection Fraction, Calculated (%)RVEFC261Visit 6 (Month 12)6VISIT 601Jun2023
74-13-17.567568Treatment AY8YEARSMCV15
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

...