I am a bit confused on how to use the Episodes data for Oncology Drug Therapy data, so any help will be very appreciated.
I am looking at SACT data, which is Systematic Anti Cancer Therapy Dataset, which is a focus on using substances circulating in the bloodstream to target and treat cancer cells throughout the body, rather than localized treatments like surgery or radiotherapy.
As well as a lot of other fields, I have the following data (which I think is relevant to this question) that I think I can use for Episodes, but just not sure how:
- NHS Number
- Primary Diagnosis
- Drug Name
- Start Date of Regimen
- Start Date of Cycle
- Cycle Number
- Administered Date
An example of the above for a given patient …
ID, Primary Diagnosis, Drug Name, Start Date of Regimen, Start Date of Cycle, Cycle Number, Administered Date
1, C499, MESNA, 27/06/2023, 27/06/2023, 1, 27/06/2023
2, C499, DOXORUBICIN, 28/06/2023, 28/06/2023, 1, 28/06/2023
3, C499, DEXRAZOXANE, 27/06/2023, 27/06/2023, 1, 27/06/2023
4, C499, DEXRAZOXANE, 27/06/2023, 27/06/2023, 1, 28/06/2023
5, C499, DEXAMETHASONE, 23/05/2023, 12/06/2023, 2, 13/06/2023
6, C499, MESNA, 23/05/2023, 12/06/2023, 2, 13/06/2023
7, C499, ETOPOSIDE, 23/05/2023, 12/06/2023, 2, 13/06/2023
Using this data, is it possible to extract episodes? I have already done Drug Exposures and Condition Occurrences using the above data, but I am just thinking whether Episodes can somehow be linked like cycles.
Appreciate any feedback or thoughts.
Thanks