This article describes how to cut study SDTM data using a modular approach to enable any further study or project specific customization.
- Read in Data
- Create DCUT Dataset
- Preprocess Datasets
- Specify Cut Types
- Patient Cut
- Date Cut
- DM Cut
- Apply Cut
- Output Final List of Cut Datasets
To start, all SDTM data to be cut needs to be read into the environment. These should be stored in a list.
The next step is to create the DCUT dataset containing the datacut date and description.
dcut <- create_dcut(dataset_ds = ds, ds_date_var = DSSTDTC, filter = DSDECOD == "RANDOMIZATION", cut_date = "2022-06-04", cut_description = "Clinical Cutoff Date")
If any pre-processing of datasets is needed, for example in the case of FA, where there are multiple date variables, this should be done next.
We’ll next specify the cut types for each dataset (patient cut, date cut or no cut) and in the case of date cut which date variable should be used.
Next we’ll apply the patient cut.
patient_cut_data <- lapply( source_data[patient_cut_list], pt_cut, dataset_cut = dcut )
This adds on temporary flag variables indicating which observations will be removed, for example for SC:
Next we’ll apply the date cut.
This again adds on temporary flag variables indicating which observations will be removed, for example for AE:
Then lastly we’ll apply the special DM cut which also updates the death related variables.
dm_cut <- special_dm_cut(dataset_dm = source_data$dm, dataset_cut = dcut, cut_var = DCUTDTM)
This adds on temporary variables indicating any death records that would change as a result of applying a datacut:
The last step is to create the RMD report, to summarize which patients and observations will be cut, and then apply the cut to strip out all observations flagged as to be removed.