Creation of OCCDS-ADAE Dataset- Day 04 of Onco-ADaM Project

 

Introduction

This is a statistical analysis data structure that describes the general data structure and content typically found in occurrence analysis.

For example like adverse events, concomitant medications, and medical history data structure.

Some required variables for OCCDS are:

• Identifier Variables: STUDYID, USUBJID, — SEQ
• MedDRA Dictionary Coding Variables: — TERM
• Adverse Event Descriptive Variables: AESER(Serious Event)
• WHO Drug Dictionary Coding Variables: CMTRT

ADAE stands for Adverse Events Analysis Dataset. The base datasets for ADAE is ADaM.ADSL, SDTM.AE, & SDTM.SUPPAE.

Variables

I am not including the general variables like USUBJID, SITEID, AGE, SEX, etc., and also not from ADSL. Note that the variables i mention is not limited to this.

1. Adverse Event related variables
   • AESPID
   • AETERM
   • AEDECOD
   • ADECOD
   • AEBODSYS
   • AEBDSYCD
   • AESTDTC
   • AEENDTC
   • AEACN
   • AESHOSP
   • AECONTRT
   • AEREL
   • AREL
   • AEOUT
   • AEENRF
   • ASEV
   • ASEVN
   • AETOXGR
   • AEDLTTOX
   • AECMEDID
2. Date & Time Imputation
   • ASTDT
   • ASTDTF
   • AENDT
   • AENDTF
3. Study Day Variable
   • ASTDY
   • AENDY
4. Flag Variables
   • TRTEMFL
   • FUPFL

Steps:

1. Identify the SDTM datasets required for programming ADAE.
2. Mark the variables that is carry forwarded from the ADSL dataset.
3. Identify the variables that is as same as in SDTM datasets
4. Transposing Supplemental dataset
   1. Create a variable AESEQ with the value of IDVARVAL in numeric format.
   2. Sort the above dataset by USUBJID and AESEQ
   3. Transpose the supplementary dataset.
   4. Merge with the main dataset AE.
5. Merge the ADAE to ADSL dataset.
6. Now create all the variables that are that is same but just the variable name is different. (for ex., ADECOD=AEDECOD)
7. Creating Causality and severity related variable
8. Date & Time and Imputation variable
   1. Creation of start date with imputation of partial date
   2. Creation of end date with imputation of partial date
9. Creation of Study day variable
   1. Study start day variable
   2. Study end day variable
10. Creating flag variables
    1. Creating Treatment Emergent Flag
    2. Creating Follow-up flag
11. Final, keeping required variable and saving the file to the destination.

Key-notes

• If any AE is started on or after the treatment start date, or on or after, a specific date of, treatment end date, we populate the treatment emergent flag as ‘Y’.
• If any appear after the treatment end date, then we populate the follow-up flag as ‘Y’.

Important

If this the first post you read, then i highly recommend to read my last blogs on this series, link is below down:

1. What is ADaM- Day:01 of Onco-ADaM Project
2. Creation of ADSL- Day: 02 of Onco-ADaM Project
3. Creation of OCCDS-ADCM Dataset - Day:03 of Onco-ADaM Project

Thank You for Visiting :)