Versions Compared

Key

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

...

Dataset wrap
Nameex
Dataset2
RowSTUDYIDDOMAINUSUBJIDEXSEQSPTOBIDEXREFIDEXTRTEXDOSEEXDOSUEXDOSFRMEXROUTEEXPSTRGEXPSTRGUEXSTDTCEXENDTC
1A123EXA20011VAPE-Z27CRT8754e-nicotine liquid6mLCARTRIDGERESPIRATORY (INHALATION)0mg/mL2021-01-082020-01-14
2A123EXA20012VAPE-Z27CRT8768e-nicotine liquid6.4mLCARTRIDGERESPIRATORY (INHALATION)0mg/mL2021-01-152020-01-21
3A123EXA20013VAPE-Z27CRT9756e-nicotine liquid7mLCARTRIDGERESPIRATORY (INHALATION)0mg/mL2021-01-222020-01-28
4A123EXA20081VAPE-Z27CRT8000e-nicotine liquid5mLCARTRIDGERESPIRATORY (INHALATION)8mg/mL20221-02-082021-02-14
5A123EXA20082VAPE-Z27CRT9006e-nicotine liquid7mLCARTRIDGERESPIRATORY (INHALATION)8mg/mL20221-02-152021-02-21
6A123EXA20083VAPE-Z27CRT9008e-nicotine liquid8mLCARTRIDGERESPIRATORY (INHALATION)8mg/mL20221-02-222021-03-01
7A123EXA30091VAPE-Z27CRT9128e-nicotine liquid8mLCARTRIDGERESPIRATORY (INHALATION)4mg/mL2021-06-092021-06-15
8A123EXA30092VAPE-Z27CRT6868e-nicotine liquid6.7mLCARTRIDGERESPIRATORY (INHALATION)4mg/mL2021-06-1620202021-1006-15
9TENDS01EXA30093VAPE-Z27CRT7868e-nicotine liquid5.5mLCARTRIDGERESPIRATORY (INHALATION)4mg/mL2020-10-152020-10-22
23

This is an example of the ADEX dataset and associated metadata.   

Dataset wrap
NameADEX
Dataset2
STUDYIDUSUBJIDASTDTAENDTASTDYAENDYEXSTDTCEXENDTCTRTPEXTRTEXDOSEEXDOSUSAFFLEXSEQ
TENDS01A123TEN01001A2001



2020-06-262020-07-01Product APlaceboe-nicotine liquid6mLY1
TENDS01A123TEN01001A2001



2020-07-012020-07-06Product APlaceboe-nicotine liquid6.4mLY2
TENDS01A123TEN01001A2001



2020-07-062020-07-10Product APlacebo e-nicotine liquid7mLY3
TENDS01A123TEN01001A2008



2020-07-102020-07-14Product Ae-nicotine liquid8mLY4
TENDS01A1231TEN10002A2008



2020-09-012020-09-07Product BAe-nicotine liquid5mLY1
TENDS01A123TEN10002A2008



2020-09-072020-09-14Product BAe-nicotine liquid7mLY2
TENDS01A123TEN10002A3009



2020-09-142020-09-21Product Be-nicotine liquid8mLY3
TENDS01A123TEN10002A3009



2020-09-212020-09-28Product Be-nicotine liquid6mLY4TENDS01TEN100022020-09-282020-09-31Product Be-nicotine liquid7mLY5TENDS01TEN100022020-10-312020-10-08Product Be-nicotine liquid8mLY6TENDS01TEN100022020-10-082020-10-15Product Be-nicotine liquid6.7mLY7TENDS01TEN100022020-10-152020-10-22Product Be-nicotine liquid5.5mLY8
Definexmltable
LevelDataset
PurposeAnalysis
NameADEX
DatasetDescriptionClassStructurePurposeKeysLocationDocumentation
ADEX
SETOne record per subjectAnalysis
ADEX.xptADEX.SAS/SAP
DM
Definexmltable
DatasetADEX
LevelVariable
PurposeAnalysis

Variable Name

Variable LabelTypeCodelist/Controlled TermsCoreCDISC Notes
STUDYIDStudy Identifier
Char
text
Req


EX.STUDYID
USUBJIDUnique Subject Identifier
CharDM
text
Req


