CML01

Listing of Previous and Concomitant Medications

Standard Listing
Data Setup

Preview
Try this using WebR

Code

lsting <- as_listing(
  out,
  key_cols = c("TRT01A", "ID", "AGSXRC", "CMDECOD"),
  disp_cols = names(out),
  main_title = "Listing of Previous and Concomitant Medications"
)

head(lsting, 20)

Listing of Previous and Concomitant Medications

———————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————
                                                                                   Date of First                                                    Ongoing                                                        
                                                                                     Study Drug     Medication               Duration               at Final                                                       
Treatment   Center/Patient ID            Age/Sex/Race            Medication Name   Administration   Start Date   Study Day    (days)    Previous?   Contact?   Dose   Dose Unit       Frequency           Route    
———————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————
A: Drug X     BRA-1/id-134                47/M/WHITE              medname A_2/3      04NOV2020      21SEP2021       321        -148        No          No       30    mg/breath          Q4H          INTRAMUSCULAR
                                                                                     04NOV2020      02DEC2021       393        -42         No          No       41     umol/L           TWICE            UNKNOWN   
                                                                  medname B_1/4      04NOV2020      15APR2021       162        -172        No          No       25    ug/kg/day          Q4H           INTRAVENOUS 
                                                                                     04NOV2020      15APR2021       162        -172        No          No       25    ug/kg/day          Q4H           INTRAVENOUS 
                                                                                     04NOV2020      15APR2021       162        -172        No          No       25    ug/kg/day          Q4H           INTRAVENOUS 
                                                                  medname C_1/2      04NOV2020      19MAY2021       196        -165        No          No       22      ug/mL            TID             INHALED   
                                                                                     04NOV2020      19MAY2021       196        -165        No          No       22      ug/mL            TID             INHALED   
               BRA-1/id-42      36/M/BLACK OR AFRICAN AMERICAN    medname A_2/3      01JAN2020      09JUN2020       160        -258        No         Yes       48      DROP             QD            INTRAVENOUS 
                                                                                     01JAN2020      04APR2021       459        -194        No         Yes       57    ug/kg/day          Q4W              NASAL    
                                                                                     01JAN2020      15APR2021       470        -130        No         Yes       83    ug/kg/day          Q4H             UNKNOWN   
                                                                                     01JAN2020      20APR2021       475        -112        No         Yes       17    ug/kg/day          Q4H          SUBCUTANEOUS 
                                                                  medname A_3/3      01JAN2020      03OCT2021       641        -14         No         Yes       68        %       4 TIMES PER MONTH      UNKNOWN   
                                                                                     01JAN2020      03OCT2021       641        -14         No         Yes       68        %       4 TIMES PER MONTH      UNKNOWN   
                                                                  medname B_1/4      01JAN2020      19OCT2020       292        -49         No         Yes       5       ug/mL           TWICE            UNKNOWN   
                                                                                     01JAN2020      19OCT2020       292        -49         No         Yes       5       ug/mL           TWICE            UNKNOWN   
                                                                                     01JAN2020      19OCT2020       292        -49         No         Yes       5       ug/mL           TWICE            UNKNOWN   
                                                                  medname B_2/4      01JAN2020      11MAY2021       496        -161        No         Yes       83      ug/mL           TWICE            RECTAL    
                                                                                     01JAN2020      11MAY2021       496        -161        No         Yes       83      ug/mL           TWICE            RECTAL    
                                                                                     01JAN2020      11MAY2021       496        -161        No         Yes       83      ug/mL           TWICE            RECTAL    
                                                                  medname B_3/4      01JAN2020      09FEB2020       39         -505        No         Yes       85       ug              QD           SUBCUTANEOUS

Experimental use!

WebR is a tool allowing you to run R code in the web browser. Modify the code below and click run to see the results. Alternatively, copy the code and click here to open WebR in a new tab.

Code

library(dplyr)
library(rlistings)

adcm <- random.cdisc.data::cadcm

out <- adcm %>%
  filter(!is.na(CMDECOD)) %>%
  mutate(
    ID = paste(SITEID, SUBJID, sep = "/"),
    AGSXRC = paste(AGE, SEX, RACE, sep = "/"),
    TRTSD = toupper(format(as.Date(TRTSDTM), "%d%b%Y")),
    CMASTD = toupper(format(as.Date(ASTDTM), "%d%b%Y")),
    CMSTRFL = ifelse(ASTDY < 0, "Yes", "No"),
    CMENRFL = ifelse(CMENRTPT == "ONGOING", "Yes", "No")
  ) %>%
  select(
    ID, AGSXRC, TRT01A, CMDECOD, TRTSD, CMASTD, ASTDY, ADURN,
    CMSTRFL, CMENRFL, CMDOSE, CMDOSU, CMDOSFRQ, CMROUTE
  )

