LBT12_BL

Liver Laboratory Tests by Time on Treatment – Patients with Elevated Post-Baseline AST or ALT Levels (with Respect to Baseline)

Standard Table
Data Setup

Preview
Try this using WebR

Code

result <- basic_table() %>%
  split_cols_by("TITLE") %>%
  split_cols_by("APERIODC") %>%
  split_rows_by("PARAM") %>%
  split_rows_by("ACTARM", split_fun = drop_split_levels, child_labels = "hidden") %>%
  count_occurrences("ARM_AVALC", .stats = "fraction", denom = "n", drop = TRUE) %>%
  build_table(anl)

criteria_fun <- function(tr) {
  row_label <- obj_label(tr)
  dplyr::if_else(row_label == "Criteria not met", TRUE, FALSE)
}

result <- result %>% trim_rows(criteria = criteria_fun)
result

                                      First Elevated Result Occurring During  
                                          PERIOD 1              PERIOD 2      
——————————————————————————————————————————————————————————————————————————————
AST>3x Baseline                                                               
  A: Drug X                            14/134 (10.4%)         8/134 (6.0%)    
  B: Placebo                            11/134 (8.2%)         11/134 (8.2%)   
  C: Combination                       15/132 (11.4%)        14/132 (10.6%)   
ALT>3x Baseline                                                               
  A: Drug X                             7/134 (5.2%)         20/134 (14.9%)   
  B: Placebo                            10/134 (7.5%)         9/134 (6.7%)    
  C: Combination                        12/132 (9.1%)         8/132 (6.1%)    
AST>3x Baseline or ALT>3x Baseline                                            
  A: Drug X                             8/134 (6.0%)         22/134 (16.4%)   
  B: Placebo                           19/134 (14.2%)        15/134 (11.2%)   
  C: Combination                       14/132 (10.6%)         13/132 (9.8%)

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(tern)

adhy <- random.cdisc.data::cadhy

anl <- adhy
anl$APERIODC <- as.factor(anl$APERIODC) # to ensure the table is built even if there is no patients after filtering
anl$ACTARM <- as.factor(anl$ACTARM) # to ensure the table is built even if there is no patients after filtering

anl <- anl %>%
  filter(
    SAFFL == "Y",
    PARAMCD %in% c("ASTPBASE", "ALTPBASE", "ALTASTPB") & AVISIT == "POST-BASELINE"
  ) %>%
  mutate(
    ARM_AVALC = factor(
      case_when(
        AVALC == "Y" ~ as.character(ACTARM),
        TRUE ~ "Criteria not met"
      ),
      levels = c(levels(anl$ACTARM), "Criteria not met")
    ),
    PARAM = factor(
      case_when(
        PARAMCD == "ASTPBASE" ~ "AST>3x Baseline",
        PARAMCD == "ALTPBASE" ~ "ALT>3x Baseline",
        PARAMCD == "ALTASTPB" ~ "AST>3x Baseline or ALT>3x Baseline"
      ),
      levels = c("AST>3x Baseline", "ALT>3x Baseline", "AST>3x Baseline or ALT>3x Baseline")
    ),
    TITLE = factor("First Elevated Result Occurring During")
  )

anl <- df_explicit_na(anl)

Reproducibility

Timestamp

[1] "2024-11-02 18:12:41 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)
 broom               1.0.7   2024-09-26 [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)
 colorspace          2.1-1   2024-07-26 [1] 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)
 forcats             1.0.0   2023-01-29 [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)
 ggplot2             3.5.1   2024-04-23 [1] CRAN (R 4.4.1)
 glue                1.8.0   2024-09-30 [1] CRAN (R 4.4.1)
 gtable              0.3.6   2024-10-25 [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)
 lattice             0.22-6  2024-03-20 [2] 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)
 Matrix              1.7-0   2024-04-26 [1] CRAN (R 4.4.1)
 munsell             0.5.1   2024-04-01 [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)
 purrr               1.0.2   2023-08-10 [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)
 rbibutils           2.3     2024-10-04 [1] CRAN (R 4.4.1)
 Rdpack              2.6.1   2024-08-06 [1] CRAN (R 4.4.1)
 rlang               1.1.4   2024-06-04 [1] CRAN (R 4.4.1)
 rmarkdown           2.28    2024-08-17 [1] CRAN (R 4.4.1)
 rtables           * 0.6.10  2024-09-20 [1] CRAN (R 4.4.1)
 scales              1.3.0   2023-11-28 [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)
 survival            3.7-0   2024-06-05 [2] CRAN (R 4.4.1)
 tern              * 0.9.6   2024-09-24 [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)
 tidyr               1.3.1   2024-01-24 [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)
 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