EX.USUBJID
SUBJIDSubject Identifier for the StudyCharReqDM.SUBJIDSITEIDStudy Site IdentifierCharReqDM.SITEIDAGEAgeNumReqDM.AGE. If analysis needs require a derived age that does not match DM.AGE, then AAGE must be addedAGEUAge UnitsChar(AGEU)ReqDM.AGEUAGEGRyPooled Age Group yCharPermCharacter description of a grouping or pooling of the subject's age for analysis purposes. For example, AGEGR1 might have values of "<18", "18-65", and ">65"; AGEGR2 might have values of "Less than 35 y old" and "At least 35 y old".SEXSexCharSEX)ReqDM.SEXRACERaceChar(RACE)ReqDM.RACERACEGRyPooled Race Group yCharPermCharacter description of a grouping or pooling of the subject's race for analysis purposes.ETHNICEthnicityCharPermDM.ETHNICSAFFLSafety Population FlagCharY; NCondY if ADSL.TR01SDT is not null, otherwise NPPROTFLPer-Protocol Population FlagCharY; NCondY if ADSL.SAFFL=Y and at least one post-baseline assessment was done, otherwise NRANDFLRandomized Population FlagCharY; NCondY if the subject was randomized, otherwise NARMDescription of Planned ArmCharReqDM.ARMACTARMDescription of Actual ArmCharPermDM.ACTARMTRTxxPPlanned Treatment for Period xxCharReqSubject-level identifier that represents the planned treatment for period xx. In a one-period randomized trial, TRT01P would be the treatment to which the subject was randomized. TRTxxP might be derived from the SDTM DM variable ARM. At least TRT01P is required.TRTxxPNPlanned Treatment for Period xx (N)NumPermNumeric representation of TRTxxP. There must be a one-to-one relationship between TRTxxPN and TRTxxP within a study.
TRTxxPN cannot be present unless TRTxxP is also present. When TRTxxP and TRTxxPN are present, then on a given record, either both must be populated or both must be null.TRTxxAActual Treatment for Period xxCharCondSubject-level identifier that represents the actual treatment for the subject for period xx. Required when actual treatment does not match planned and there is an analysis of the data as treated.TRTxxANActual Treatment for Period xx (N)NumPerm

Numeric representation of TRTxxA. There must be a one-to-one relationship between TRTxxAN and TRTxxA within a study.

TRTxxAN cannot be present unless TRTxxA is also present. When TRTxxA and TRTxxAN are present, then on a given record, either both must be populated or both must be null.

