Versions Compared

Key

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

...

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.TRT01PCMTRTtextCM.CMTRT
CMDECODtextCM.CMDECODCMDOSE



CM.CMDOSE
CMDOSTXT
text

CM.CMDOSTXT
CMDOSU
text

CM.CMDOSUCMCLAStextCM.CMCLAS
SAFFL
text

ADSL.SAFFL
CMSEQ
integer

CM.CMSEQ

STUDYID

USUBJIDCMTRTCMDECODCMCLASASTDTASTDTFAENDTAENDTFASTDYAENDY
CMSTDTCCMENDTC
AOCCFLAOCCPFLAOCC01FLPREFLONTRTFLFUPFLTRTPSAFFL
CMTRTCMDECOD
CMDOSECMDOSTXTCMDOSU
CMCLAS
CMINDC
CMSEQ
CMDOSFRM
ABC123
CMDOSFRQ
ABC12301001
CMROUTE
01JAN2004
CMSTDTC
01JAN2004
CMENDTC
1
CMENRF
12004-01-012004-01-01YYY

Y

Product AY
CMSEQ
ABC123A123ASPIRINacetylsalicylic acid
100
ANALGESICS
mg
21JAN2021
ANALGESICS

22JAN2021
1
ABC123ABC1230100102JAN200402JAN2004
2
22004-01-02
YY
2004-01-02
Y

Y

ASPIRIN

Product A
acetylsalicylic acid
Y100
mg
ANALGESICS
MIGRAINE
2
TABLET
ABC123
ONCE
ABC1230100103JAN200403JAN2004332004
ORAL2021-01-
03
21
2004
2021-01-
03YYASPIRINacetylsalicylic acid100mgANALGESICS3ABC123ABC1230100107JAN200407JAN2004772004-01-072004-01-07
22
1
ABC123A123DIOVANvalsartanANTIHYPERTENSIVES01JAN2004M

-6230




YY
ASPIRIN
Product A
acetylsalicylic acid
Y
100
20
mg
ANALGESICS
HYPERTENSION
4
TABLET
ABC123ABC1230100107JAN200407JAN2004772004-01-072004-01-07YYASPIRINacetylsalicylic acid100mgANALGESICS5ABC123ABC1230100109JAN200409JAN2004992004-01-092004-01-09YYASPIRINacetylsalicylic acid100mgANALGESICS6ABC123ABC123010022004YYYYYYYDIOVANvalsartan20mgANTIHYPERTENSIVES1ABC123ABC123010022004-01YYYYYYZOLOFTsertraline50mgPSYCHOANALEPTICS2ABC123ABC1230100209JAN200410JUN20049102004-01-092004-06-10YYYYYASTELINazelastine
BIDORAL2004
AFTER2
ABC123A123ZOLOFTsertralinePSYCHOANALEPTICS01JAN2010D

-4038




YYProduct AY50
mgPANIC ATTACKSTABLETQDORAL2010-01
AFTER3
ABC123A123ASTELINazelastineNASAL PREPARATIONS26FEB2006


-5443




YYProduct AY
2 sprays in each nostril-137 mcgmcgINFLUENZASPRAY
NASAL PREPARATIONS
BIDNASAL2006-02-26
AFTER4
3
ABC123
ABC123010032004-01-01
A123ASPIRINacetylsalicylic acidANALGESICS01JAN2004
1



-6230




YY
Y
Product AY
Y
100
Y

mg
Y
PAIN
ASPIRIN
TABLET
acetylsalicylic acid
PRN
100mgANALGESICS
ORAL2004-01-01
AFTER5
1