ADaM Example.ADSL Analysis Data Subject Level New

This is an example of an ADSL dataset and is based on input from the SDTM DM and DS datasets. This is just an example and does not mean to indicate that ADSL must be used as the dataset name nor are the parameters described necessarily the ones that would be used in a particular study.

Below are example SDTM datasets used to create the ADSL dataset. Only variables needed for illustration are shown in the examples.

dm.xpt

Row	STUDYID	DOMAIN	USUBJID	SUBJID	RFSTDTC	RFENDTC	RFXSTDTC	RFXENDTC	RFICDTC	RFPENDTC	SITEID	INVNAM	BRTHDTC	AGE	AGEU	SEX	RACE	ETHNIC	ARMCD	ARM	ACTARMCD	ACTARM	COUNTRY
1	A123	DM	A0001	0001	2021-01-08	2021-01-28	2021-01-08	2021-01-28	2021-01-02	2021-02-04	01	JOHNSON, M	1948-12-13	72	YEARS	M	WHITE	NOT HISPANIC OR LATINO	UB	Usual Brand	UB	Usual Brand	USA
2	A123	DM	A2008	2008	2021-02-08	2021-03-01	2021-02-08	2021-03-01	2021-02-02	2021-03-10	02	JAMES,A	1955-03-22	65	YEARS	M	WHITE	NOT HISPANIC OR LATINO	A	Product A	A	Product A	USA
3	A123	DM	A3009	3009	2021-06-09	2006-03-19	2021-06-09	2021-06-21	2021-06-01	2021-06-30	03	ADAMS,J	1964-01-19	57	YEARS	F	BLACK OR AFRICAN AMERICAN	NOT HISPANIC OR LATINO	B	Product B	B	Product B	USA

Dataset Debug Message

There is a leading, trailing, or non-breaking space in the dataset.

$titleHtml

ds.xpt

Row	STUDYID	DOMAIN	USUBJID	DSSEQ	DSTERM	DSDECOD	DSCAT	DSSCAT	EPOCH	DSDTC	DSSTDTC
1	A123	DS	A2001	1	INFORMED CONSENT OBTAINED	INFORMED CONSENT OBTAINED	PROTOCOL MILESTONE			2021-01-02	2021-01-02
2	A123	DS	A2001	2	RANDOMIZED	RANDOMIZED	PROTOCOL MILESTONE			2021-01-07	2021-01-07
3	A123	DS	A2001	3	COMPLETED	COMPLETED	DISPOSITION EVENT	STUDY PARTICIPATION	SCREENING	2021-01-07	20021-01-07
4	A123	DS	A2001	4	COMPLETED	COMPLETED	DISPOSITION EVENT	STUDY PARTICIPATION	PRODUCT EXPOSURE	2021-01-28	2021-01-28
5	A123	DS	A2001	5	COMPLETED	COMPLETED	DISPOSITION EVENT	STUDY PARTICIPATION	FOLLOW-UP	2021-02-04	2021-02-04

6	A123	DS	A2008	1	INFORMED CONSENT OBTAINED	INFORMED CONSENT OBTAINED	PROTOCOL MILESTONE			2021-02-02	2021-02-02
7	A123	DS	A2008	2	RANDOMIZED	RANDOMIZED	PROTOCOL MILESTONE			2021-02-08	2021-02-08
3	A123	DS	A2008	3	COMPLETED	COMPLETED	DISPOSITION EVENT	STUDY PARTICIPATION	SCREENING	2021-02-08	2021-02-08
4	A123	DS	A2008	4	COMPLETED	COMPLETED	DISPOSITION EVENT	STUDY PARTICIPATION	PRODUCT EXPOSURE	2021-03-01	2021-03-01
5	A123	DS	A2008	5	COMPLETED	COMPLETED	DISPOSITION EVENT	STUDY PARTICIPATION	FOLLOW-UP	2021-03-10	2021-03-10

8	A123	DS	A3009	1	INFORMED CONSENT OBTAINED	INFORMED CONSENT OBTAINED	PROTOCOL MILESTONE			2021-06-01	2021-06-01
9	A123	DS	A3009	2	RANDOMIZED	RANDOMIZED	PROTOCOL MILESTONE			2021-06-09	2021-06-09
10	A123	DS	A3009	3	COMPLETED	COMPLETED	DISPOSITION EVENT	STUDY PARTICIPATION	SCREENING	2021-06-09	2003-06-09
10	A123	DS	A3009	4	FLU	ADVERSE EVENT	DISPOSITION EVENT	STUDY PARTICIPATION	PRODUCT EXPOSURE	2021-06-21	2021-06-21
11	A123	DS	A3009	5	COMPLETED	LOST TO FOLLOW-UP	DISPOSITION EVENT	STUDY PARTICIPATION	PRODUCT EXPOSURE	2021-06-30	2021-06-30

$warningHtml

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

$titleHtml

adsl.xpt

STUDYID	USUBJID	SUBJID	SITEID	AGE	AGEU	AGEGR1	SEX	RACE	ETHNIC	SAFFL	RANDFL	ARM	ACTARM	TRT01P	TRT01PN	TRT01A	TRT01AN	TRTSDT	TRTEDT	EOSSTT	DCSREAS
A123	A2001	0001	01	72	YEARS	<65	M	WHITE	NOT HISPANIC OR LATINO	Y	Y	Usual Brand	Usual Brand	Product A	1	Usual Brand	1	2021-01-08	2021-01-28	COMPLETED
A123	A2008	2008	02	65	YEARS		M	WHITE	NOT HISPANIC OR LATINO	Y	Y	Product A	Product A	Product A	2	Product A	2	2021-02-08	2021-03-01	COMPLETED	ADVERSE EVENT
A123	A3009	3009	03	57	YEARS		F	BLACK OR AFRICAN AMERICAN	NOT HISPANIC OR LATINO	Y	Y	Product B	Product B	Product B	3	Product B	3	2021-06-09	2021-06-21	DISCONTINUED

