The data from the SDTM examples for ejection fraction can be used for multiple endpoint analyses.
For this example we show the following endpoints:
- CV - Percent change in ejection fraction, decline in EF over a time period (yearly) grouped by declinde greater than x%.
- LB - Percent change in NTproBNP over a period of time (yearly)
Questions:
Is screening considered visit 1, or is it to include the subject into the study?
Are these Real World Evidence (RWE) studies only or clinical trials?
Should both endpoints be shown in one efficacy dataset or two?
| Definexmltable |
|---|
| Multiple | true |
|---|
| Level | Dataset |
|---|
| Purpose | Analysis |
|---|
|
Dataset Name | Dataset Description | Class of Dataset | Structure | Location | Keys | Documentation |
|---|
| ADCMRI | Cardiac Magnetic Resonance Imaging Measurements Analysis Dataset | BASIC DATA STRUCTURE | One record per subject per analysis visit per parameter. | adcmri.xpt | USUBJID, AVISITN, PARAMCD | |
|
This example analysis dataset used the SDTM CV dataset for input which shows the findings associated with a Cardiac Magnetic Resonance Imaging procedure related to ejection fraction.
CVDTC is the date of the CMR procedure, CVDY is the study. For the purposes of this example, the participant was enrolled in the study on 20-May-2021 and the study visits were every twp months.The CVLNKID variable is used to identify a record to show a relationship between records in separate domains.
The following are the parameters for the example ADaM datasets. Note that the columns for derived variables, BASE, and CHG have been added, as well as selected variables from ADSL. The rows needed from the spirometry and 6MWT for ranking change from baseline were created in the safety analysis datasets. These derived rows were then copied to ADCOMPOS. The ADCOMPOS example shows the final rows required.
| Definexmltable |
|---|
| Dataset | ADSPIRO |
|---|
| Level | Variable |
|---|
| Purpose | Analysis |
|---|
| Name | Variable |
|---|
|
| Variable Name | Variable Label | Type | Codelist/Controlled Terms/Format | Source | Derivation/Comment |
|---|
| STUDYID | Study Identifier | Char |
| CV.STUDYID |
| | USUBJID | Unique Subject Identifier | Char |
| | Select for records with RE data. | ASEQ | Analysis Sequence Number | Num |
|
| Sequence number given to ensure uniqueness of subject records within an ADaM dataset. Number the records 1 to n after sorting by the key variables. | | ASEQ | Analysis Sequence Number | Num |
|
| xxxxxxx | | TRT01P | Planned Treatment for Period 01 | Char |
| ADSL.TRT01P |
| COMPLFL | Completers Population Flag | Char | Y; N | ADSL.COMPLFL | | | AGE | Age | Num |
| ADSL.AGE |
| | AGEU | Age Units | Char | (AGEU) | ADSL.AGEU |
| | SEX | Sex | Char | (SEX) | ADSL.SEX |
| | PARAM | Parameter | Char | Left Ventricular Ejection Fraction, Calculated (%) Right Ventricular Ejection Fraction, Calculated (%) N-Terminal ProB-type Natriuretic Peptide (pg/mL)
|
| Move to PVLM Table Set to "CV.CVTEST" plus "(CV.CVTESTU)" with spaces and parentheses as shown.
Set to "LB.LBTEST" plus "(CV.CVTESTU)" with spaces and parentheses as shown. | | PARAMCD | Parameter Code | Char | LVEFC RVEFC BNPPRONT
|
| If CV.CVTESTCD = "LVEF_C" then PARAMCD = "LVEFC" If CV.CVTESTCD = "RVEF_C" then PARAMCD = "RVEFC" If LB.LBTESTCD = "BNPPRONT" then PARAMCD = "BNPPRONT" Set to value of CV.CVTESTCD.
| | AVAL | Analysis Value | Num |
|
| Set to value of CV.CVSTRESN. Set to value of LB.LBSTRESN. | | AVISIT | Analysis Visit | Char | ?????? |
| If CV.VISIT = "VSCREENING" then AVISIT = "XXX". Else if CV.VISIT = "VISIT 6" then AVISIT = "XXXX". | | AVISITN | Analysis Visit (N) | Num | 1, 6 |
| Set to value of CV.VISITNUM. | | VISIT | Visit | Char |
| |
| | ADT | Analysis Date | Num | date9. |
| Date portion of CV.CVDTC converted to numeric and displayed in a format such as date9. Date in SDTM represents date of CMR procedure. | | ABLFL | Baseline Record Flag | Char | Y |
| Check on visit numbering If VISIT = 1 then ABLFL = "Y". | | BASE | Baseline Value | Num |
|
| Set BASE to AVAL from the record for that subject and parameter where ABLFL = "Y". | | CHG | Change from Baseline | Num |
|
| Compute CHG = AVAL - BASE for that record. Only compute for post-baseline records. | | PCHG | Percent Change from Baseline | Num |
|
| PCHG = (CHG / BASE) * 100 | | CHGCAT1 | Change from Baseline Category 1 |
| >1 g/dL; <=1 g/dL |
|
| | SRCDOM | Source Data | Char | CV LB |
| Set to the SDTM domain name that relates to the analysis value. | | SRCSEQ | Source Sequence Number | Num | CV.CVSEQ LB.LBSEQ |
| Set to the SDTM domain sequence number that relates to the analysis value. |
|
| Definexmltable |
|---|
| Multiple | true |
|---|
| Dataset | ADSPIRO, AD6MWT, ADCOMPOS |
|---|
| Level | Value |
|---|
| Purpose | Analysis |
|---|
| OID | AVAL |
|---|
| Name | Parameter Value List - ADCOMPOS |
|---|
|
| Dataset | Variable | Where | Type | Origin | Derivation/Comment |
|---|
| ADCMRI | AVAL | PARAMCD = " XXXX" | Num | Derived | Within each component (FVCPP), the change from baseline value is sorted by lowest CHG, then ranked across all pooled subjects. The lowest change value is assigned a rank of 1, the next lowest a rank of 2, and so on. | | ADCMRI | AVAL | PARAMCD = "XXXX" | Num | Predecessor | Set to CV.CVSTRESN where CV.CVTESTCD = "FVC". | | ADCMRI | AVAL | PARAMCD = "NTPROBNP" | Num | Predecessor | Set to CV.CVSTRESN where CV.CVTESTCD = "FVCPP". |
|
| Dataset wrap |
|---|
|
| Rowcaps |
|---|
| Rows 1-8: | Show the baseline CMR ejection fraction measurements for participant 101 at Screening. | | Rows 9-16: | Show the CMR ejection fraction measurements for participant 101 at VISIT 6. |
|
| Dataset2 |
|---|
| | Row | STUDYID | USUBJID |
|
|
|
| PARAMCD | PARAM | AVAL | CVMETHOD | VISITNUM | VISIT | ADT | ABLFL | BASE | CHG | PCHG | CHGCAT | SRCDOM | SRCSEQ |
|---|
| 1 | DMD-EFLGE | 101 |
|
|
|
| LVEF_C | Left Ventricular Ejection Fraction, Calculated (%) | 67 | CARDIAC MAGNETIC RESONANCE IMAGING | 1 | SCREENING | 2022-05-16 | Y | 67 |
|
|
| CV | 3 | | 2 | DMD-EFLGE | 101 |
|
|
|
| LVCO | LV Cardiac Output (L/min) | 5.4 | CARDIAC MAGNETIC RESONANCE IMAGING | 1 | SCREENING | 2022-05-16 | Y | 5.4 |
|
|
| CV | 4 | | 3 | DMD-EFLGE | 101 |
|
|
|
| RVEF_C | Right Ventricular Ejection Fraction, Calculated (%) | 74 | CARDIAC MAGNETIC RESONANCE IMAGING | 1 | SCREENING | 2022-05-16 | Y | 74 |
|
|
| CV | 7 | | 4 | DMD-EFLGE | 101 |
|
|
|
| RVCO | RV Cardiac Output (L/min) | 5.6 | CARDIAC MAGNETIC RESONANCE IMAGING | 1 | SCREENING | 2022-05-16 | Y | 67 |
|
|
| CV | 8 | | 5 | DMD-EFLGE | 101 |
|
|
|
| BNPPRONT | N-Terminal ProB-type Natriuretic Peptide (pg/mL) |
| | 1 | SCREENING | 2022-05-16 | Y |
|
|
|
| LB | 1 | | 6 | DMD-EFLGE | 101 |
|
|
|
| LVEF_C | Left Ventricular Ejection Fraction, Calculated (%) | 60 | CARDIAC MAGNETIC RESONANCE IMAGING | 6 | VISIT 6 | 2023-06-01 | Y | 5.4 |
|
|
| CV | 11 | | 7 | DMD-EFLGE | 101 |
|
|
|
| LVCO | LV Cardiac Output (L/min) | 4.0 | CARDIAC MAGNETIC RESONANCE IMAGING | 6 | VISIT 6 | 2023-06-01 | Y | 74 |
|
|
| CV | 12 | | 8 | DMD-EFLGE | 101 |
|
|
|
| RVEF_C | Right Ventricular Ejection Fraction, Calculated (%) | 61 | CARDIAC MAGNETIC RESONANCE IMAGING | 6 | VISIT 6 | 2023-06-01 | Y |
|
|
|
| CV | 15 | | 9 | DMD-EFLGE | 101 |
|
|
|
| RVCO | RV Cardiac Output (L/min) | 4.0 | CARDIAC MAGNETIC RESONANCE IMAGING | 6 | VISIT 6 | 2023-06-01 | Y |
|
|
|
| CV | 16 | | 10 | DMD-EFLGE | 101 |
|
|
|
| BNPPRONT | N-Terminal ProB-type Natriuretic Peptide (pg/mL) |
| | 6 | VISIT 6 | 2023-06-01 | Y |
|
|
|
| LB | 2 |
|
|
(Copied from the SDTM page for reference until I create the sample ADaM dataset
| Dataset wrap |
|---|
|
| Rowcaps |
|---|
| Rows 1-8: | Show the baseline CMR ejection fraction measurements for participant 101 at Screening. | | Rows 9-16: | Show the CMR ejection fraction measurements for participant 101 at VISIT 6. |
|
| Dataset2 |
|---|
| | Row | STUDYID | DOMAIN | USUBJID | CVSEQ | CVLNKID | CVTESTCD | CVTEST | CVORRES | CVORRESU | CVSTRESC | CVSTRESN | CVSTRESU | CVMETHOD | VISITNUM | VISIT | CVDTC | CVDY |
|---|
| 1 | DMD-EFLGE | CV | 101 | 1 |
| LVESV | Left Ventricle End Systolic Volume | 32 | mL | 32 | 32 | mL | CARDIAC MAGNETIC RESONANCE IMAGING | 1 | SCREENING | 2022-05-16 |
| | 2 | DMD-EFLGE | CV | 101 | 2 |
| LVEDV | Left Ventricle End Diastolic Volume | 95 | mL | 95 | 95 | mL | CARDIAC MAGNETIC RESONANCE IMAGING | 1 | SCREENING | 2022-05-16 |
| | 3 | DMD-EFLGE | CV | 101 | 3 | 2 | LVEF_C | Left Ventricular Ejection Fraction, Calculated | 67 | % | 67 | 67 | % | CARDIAC MAGNETIC RESONANCE IMAGING | 1 | SCREENING | 2022-05-16 |
| | 4 | DMD-EFLGE | CV | 101 | 4 | 2 | LVCO | LV Cardiac Output | 5.4 | L/min | 5.4 | 5.4 | L/min | CARDIAC MAGNETIC RESONANCE IMAGING | 1 | SCREENING | 2022-05-16 |
| | 5 | DMD-EFLGE | CV | 101 | 5 |
| RVESV | Right Ventricle End Systolic Volume | 24 | mL | 24 | 24 | mL | CARDIAC MAGNETIC RESONANCE IMAGING | 1 | SCREENING | 2022-05-16 |
| | 6 | DMD-EFLGE | CV | 101 | 6 |
| RVEDV | Right Ventricle End Diastolic Volume | 90 | mL | 90 | 90 | mL | CARDIAC MAGNETIC RESONANCE IMAGING | 1 | SCREENING | 2022-05-16 |
| | 7 | DMD-EFLGE | CV | 101 | 7 | 2 | RVEF_C | Right Ventricular Ejection Fraction, Calculated | 74 | % | 74 | 74 | % | CARDIAC MAGNETIC RESONANCE IMAGING | 1 | SCREENING | 2022-05-16 |
| | 8 | DMD-EFLGE | CV | 101 | 8 | 2 | RVCO | RV Cardiac Output | 5.6 | L/min | 5.6 | 5.6 | L/min | CARDIAC MAGNETIC RESONANCE IMAGING | 1 | SCREENING | 2022-05-16 |
| | 9 | DMD-EFLGE | CV | 101 | 9 |
| LVESV | Left Ventricle End Systolic Volume | 37 | mL | 37 | 37 | mL | CARDIAC MAGNETIC RESONANCE IMAGING | 6 | VISIT 6 | 2023-06-01 | 376 | | 10 | DMD-EFLGE | CV | 101 | 10 |
| LVEDV | Left Ventricle End Diastolic Volume | 94 | mL | 94 | 94 | mL | CARDIAC MAGNETIC RESONANCE IMAGING | 6 | VISIT 6 | 2023-06-01 | 376 | | 11 | DMD-EFLGE | CV | 101 | 11 | 2 | LVEF_C | Left Ventricular Ejection Fraction, Calculated | 60 | % | 60 | 60 | % | CARDIAC MAGNETIC RESONANCE IMAGING | 6 | VISIT 6 | 2023-06-01 | 376 | | 12 | DMD-EFLGE | CV | 101 | 12 | 2 | LVCO | LV Cardiac Output | 4.0 | L/min | 4.0 | 4.0 | L/min | CARDIAC MAGNETIC RESONANCE IMAGING | 6 | VISIT 6 | 2023-06-01 | 376 | | 13 | DMD-EFLGE | CV | 101 | 13 |
| RVESV | Right Ventricle End Systolic Volume | 36 | mL | 36 | 36 | mL | CARDIAC MAGNETIC RESONANCE IMAGING | 6 | VISIT 6 | 2023-06-01 | 376 | | 14 | DMD-EFLGE | CV | 101 | 14 |
| RVEDV | Right Ventricle End Diastolic Volume | 93 | mL | 93 | 93 | mL | CARDIAC MAGNETIC RESONANCE IMAGING | 6 | VISIT 6 | 2023-06-01 | 376 | | 15 | DMD-EFLGE | CV | 101 | 15 | 2 | RVEF_C | Right Ventricular Ejection Fraction, Calculated | 61 | % | 61 | 61 | % | CARDIAC MAGNETIC RESONANCE IMAGING | 6 | VISIT 6 | 2023-06-01 | 376 | | 16 | DMD-EFLGE | CV | 101 | 16 | 2 | RVCO | RV Cardiac Output | 4.0 | L/min | 4.0 | 4.0 | L/min | CARDIAC MAGNETIC RESONANCE IMAGING | 6 | VISIT 6 | 2023-06-01 | 376 |
|
|
| 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: Ejection Fraction Basic CMR tests - Systolic Function |