AEL04

Listing of Patient Deaths

Standard Listing
Data Setup

Preview
Try this using WebR

Code

lsting <- as_listing(
  out,
  key_cols = c("TRT01A", "ID"),
  disp_cols = names(out),
  main_title = "Listing of Patient Deaths"
)

head(lsting, 20)

Listing of Patient Deaths

——————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————
                                                                 Date of First     Day of Last                                                        
                                                                   Study Drug       Study Drug     Day of                                    Autopsy  
Treatment   Center/Patient ID            Age/Sex/Race            Administration   Administration   Death           Cause of Death           Performed?
——————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————
A: Drug X     BRA-1/id-134                47/M/WHITE               04NOV2020           473          496             ADVERSE EVENT              Yes    
               BRA-1/id-93                34/F/ASIAN               20JUN2020           610          657             ADVERSE EVENT              Yes    
              BRA-11/id-217               43/M/ASIAN               28SEP2019           871          893             ADVERSE EVENT              Yes    
              BRA-15/id-36                38/F/ASIAN               08JAN2020           767          812          DISEASE PROGRESSION           Yes    
              CAN-11/id-139               31/M/ASIAN               15SEP2020           519          563             ADVERSE EVENT              Yes    
              CHN-1/id-123                27/F/ASIAN               28JAN2020           750          750          DISEASE PROGRESSION           Yes    
              CHN-1/id-199      27/M/BLACK OR AFRICAN AMERICAN     08JAN2020           773          779          DISEASE PROGRESSION           Yes    
              CHN-1/id-235                39/M/ASIAN               13JUL2019           950          968             ADVERSE EVENT              Yes    
               CHN-1/id-62                36/F/WHITE               22NOV2020           455          497             ADVERSE EVENT              Yes    
              CHN-12/id-258               45/M/WHITE               01MAR2020           721          756                SUICIDE                  No    
              CHN-15/id-14      38/F/BLACK OR AFRICAN AMERICAN     29SEP2019           871          919          DISEASE PROGRESSION           Yes    
              CHN-17/id-182     37/M/BLACK OR AFRICAN AMERICAN     18SEP2019           879          902           LOST TO FOLLOW UP             NA    
              CHN-17/id-92                29/M/ASIAN               01MAR2020           720          721           LOST TO FOLLOW UP             NA    
               CHN-2/id-22                29/M/ASIAN               15JAN2021           393          409                MISSING                  NA    
              CHN-2/id-223                29/F/ASIAN               18NOV2020           453          468          DISEASE PROGRESSION           Yes    
              CHN-2/id-272                41/F/ASIAN               11JAN2020           768          773          DISEASE PROGRESSION           Yes    
              CHN-2/id-274                40/F/ASIAN               14OCT2019           860          890                SUICIDE                  No    
              CHN-3/id-128                32/M/ASIAN               24FEB2019           1084         1105            ADVERSE EVENT              Yes    
              CHN-5/id-108      28/F/BLACK OR AFRICAN AMERICAN     11SEP2019           886          935                MISSING                  NA    
               CHN-6/id-30                29/M/ASIAN               24AUG2020           539          578     Post-study reporting of death       No

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)

adsl <- random.cdisc.data::cadsl

out <- adsl %>%
  filter(!is.na(DTHADY)) %>%
  mutate(
    ID = paste(SITEID, SUBJID, sep = "/"),
    AGSXRC = paste(AGE, SEX, RACE, sep = "/"),
    TRTSD = toupper(format(as.Date(TRTSDTM), "%d%b%Y"))
  ) %>%
  arrange(SUBJID) %>%
  select(ID, AGSXRC, TRT01A, TRTSD, EOSDY, DTHADY, DTHCAUS, ADTHAUT)

var_labels(out) <- c(
  ID = "Center/Patient ID",
  AGSXRC = "Age/Sex/Race",
  TRT01A = "Treatment",
  TRTSD = "Date of First\nStudy Drug\nAdministration",
  EOSDY = "Day of Last\nStudy Drug\nAdministration",
  DTHADY = "Day of\nDeath",
  DTHCAUS = "Cause of Death",
  ADTHAUT = "Autopsy\nPerformed?"
)

Reproducibility

Timestamp

[1] "2024-11-02 18:40:52 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   2024-09-12 [1] CRAN (R 4.4.1)
 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  2024-11-02 [1] https://insightsengineering.r-universe.dev (R 4.4.1)
 rlang               1.1.4   2024-06-04 [1] CRAN (R 4.4.1)
 rlistings         * 0.2.9   2024-06-20 [1] CRAN (R 4.4.1)
 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.2   2024-10-28 [1] CRAN (R 4.4.1)
 xfun                0.49    2024-10-31 [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