Dataset Debug Message

There are three leading, trailing, or non-breaking spaces in the dataset.

ADSL Dataset Metadata

Dataset	Description	Class	Structure	Purpose	Keys	Location	Documentation
ADSL	Subject-Level Analysis Dataset	SUBJECT LEVEL ANALYSIS DATASET	One record per subject	Analysis	STUDYID, USUBJID, PARQUAL, PARAMCD, AVISIT,	ADSL.xpt	ADSL.SAS/SAP

ADSL Variable Metadata

Variable Name	Variable Label	Type	Codelist/Controlled Terms	Core	Notes
STUDYID	Study Identifier	Char		Req	DM.STUDYID
USUBJID	Unique Subject Identifier	Char		Req	DM.USUBJID
SUBJID	Subject Identifier for the Study	Char		Req	DM.SUBJID
SITEID	Study Site Identifier	Char		Req	DM.SITEID
AGE	Age	Num		Req	DM.AGE. If analysis needs require a derived age that does not match DM.AGE, then AAGE must be added
AGEU	Age Units	Char	(AGEU)	Req	DM.AGEU
AGEGRy	Pooled Age Group y	Char		Perm	Character 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".
SEX	Sex	Char	SEX)	Req	DM.SEX
RACE	Race	Char	(RACE)	Req	DM.RACE
RACEGRy	Pooled Race Group y	Char		Perm	Character description of a grouping or pooling of the subject's race for analysis purposes.
ETHNIC	Ethnicity	Char		Perm	DM.ETHNIC
SAFFL	Safety Population Flag	Char	Y; N	Cond	Y if ADSL.TR01SDT is not null, otherwise N
PPROTFL	Per-Protocol Population Flag	Char	Y; N	Cond	Y if ADSL.SAFFL=Y and at least one post-baseline assessment was done, otherwise N
RANDFL	Randomized Population Flag	Char	Y; N	Cond	Y if the subject was randomized, otherwise N
ARM	Description of Planned Arm	Char		Req	DM.ARM
ACTARM	Description of Actual Arm	Char		Perm	DM.ACTARM
TRTxxP	Planned Treatment for Period xx	Char		Req	Subject-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.
TRTxxPN	Planned Treatment for Period xx (N)	Num		Perm	Numeric 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.
TRTxxA	Actual Treatment for Period xx	Char		Cond	Subject-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.
TRTxxAN	Actual Treatment for Period xx (N)	Num		Perm	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.
TRTSEQP		Char		Cond	Required 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.
TRTSDT	Date of First Exposure to Treatment	Num		Cond	Date 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.
TRTSDTM	Datetime of First Exposure to Treatment	Num		Cond	Datetime of first exposure to treatment for a subject in a study. TRTSDT and/or TRTSDTM are required if there is an investigational product.
TRTEDT	Date of Last Exposure to Treatment	Num		Cond	Date 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.
TRTEDTM	Datetime of Last Exposure to Treatment	Num		Cond	Datetime of last exposure to treatment for a subject in a study. TRTEDT and/or TRTEDTM are required if there is an investigational product.
TRxxSDT	Date of First Exposure in Period xx	Num		Cond	Date 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.
TRxxEDT	Date of Last Exposure in Period xx	Num		Cond	Date 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).
APHASEw	Description of Phase w	Char		Perm	Description 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.
EOSSTT	End of Study Status	Char	(SBJTSTAT)	Perm	The subject's status as of the end of study or data cutoff. Examples: COMPLETED, DISCONTINUED, ONGOING.
EOSDT	End of Study Date	Num		Perm	Date subject ended the study - either date of completion or date of discontinuation or data cutoff date for interim analyses.
DCSREAS	Reason for Discontinuation from Study	Char		Perm	Reason for subject's discontinuation from study. The source would most likely be the SDTM DS dataset. Null for subjects who completed the study.
DCSREASP	DCSREASP Reason Spec for Discont from Study	Char		Perm	Additional detail regarding subject's discontinuation from study (e.g., description of "other").
EOTSTT	End of Treatment Status	Char	(SBJTSTAT)	Perm	The subject's status as of the end of treatment or data cutoff. Examples: COMPLETED, DISCONTINUED, ONGOING.
DCTREAS	Reason for Discontinuation of Treatment	Char		Perm	If 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.
DCTREASP	Reason Specify for Discont of Treatment	Char		Perm	Additional detail regarding subject's discontinuation from treatment (e.g., description of "other").
RFICDT	Date of Informed Consent	Num		Perm	Date subject gave informed consent. Generally equivalent to DM.RFICDTC.
ENRLDT	Date of Enrollment	Num		Perm	Date of subject's enrollment into trial.
RANDDT	Date of Randomization	Num		Cond	Required in randomized trials.
LSTALVDT	Date Last Known Alive	Num		Perm	If 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.
TRTDURD	Total Treatment Duration (Days)	Num		Perm	Total 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.
DTHDT	Date of Death	Num		Perm	Date of subject's death. Derived from DM.DTHDTC.
DTHCAUS	Cause of Death	Char		Perm	Cause of Death.
STRATAR	Strata Used for Randomization	Char		Perm	STRATAR 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"
STRATAV	Strata from Verification Source	Char		Perm	STRATAV 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"

Page tree

ADaM Example.ADSL Analysis Data Subject Level New