var_labels(out) <- c(
  ID = "Center/Patient ID",
  AGSXRC = "Age/Sex/Race",
  TRT01A = "Treatment",
  CMDECOD = "Medication Name",
  TRTSD = "Date of First\nStudy Drug\nAdministration",
  CMASTD = "Medication\nStart Date",
  ASTDY = "Study Day",
  ADURN = "Duration\n(days)",
  CMSTRFL = "Previous?",
  CMENRFL = "Ongoing\nat Final\nContact?",
  CMDOSE = "Dose",
  CMDOSU = "Dose Unit",
  CMDOSFRQ = "Frequency",
  CMROUTE = "Route"
)

Reproducibility

Timestamp

[1] "2024-11-02 18:24:05 UTC"

Session Info

─ Session info ───────────────────────────────────────────────────────────────
 setting  value
 version  R version 4.4.1 (2024-06-14)
 os       Ubuntu 22.04.5 LTS
 system   x86_64, linux-gnu
 ui       X11
 language (EN)
 collate  en_US.UTF-8
 ctype    en_US.UTF-8
 tz       Etc/UTC
 date     2024-11-02
 pandoc   3.4 @ /usr/bin/ (via rmarkdown)

─ Packages ───────────────────────────────────────────────────────────────────
 package           * version     date (UTC) lib source
 backports           1.5.0       2024-05-23 [1] CRAN (R 4.4.1)
 brio                1.1.5       2024-04-24 [1] CRAN (R 4.4.1)
 checkmate           2.3.2       2024-07-29 [1] CRAN (R 4.4.1)
 cli                 3.6.3       2024-06-21 [1] CRAN (R 4.4.1)
 codetools           0.2-20      2024-03-31 [2] CRAN (R 4.4.1)
 digest              0.6.37      2024-08-19 [1] CRAN (R 4.4.1)
 dplyr             * 1.1.4       2023-11-17 [1] CRAN (R 4.4.1)
 evaluate            1.0.1       2024-10-10 [1] CRAN (R 4.4.1)
 fansi               1.0.6       2023-12-08 [1] CRAN (R 4.4.1)
 fastmap             1.2.0       2024-05-15 [1] CRAN (R 4.4.1)
 formatters        * 0.5.9.9003  2024-11-02 [1] git2r (https://github.com/insightsengineering/formatters.git@84e8c3e)
 generics            0.1.3       2022-07-05 [1] CRAN (R 4.4.1)
 glue                1.8.0       2024-09-30 [1] CRAN (R 4.4.1)
 htmltools           0.5.8.1     2024-04-04 [1] CRAN (R 4.4.1)
 htmlwidgets         1.6.4       2023-12-06 [1] CRAN (R 4.4.1)
 jsonlite            1.8.9       2024-09-20 [1] CRAN (R 4.4.1)
 knitr               1.48        2024-07-07 [1] CRAN (R 4.4.1)
 lifecycle           1.0.4       2023-11-07 [1] CRAN (R 4.4.1)
 magrittr            2.0.3       2022-03-30 [1] CRAN (R 4.4.1)
 pillar              1.9.0       2023-03-22 [1] CRAN (R 4.4.1)
 pkgconfig           2.0.3       2019-09-22 [1] CRAN (R 4.4.1)
 R6                  2.5.1       2021-08-19 [1] CRAN (R 4.4.1)
 random.cdisc.data   0.3.16.9001 2024-11-02 [1] git2r (https://github.com/insightsengineering/random.cdisc.data.git@a65bfbe)
 rlang               1.1.4       2024-06-04 [1] CRAN (R 4.4.1)
 rlistings         * 0.2.9.9008  2024-11-02 [1] git2r (https://github.com/insightsengineering/rlistings.git@f6bb1fb)
 rmarkdown           2.28        2024-08-17 [1] CRAN (R 4.4.1)
 sessioninfo         1.2.2       2021-12-06 [1] CRAN (R 4.4.1)
 stringi             1.8.4       2024-05-06 [1] CRAN (R 4.4.1)
 stringr             1.5.1       2023-11-14 [1] CRAN (R 4.4.1)
 testthat            3.2.1.1     2024-04-14 [1] CRAN (R 4.4.1)
 tibble            * 3.2.1       2023-03-20 [1] CRAN (R 4.4.1)
 tidyselect          1.2.1       2024-03-11 [1] CRAN (R 4.4.1)
 utf8                1.2.4       2023-10-22 [1] CRAN (R 4.4.1)
 vctrs               0.6.5       2023-12-01 [1] CRAN (R 4.4.1)
 withr               3.0.1       2024-07-31 [1] CRAN (R 4.4.1)
 xfun                0.48        2024-10-03 [1] CRAN (R 4.4.1)
 yaml                2.3.10      2024-07-26 [1] CRAN (R 4.4.1)

 [1] /usr/local/lib/R/site-library
 [2] /usr/local/lib/R/library

──────────────────────────────────────────────────────────────────────────────

`.lock` file

Download the .lock file and use renv::restore() on it to recreate environment used to generate this website.

Download

Reproducibility

Timestamp

Session Info

.lock file

`.lock` file