TRTSEQPCharCondRequired when there is an analysis based on the sequence of treatments, for example in a crossover design. TRTSEQP is not necessarily equal to ARM, for example if ARM contains elements that are not relevant to analysis of treatments or ARM is not fully descriptive (e.g., "GROUP 1," "GROUP 2"). When analyzing based on the sequence of treatments, TRTSEQP is required even if identical to ARM.TRTSDTDate of First Exposure to TreatmentNumCondDate of first exposure to treatment for a subject in a study. TRTSDT and/or TRTSDTM are required if there is an investigational product. Note that TRTSDT is not required to have the same value as the SDTM DM variable RFXSTDTC. While both of these dates reflect the concept of first exposure, the ADaM date may be derived to support the analysis which may not necessarily be the very first date in the SDTM EX domain.TRTSDTMDatetime of First Exposure to TreatmentNumCondDatetime of first exposure to treatment for a subject in a study. TRTSDT and/or TRTSDTM are required if there is an investigational product.TRTEDTDate of Last Exposure to TreatmentNumCondDate of last exposure to treatment for a subject in a study. TRTEDT and/or TRTEDTM are required if there is an investigational product. Note that TRTEDT is not required to have the same value as the SDTM DM variable RFXENDTC. While both of these dates reflect the concept of last exposure, the ADaM date may be derived to support the analysis which may not necessarily be the very last date in the SDTM EX domain.TRTEDTMDatetime of Last Exposure to TreatmentNumCondDatetime of last exposure to treatment for a subject in a study. TRTEDT and/or TRTEDTM are required if there is an investigational product.TRxxSDTDate of First Exposure in Period xxNumCondDate of first exposure to treatment in period xx. TRxxSDT and/or TRxxSDTM are only required in trial designs where multiple treatment periods are defined (i.e., required when there is a TRTxxP other than TRT01P). Examples include crossover designs or designs where multiple periods exist for the same treatment.TRxxEDTDate of Last Exposure in Period xxNumCondDate of last exposure to treatment in period xx. TRxxEDT and/or TRxxEDTM are only required in trial designs where multiple treatment periods are defined (i.e., required when there is a TRTxxP other than TRT01P).APHASEwDescription of Phase wCharPermDescription of analysis phase w. Analysis phase is independent of TRTxxP within ADSL, and may be populated for spans of time where a subject is not on treatment.EOSSTTEnd of Study StatusChar(SBJTSTAT)PermThe subject's status as of the end of study or data cutoff. Examples: COMPLETED, DISCONTINUED, ONGOING.EOSDTEnd of Study DateNumPermDate subject ended the study - either date of completion or date of discontinuation or data cutoff date for interim analyses.DCSREASReason for Discontinuation from StudyCharPermReason for subject's discontinuation from study. The source would most likely be the SDTM DS dataset. Null for subjects who completed the study.DCSREASPDCSREASP
Reason Spec for Discont from StudyCharPermAdditional detail regarding subject's discontinuation from study (e.g., description of "other").EOTSTTEnd of Treatment StatusChar(SBJTSTAT)PermThe subject's status as of the end of treatment or data cutoff. Examples: COMPLETED, DISCONTINUED, ONGOING.DCTREASReason for Discontinuation of TreatmentCharPermIf a subject discontinued treatment in the study, then this variable indicates the reason for discontinuation. This is for discontinuation of treatment in the overall study and not to be used for discontinuation reason within individual treatment periods.DCTREASPReason Specify for Discont of TreatmentCharPermAdditional detail regarding subject's discontinuation from treatment (e.g., description of "other").RFICDTDate of Informed ConsentNumPermDate subject gave informed consent. Generally equivalent to DM.RFICDTC.ENRLDTDate of EnrollmentNumPermDate of subject's enrollment into trial.RANDDTDate of RandomizationNumCondRequired in randomized trials.LSTALVDTDate Last Known AliveNumPermIf this variable is included in ADSL, the best practice is to populate it for everyone. If the derivation for subjects who died differs from the derivation for subjects who are not known to have died, the differences should be noted in metadata.TRTDURDTotal Treatment Duration (Days)NumPermTotal treatment duration, as measured in days. More than one of TRTDURD, TRTDURM, and TRTDURY can be populated, but each represents the entire duration in its respective units.DTHDTDate of DeathNumPermDate of subject's death. Derived from DM.DTHDTC.DTHCAUSCause of DeathCharPermCause of Death.STRATARStrata Used for RandomizationCharPermSTRATAR contains the combination of values of the individual stratification factors used for randomization. The exact format should be determined by the sponsor. This variable is intended for studies that use stratified randomization. For example, ">=50, Treatment experienced, N"STRATAVStrata from Verification SourceCharPermSTRATAV contains the entire string value represents the combination of values of the individual stratification factors that should have been used and represents the "as verified" value. The STRATAV variables are based on the source documentation and are determined after randomization. If the values used for the randomization of a given subject were all correct, then STRATAV will equal STRATAR. Otherwise, one or more components of the text string for STRATAR and STRATAV will be different.
The exact format should be determined by the sponsor. For example, ">=50, Treatment experienced, Y"
ASTDTAnalysis Start Date

integer



numeric SAS date variable based on EXSTDTC with no imputation for partial dates

AENDTAnalysis End Dateinteger

numeric SAS date variable based on EXENDTC with no imputation for partial dates
ASTDYAnalysis Start Relative Dayinteger

ASTDT-TRTSDT - add one if ASTDT is on or after TRTSDT
AENDYAnalysis End Relative Dayinteger

AENDT-TRTSDT - add one if ASTDT is on or after TRTSDT
EXSTDTC
text

EX.EXSTDTC
EXENDTC
text

EX.EXENDTC
TRTP
text

ADSL.TRT01P
EXTRT
text

EX.EXTRT
EXDOSE



EX.EXDOSE
EXDOSU
text

EX.EXDOSU
SAFFL
text

ADSL.SAFFL
EXSEQ
integer

EX.EXSEQ