Versions Compared

Old Version 18

changes.mady.by.user Christine Connolly

Saved on

compared with

New Version 19

changes.mady.by.user Christine Connolly

Saved on

Key

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

...

Dataset wrap
Nameadcm
Dataset2
tableidadcm

Row

STUDYID

USUBJIDCMTRTCMDECODCMCLASASTDTASTDTFAENDTAENDTFASTDYAENDYAOCCFLAOCCPFLAOCC01FLPREFLONTRTFLFUPFLTRTPSAFFLCMDOSECMDOSTXTCMDOSUCMINDCCMDOSFRMCMDOSFRQCMROUTECMSTDTCCMENDTCCMENRFCMSEQ
1ABC123A2001ASPIRINacetylsalicylic acidANALGESICS21JAN2021
22JAN2021
12YYY

Y


PlaceboY100
mgMIGRAINETABLETONCEORAL2021-01-212021-01-22
1
2ABC123A2008DIOVANvalsartanANTIHYPERTENSIVES01JAN2004M

-6230




YYProduct AY20
mgHYPERTENSIONTABLETBIDORAL2004
AFTER2
3ABC123A2008ZOLOFTsertralinePSYCHOANALEPTICS01JAN2010D

-4038




YYProduct AY50
mgPANIC ATTACKSTABLETQDORAL2010-01
AFTER3
4ABC123A2008ASTELINazelastineNASAL PREPARATIONS26FEB2006


-5443




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


-6230




YYProduct BY100
mgPAINTABLETPRNORAL2004-01-01
AFTER5
Definexmltable
LevelVariable
PurposeAnalysis
NameADCM

Variable Name

Variable LabelTypeCodelist/Controlled TermsCoreCDISC Notes
STUDYIDStudy Identifiertext
ReqCM.STUDYID
USUBJIDUnique Subject Identifiertext
ReqCM.USUBJID
CMTRTReported Name of Drug, Med, or Therapytext
ReqCM.CMTRT
CMDECODStandardized Medication Nametext
PermCM.CMDECOD
CMCLASMedication Classtext
PermCM.CMCLAS
ASTDTAnalysis Start Date

integer


Perm

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

ASTDTFAnalysis Start Date Imputation Flag

Perm
AENDTAnalysis End Dateinteger
Permnumeric SAS date variable based on CMENDTC with no imputation for partial dates
AENDTFAnalysis End Date Imputation Flag

Perm
ASTDYAnalysis Start Relative Dayinteger
PermASTDT-TRTSDT - add one if ASTDT is on or after TRTSDT
AENDYAnalysis End Relative Dayinteger
PermAENDT-TRTSDT - add one if ASTDT is on or after TRTSDT
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
TRTPPlanned Treatmenttext
CondADSL.TRT01P
SAFFLSafety Population FlagtextY;NCondADSL.SAFFL
CMDOSEDose per Administrationinteger
PermCM.CMDOSE
CMDOSTXTDose Descriptiontext
PermCM.CMDOSTXT
CMDOSUDose Unitstext
PermCM.CMDOSU
CMINDCIndicationtext
PermCM.CMINDC
CMDOSFRMDose Formtext
PermCM.CMDOSFRM
CMDOSFRQDosing Frequency per Intervaltext
PermCM.CMDOSFRQ
CMROUTERoute of Administrationtext
PermCM.CMROUTE
CMSTDTCStart Date/Time of Medicationtext
PermCM.CMSTDTC
CMENDTCEnd Date/Time of Medication text
PermCM.CMENDTC
CMENRFEnd Relative to Reference Periodtext
PermCM.CMENRF
CMSEQSequence Numberinteger
CondCM.CMSEQ