You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 60 Next »

This section illustrates example analysis datasets for the following endpoints:

  • Percent change in ejection fraction over time
  • Decline in ejection fraction over a time period (1 year) grouped by a decline greater than 10.0%.
  • Percent change in NTproBNP over a period of time (1 year)

Source Data

The SDTM examples used as the source data are from Section 2.1, Basic CMR Tests for Systolic Function. The CV dataset contains 16 rows, 1-8 for visit 1 and 9-16 for visit 6. Of these rows, the CVTESTCD = "LVEF_C" and CVTESTCD = "RVEF_C" representing the Ventricular Ejection Fraction, Calculated (%) for left and right were selected for the analysis. The LB dataset test where LBTESTCD = "BNPPRONT" was used to add the value of BNPPRONT to compute the percent change over time, and then it was added as a potential covariate in each row for the last analysis. As in all ADaM datasets, the Subject Level Analysis Dataset (ADSL) was merged in to the SDTM datasets to capture all the necessary demographics, treatments and other required variables for analysis of the data.

Example Analysis Datasets

The analysis datasets for this example include treatment and demographic information drawn from the Subject Level Analysis Dataset (ADSL), defined in the Metadata Tables below. Only some of the required variables from ADSL are shown for illustrative purposes. The ADSL incorporates demographics, treatment groups, study dates, and stratification variables.  Additional information on the ADSL can be found in Section 2.3.1 of the ADaM Implementation Guide (ADaMIG) v1.3.

The ADSL is combined with other SDTM dataset to create the analysis datasets. More than one SDTM dataset can be combined in this way. Also, stratification variables can be created in the ADSL to subset by, or to add variables needed in the analyses. For instance,  stratification variable might be type of concomitant medications, such as an ACE inhibitors. for this we added a flag ACEMEDFL, which is coded Y or N. Another variable added; body surface area (BSABL), is derived from the LB dataset at the baseline visit and added to ADSL. However, when the subjects are children, the body surface area changes over time. Therefore, an additional non-standard variable is added to the analysis dataset with the subject's current BSA by visit. 

The ADCVNTP dataset includes tests pertinent to these analyses. The record LB are selected where CVTESTCD is equal to "LVEF_C" or "RVEF_C".  It also includes a subset of the Laboratory Results (LB) SDTM dataset, for which LBTESTCD is equal to "BNPPRONT". The relationship dataset RELREC illustrates the relationship between datasets. In this case, many lab draws may occur throughout the year, but only those linked to a specific visit are included. By subsetting the LB dataset with 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, a windowing strategy could be used to select the laboratory draw closest to that visit for merging with CV, computed in AVISIT. In the example, only two LB records are shown which are linked to CV where CVTESTCD = "LVEF_C" or CVTESTCD = "R.VEF_C"

ADCVMR 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, with additional variables added from ADCVNTP.

The tableS below showsthe example analysis dataset metadata and parameters used for the analysis. 

Analysis Datasets

ADSL Analysis Dataset


ADSL Variable Metadata

shown below is an abbreviated specification of ADSL for the example. As mentioned, only a few of the required variables are shown.

$titleHtml

adsl.xpt

RowSTUDYIDUSUBJIDBRTHDTTRTSDTTRT01PITTFLBSABASEACENHFL
1DMD-EFLGEDMD-EFLGE-10115FEB202116MAY2022Treatment AY0.65Y
$warningHtml


Parameter Value List - ADCVNTP [ADCVNTP]

Analysis Datasets for Ejection Fraction

The subsequent section provides the data structures for the example ADaM datasets. In this example, columns for derived variables BASE, CHG, PCHG and CHGCAT1 have been added to facilitate analyses of the efficacy endpoints. Specifically, example demographic data for ADSL were created for an 8 year old male. Also, a custom variable for BSA at baseline (BSABASE), and an example of a stratification variable for subjects with was added from ADSL.

ADCVNTP Variable Metadata

Example 1 

This example dataset shows the findings and additional analysis variables associated with:

  • Left Ventricular Ejection Fraction, Calculated (%)
  • Right Ventricular Ejection Fraction, Calculated (%)
  • N-Terminal ProB-type Natriuretic Peptide (pg/mL)

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.
$titleHtml

adcvntp.xpt

RowSTUDYIDUSUBJIDASEQBRTHDTTRT01PITTFLBSABASEACEINHFLBSAPARAMPARAMCDPARAMNAVALAVISITAVISITNVISITADTABLFLBASECHGPCHGCHGCAT1SRCDOMSRCSEQ
1DMD-EFLGEDMD-EFLGE-101115FEB2021Treatment AY0.65Y0.65Left Ventricular Ejection Fraction, Calculated (%)LVEFC167Visit 1 (Baseline)1VISIT 116MAY2022Y67


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


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


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

