Versions Compared

Key

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

...

Definexmltable
DatasetADSL
LevelVariable
PurposeAnalysis
NameVariable
Variable NameVariable LabelTypeCodelist/Controlled Terms/FormatSourceDerivation/Comment
STUDYIDStudy IdentifierChar

DM.STUDYID


USUBJIDUnique Subject IdentifierChar

DM.USUBJID


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.)
TRTSDTDate of First Exposure to TreatmentNumdate9.
Date portion of DM.RFSTDTC converted to numeric and displayed in a format such as DATE9.
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

Derive the intent-to-treat population as per the protocol and SAP.
BSABASEBody Surface Area (m2) at BaselineNum
ADSL.BSABASE

Set to VS.VSSTRESN in ADSL where VS.VSTESTCD = "BSA" and select for baseline visit.

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.

...

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 copying carrying forward the value of BASE in the baseline record by USUBJID and ADT. (Or by AVISIT if ADT varies for labs, where windowing is applied to select record closest to the visit)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.

...