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

Compare with Current View Page History

« Previous Version 10 Next »

Below is an example ADaM dataset designed to support the summarization of concomitant medications. Included are a subset of variables that are commonly inluded to support a basic summary table - for a full list of commonly used and available variables please see Section 2.3.1.1 in the OCCDS section that referecnes Concomitant Medications.

Variable Name

Variable LabelTypeCodelist/Controlled TermsCoreCDISC Notes
STUDYIDStudy Identifiertext

CM.STUDYID
USUBJIDUnique Subject Identifiertext

CM.USUBJID
CMTRT
text

CM.CMTRT
CMDECOD
text

CM.CMDECOD
CMCLAS
text

CM.CMCLAS
ASTDTAnalysis Start Date

integer



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

AENDTAnalysis End Dateinteger

numeric SAS date variable based on CMENDTC 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
CMSTDTC
text

CM.CMSTDTC
CMENDTC
text

CM.CMENDTC
AOCCFL1st Occurrence within Subject FlagtextYPerm

sort by USUBJID, CMCLAS, CMDECOD, CMSTDTC and then set to Y for the first record

AOCCPFL1st Occurrence of Preferred Term FlagtextYPermsort by USUBJID, CMCLAS, CMDECOD, CMSTDTC and then set to Y for the first record within CMCLAS and CMDECOD
AOCC01FL1st Occurrence of CMCLAStextYPermsort by USUBJID, CMCLAS, CMDECOD, CMSTDTC and then set to Y for the first record within CMCLAS
PREFL

Pre-treatment Flag


textYCond
ONTRTFLOn Treatment
Record Flag
textYCond
FUPFLFollow-up FlagtextYCond
TRTP
text

ADSL.TRT01P
CMDOSE



CM.CMDOSE
CMDOSTXT
text

CM.CMDOSTXT
CMDOSU
text

CM.CMDOSU
SAFFL
text

ADSL.SAFFL
CMSEQ
integer

CM.CMSEQ

STUDYID

USUBJIDCMTRTCMDECODCMCLASASTDTASTDTFAENDTAENDTFASTDYAENDYAOCCFLAOCCPFLAOCC01FLPREFLONTRTFLFUPFLTRTPSAFFLCMDOSECMDOSTXTCMDOSUCMINDCCMDOSFRMCMDOSFRQCMROUTECMSTDTCCMENDTCCMENRFCMSEQ
ABC123A123ASPIRINacetylsalicylic acidANALGESICS21JAN2021
22JAN2021
12YYY

Y


Product AY100
mgMIGRAINETABLETONCEORAL2021-01-212021-01-22
1
ABC123A123DIOVANvalsartanANTIHYPERTENSIVES01JAN2004M

-6230




YYProduct AY20
mgHYPERTENSIONTABLETBIDORAL2004
AFTER2
ABC123A123ZOLOFTsertralinePSYCHOANALEPTICS01JAN2010D

-4038




YYProduct AY50
mgPANIC ATTACKSTABLETQDORAL2010-01
AFTER3
ABC123A123ASTELINazelastineNASAL PREPARATIONS26FEB2006


-5443




YYProduct AY
2 sprays in each nostril-137 mcgmcgINFLUENZASPRAYBIDNASAL2006-02-26
AFTER4
ABC123A123ASPIRINacetylsalicylic acidANALGESICS01JAN2004


-6230




YYProduct AY100
mgPAINTABLETPRNORAL2004-01-01
AFTER5
  • No labels