Dataset Debug Message

Please remove all formatting (see How to Clear Formatting).

Dataset Wrapper Debug Message

Please add a row column to your dataset.

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.


DatasetValueWhere Variable Variable Label
ADCVCMRAVALPARAMCD = "BNPPRONT"BNPPRONTN-Terminal ProB-type Natriuretic Peptide (IU/L)
ADCVCMRCHGPARAMCD = "BNPPRONT"BNPCHGN-Term ProB-type N Pep Change Category

$titleHtml

adcvcmr.xpt

RowSTUDYIDUSUBJIDASEQTRT01PITTFLBSABASEACEINHFLBSABNPPRONTBNPCHGPARAMPARAMCDPARAMNAVALAVISITAVISITNVISITADTABLFLBASECHGPCHGSRCDOMSRCSEQ
1DMD-EFLGEDMD-EFLGE-1011Treatment AY0.65Y
40
Left Ventricular Ejection Fraction, Calculated (%)LVEFC167Visit 1 (Baseline)1VISIT 116MAY2022Y67

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

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

Example Analysis Results Metadata (ARM) Tables

For more details on ARM, see the ADaMIG and the Analysis Results Metadata (ARM) v1.0 for Define-XML v2.0 (https://www.cdisc.org/standards/foundational/adam).

Table 1

Display

Table 14.xx.xx Percent Change in Left Ventricular Ejection Fraction Over Time

Analysis ResultComparison of Percent Change of Ejection Fraction for the Treatment Groups Over Time (quarterly or yearly)
Analysis Variables(s)PCHG
Analysis ReasonPrimary efficacy endpoint as prespecified in the SAP
Analysis PurposePrimary outcome measure

Data References

(incl. selection criteria)

PARAMCD = "LVEFC"

Where ITTFL = "Y"

Documentation

 The mixed model using lsmeans to compare treatment groups

Programming Statements 

(Add programming language statements here: SAS, R, etc.)

PROC MIXED DATA=ADCVCMR;

CLASS STUYDID TRT01P AVISITN;

MODEL PCHG=AVISITN*TRT01P/Solution;

RANDOM INTERCEPT / SUBJECT=STUYDID TYPE=UN;

LSMEANS TRT01P*AVISITN/ CL PDIFF;

RUN;


Table 2, ADD SOME COVARIATES TO THE MODEL

Display

Table 14.xx.xx Percent Change in Left Ventricular Ejection Fraction Over Time

Analysis ResultComparison of Percent Change of Ejection Fraction for the Treatment Groups Over Time (quarterly or yearly)
Analysis Variables(s)PCHG
Analysis ReasonPrimary efficacy endpoint as prespecified in the SAP
Analysis PurposePrimary outcome measure

Data References

(incl. selection criteria)

PARAMCD = "LVEFC"

Where ITTFL = "Y"

Documentation

 The mixed model using lsmeans to compare treatment groups

Programming Statements 

(Add programming language statements here: SAS, R, etc.)

PROC MIXED DATA=ADCVNTP;

CLASS STUYDID TRT01P AVISITN;

MODEL PCHG=AVISITN*TRT01P/Solution;

RANDOM INTERCEPT / SUBJECT=STUYDID TYPE=UN;

LSMEANS TRT01P*AVISITN/ CL PDIFF;

RUN;


Move to table 3  This example uses the dataset ADCVNTP, selecting for the parameter "N-Terminal ProB-type Natriuretic Peptide (IU/L)".

Display

Table 14.xx.xx Percent change in NTproBNP over a period of time (yearly)

Analysis ResultComparison of Percent Change of NTproBNP for the Treatment Groups Over Time (yearly)
Analysis Variables(s)PCHG
Analysis ReasonPrimary efficacy endpoint as prespecified in the SAP
Analysis PurposePrimary outcome measure

Data References

(incl. selection criteria)

PARAMCD = "BNPPRONT"

Where ITTFL = "Y"

Documentation

 The mixed model using lsmeans to compare treatment groups

Programming Statements 

(Add programming language statements here: SAS, R, etc.)

PROC MIXED DATA=ADCVNTP;

WHERE PARAMCD = "BNPPRONT";

CLASS STUYDID TRT01P AVISITN;

MODEL PCHG=AVISITN*TRT01P/Solution;

RANDOM INTERCEPT / SUBJECT=STUYDID TYPE=UN;

LSMEANS TRT01P*AVISITN/ CL PDIFF;

RUN;

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 for Systolic Function

  • No labels