Versions Compared

Key

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

...

Definexmltable
LevelDataset
PurposeAnalysis
NameADAE
DatasetDescriptionClassStructurePurposeKeysLocationDocumentation
ADAEAdverse Events Analysis DatasetOCCURRENCE DATA STRUCTUREOne record per subject per adverse eventAnalysisSTUDYID, USUBJID, AEBODSYS, AEDECOD, AETERMADAE.xptADAE.SAS/SAP
Definexmltable
DatasetADAE
LevelVariable
PurposeAnalysis
OIDADAE
NameADAE
Variable NameVariable LabelTypeCodelist/Controlled TermsCoreNotes

STUDYID

Study Identifiertext
ReqAE.STUDYID
USUBJIDUnique Subject Identifiertext
ReqAE.USUBJID
AETERMReported Term for the Adverse Experiencetext
ReqAE.AETERM
AEMODIFYModified Reported Termtext
PermAE.MODIFY
AEBODSYSBody System or Organ Classtext
ReqAE.AEBODSYS
AEDECODDictionary-Derived Termtext
ReqAE.AEDECOD
ASTDTAnalysis Start Dateinteger
Cond

Created from converting AE.AESTDTC from character ISO8601 format to numeric date format

AENDTAnalysis End Dateinteger
Cond

Created from converting AE.AEENDTC from character ISO8601 format to numeric date format

ASTDYAnalysis Start Relative Dayinteger
CondASTDT – ADSL.TRTSDT + 1 if ASTDT ≥ TRTSDT, else ASTDT – ADSL.TRTSDT if ASTDT< TRTSDT
AENDYAnalysis End Relative Dayinteger
CondAENDT – ADSL.TRTSDT + 1 if AENDT ≥ TRTSDT, else AENDT – ADSL.TRTSDT if AENDT < TRTSDT
PREFLPre-product FlagtextYCondIf ASTDT < ADSL.TRTSDT then PREFL=’Y’
TRTEMFLProductt Emergent Analysis FlagtextYCondIf ADSL.TRTSDT≤ASTDT then TRTEMFL=’Y’
FUPFLFollow-up FlagtextYCondIf ASTDT > ADSL.TRTEDT then FUPFL=’Y’

AETRTEMProduct Emergent Flagtext(NY)PermSUPPAE.QVAL where QNAM=’AETRTEM’.
AOCCFL1st Occurrence within Subject FlagtextYPermSort the data in the required order and flag the first product emergent record for each subject.
AOCCPFL1st Occurrence of Preferred Term FlagtextYPermSort the data in the required order and flag the first product emergent record for each AEDECOD for each subject.
AOCCSFL1st Occurrence of SOC FlagtextYPerm Sort the data in the required order and flag the first product emergent record for each body system for each subject.
AESERSerious Eventtext(NY)ReqAE.AESER
AERELCausalitytext
PermAE.AEREL
AERLDEVRelationship of Event to Devicetext

*

Perm

AE.AERLDEV

RELGR1Pooled Causality Group ytext
Permset to RELATED if AE.AEREL in (DEFINITELY,PROBABLY,POSSIBLY), set to NOT RELATED if AEREL in (PROBABLY NOT, DEFINITELY NOT)
AEACNAction Taken with Study Producttext(ACN)PermAE.AEACN
AEACNDEVAction Taken with Device

text


PermAE.AEACNDEV
AEOUTOutcome of Adverse Eventtext(OUT)PermAE.AEOUT
TRTAActual Producttext
CondADSL.TRT01A
SAFFLSafety Population Flagtext
CondADSL.SAFFL
TRTSDTDate of First Exposure to Productinteger
PermADSL.TRTSDT
TRTEDTDate of Last Exposure to Productinteger
PermADSL.TRTEDT
AEOUTOutcome of Adverse Eventtext
PermAE.AEOUT
AESEQSequence Numberinteger
PermAE.AESEQ
AESTDTCStart Date/Time of
Adverse Event

text


PermAE.AESTDTC
AEENDTCEnd Date/Time of
Adverse Event
text
PermAE.AEENDTC
AESTDYStudy Day of Start of
Adverse Event
text
PermAE.AESTDY
AEENDYStudy Day of End of
Adverse Event
text
PermAE.AEENDY
AEENRFEnd Relative to
Reference Period
text
PermAE.AEENRF