Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Definexmltable
DatasetADCVNTP
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.
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 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.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. (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 carrying forward the value of BASE in the baseline record by USUBJID and AVISIT.

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



Categorize the value of CHG for N-Terminal ProB-type Natriuretic Peptide (pg/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.

...

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.

Definexmltable
DatasetADCVCMR
LevelValue
PurposeAnalysis
OIDAVAL
DatasetValueWhere Variable Variable Label
ADCVCMRAVALPARAMCD = "BNPPRONT"BNPPRONTN-Terminal ProB-type Natriuretic Peptide (IU/L)
ADCVCMRCHGPARAMCD = "BNPPRONT"BNPCHGN-Term ProB-type N Pep Change Category
Dataset wrap
Nameadcvcmr
Dataset2
tableidadcvcmr
RowSTUDYIDUSUBJIDASEQBRTHDTTRT01PITTFLBSABASEACEINHFLBSABNPPRONTBNPCHGPARAMPARAMCDPARAMNAVALAVISITAVISITNVISITADTABLFLBASECHGPCHGSRCDOMSRCSEQ
1DMD-EFLGEDMD-EFLGE-101115FEB2013Treatment AY0.65Y
40
Left Ventricular Ejection Fraction, Calculated (%)LVEFC167Visit 1 (Baseline)1VISIT 116MAY2022Y67

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

CV7
3DMD-EFLGEDMD-EFLGE-101315FEB2013Treatment AY0.65Y
9002150Left Ventricular Ejection Fraction, Calculated (%)LVEFC160Visit 6 (1 Year)6VISIT 606APR2023
67-7-10.447761CV11
4DMD-EFLGEDMD-EFLGE-101415FEB2013Treatment AY0.65Y
9002150Right Ventricular Ejection Fraction, Calculated (%)RVEFC261Visit 6 (1 Year)6VISIT 606APR2023
74-13-17.567568CV15

...

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. A simple comparison of change by treatment groups over one year.

Display

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

Analysis ResultComparison of Percent Change of Ejection Fraction for the Treatment Groups (1 Year)
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" and AVISITN = 6;

Documentation

Comparison of Means with 95% confidence interval

Programming Statements 

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

/* Subset the data */

DATA ONE;

SET ADCVCMR;

Where ITTFL = "Y" and AVISITN = 2;

RUN;

PROC MEANS DATA=ONE MEAN STD MEDIAN ;

CLASS TRT01P;

VAR LVEF;  /*  Could add RVEF here as well */

RUN;

Table 2. This table demonstrates a model over multiple time points, adding some of the covariates that were retained in the analysis dataset.

Display

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

Analysis ResultComparison of Percent Change of Ejection Fraction 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 = "LVEFC"

Where ITTFL = "Y"

Documentation

 The mixed model using lsmeans to compare treatment groups

Programming Statements 

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

/* Note that PCHG is only computed post-baseline, so subset for the yearly visits, i.e. 6, 12, 18 etc. */

DATA TWO;

SET ADCVCMR;

IF PARAMCD = "LVEFC"; /* Subset by param, as there are two parameters with CHG calculated*/

Where ITTFL = "Y" and AVISITN = 2;

RUN;


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;

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

...