LBL02A_RLS

Listing of Laboratory Abnormalities Defined by Roche Safety Lab Standardization

Output

Code
lsting <- as_listing(
  out,
  key_cols = c("TRT01A", "LBTEST_U", "CPID"),
  disp_cols = names(out),
  main_title = "Listing of Laboratory Abnormalities Defined by Roche Safety Lab Standardization",
  main_footer = "Standard reference range, marked reference range and clinically relevant change from baseline are from the Roche Safety Lab Standardization guideline.  Abnormalities are flagged as high (H) or low (L) if outside the standard reference range; high high (HH) or low low (LL) if outside the marked reference range with a clinically relevant change from baseline." 
)

head(lsting, 20)
Listing of Laboratory Abnormalities Defined by Roche Safety Lab Standardization

β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”
                                                                                                                                                  Clinically              
                                                                                      Days Since             % Change     Standard     Marked      Relevant               
                                                                             Study   Last Dose of              from      Reference    Reference     Change     Abnormality
Treatment                Lab Test (Unit)                 Center/Patient ID    Day     Study Drug    Result   Baseline      Range        Range     Dec./Inc.       Flag    
β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”
A: Drug X   Alanine Aminotransferase Measurement (U/L)     BRA-1/id-105       80          0           4.3           NA   5.5 - 31.1    7 - 55     40% / 40%        LL     
                                                                              149         69         24.7          0.0   5.5 - 31.1    7 - 55     40% / 40%               
                                                                              314        165         24.9          0.7   5.5 - 31.1    7 - 55     40% / 40%               
                                                                              398         84          3.7        -85.2   5.5 - 31.1    7 - 55     40% / 40%        LL     
                                                                              470         72         18.5        -24.9   5.5 - 31.1    7 - 55     40% / 40%               
                                                                              528         58          7.7        -68.7   5.5 - 31.1    7 - 55     40% / 40%               
                                                                              535         7          23.5         -4.8   5.5 - 31.1    7 - 55     40% / 40%               
                                                           BRA-1/id-134       225         0           7.4           NA   5.5 - 31.1    7 - 55     40% / 40%               
                                                                              227         2          16.4          0.0   5.5 - 31.1    7 - 55     40% / 40%               
                                                                              255         28         11.2        -32.0   5.5 - 31.1    7 - 55     40% / 40%               
                                                                              269         14         15.9         -3.2   5.5 - 31.1    7 - 55     40% / 40%               
                                                                              357         88         24.4         48.3   5.5 - 31.1    7 - 55     40% / 40%               
                                                                              436         79         16.0         -2.4   5.5 - 31.1    7 - 55     40% / 40%               
                                                                              440         4          17.2          4.8   5.5 - 31.1    7 - 55     40% / 40%               
                                                            BRA-1/id-42       176         0          16.6           NA   5.5 - 31.1    7 - 55     40% / 40%               
                                                                              477        301         16.5          0.0   5.5 - 31.1    7 - 55     40% / 40%               
                                                                              534         57         18.7         13.4   5.5 - 31.1    7 - 55     40% / 40%               
                                                                              550         16         11.4        -30.6   5.5 - 31.1    7 - 55     40% / 40%               
                                                                              569         19         21.7         31.3   5.5 - 31.1    7 - 55     40% / 40%               
                                                                              608         39         24.6         49.2   5.5 - 31.1    7 - 55     40% / 40%               
β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”

Standard reference range, marked reference range and clinically relevant change from baseline are from the Roche Safety Lab Standardization guideline.  Abnormalities are flagged as high (H) or low (L) if outside the standard reference range; high high (HH) or low low (LL) if outside the marked reference range with a clinically relevant change from baseline.

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)

adlb <- random.cdisc.data::cadlb

adlb_x <- adlb %>%
  filter(
    LBTEST != ""
  ) %>%
  mutate(
    LBTEST_U = paste0(LBTEST, " (", AVALU, ")"),
    CPID = paste(SITEID, SUBJID, sep = "/")
  ) %>%
  mutate(CRC = paste("40%", "40%", sep = " / "))

std_rng <- adlb_x %>%
  group_by(LBTEST_U) %>%
  summarise(
    STD_RNG_LO = stats::quantile(AVAL, probs = c(0.1), na.rm = TRUE),
    STD_RNG_HI = stats::quantile(AVAL, probs = c(0.9), na.rm = TRUE)
  ) %>%
  ungroup()

adlb_x <- adlb_x %>%
  left_join(std_rng, by = "LBTEST_U") %>%
  mutate(
    AVAL = format(round(AVAL, 1), nsmall = 1),
    PCHG = format(round(PCHG, 1), nsmall = 1),
    LBNRNG = paste(ANRLO, ANRHI, sep = " - "),
    STD_RNG_LO = format(round(STD_RNG_LO, 1), nsmall = 1),
    STD_RNG_HI = format(round(STD_RNG_HI, 1), nsmall = 1)
  ) %>%
  mutate(
    STD_RNG = paste(STD_RNG_LO, STD_RNG_HI, sep = " - "),
    ANRIND = factor(case_when(
      ANRIND == "LOW" & AVAL > STD_RNG_LO ~ "L",
      ANRIND == "HIGH" & AVAL < STD_RNG_HI ~ "H",
      ANRIND == "LOW" & AVAL <= STD_RNG_LO ~ "LL",
      ANRIND == "HIGH" & AVAL >= STD_RNG_HI ~ "HH",
      TRUE ~ ""
    ))
  ) %>%
  select(LBTEST_U, TRT01A, CPID, ADY, AVAL, PCHG, STD_RNG, LBNRNG, CRC, ANRIND) %>%
  unique() %>%
  arrange(CPID, ADY) %>%
  group_by(LBTEST_U, CPID) %>%
  mutate(DLD = ADY - lag(ADY)) %>%
  ungroup() %>%
  mutate(DLD = ifelse(is.na(DLD), 0, DLD))

out <- adlb_x %>%
  select(LBTEST_U, TRT01A, CPID, ADY, DLD, AVAL, PCHG, STD_RNG, LBNRNG, CRC, ANRIND)

var_labels(out) <- names(out)
out <- out %>%
  var_relabel(
    LBTEST_U = "Lab Test (Unit)",
    TRT01A = "Treatment",
    CPID = "Center/Patient ID",
    ADY = "Study\nDay",
    DLD = "Days Since\nLast Dose of\nStudy Drug",
    AVAL = "Result",
    PCHG = "% Change\nfrom\nBaseline",
    STD_RNG = "Standard\nReference\nRange",
    LBNRNG = "Marked\nReference\nRange",
    CRC = "Clinically\nRelevant\nChange\nDec./Inc.",
    ANRIND = "Abnormality\nFlag"
  )

Reproducibility

Timestamp

[1] "2026-02-14 18:08:36 UTC"

Session Info

─ Session info ───────────────────────────────────────────────────────────────
 setting  value
 version  R version 4.5.2 (2025-10-31)
 os       Ubuntu 24.04.3 LTS
 system   x86_64, linux-gnu
 ui       X11
 language (EN)
 collate  en_US.UTF-8
 ctype    en_US.UTF-8
 tz       Etc/UTC
 date     2026-02-14
 pandoc   3.8.3 @ /usr/bin/ (via rmarkdown)
 quarto   1.8.27 @ /usr/local/bin/quarto

─ Packages ───────────────────────────────────────────────────────────────────
 package           * version     date (UTC) lib source
 backports           1.5.0       2024-05-23 [1] RSPM
 brio                1.1.5       2024-04-24 [1] RSPM
 checkmate           2.3.4       2026-02-03 [1] RSPM
 cli                 3.6.5       2025-04-23 [1] RSPM
 codetools           0.2-20      2024-03-31 [2] CRAN (R 4.5.2)
 curl                7.0.0       2025-08-19 [1] RSPM
 digest              0.6.39      2025-11-19 [1] RSPM
 dplyr             * 1.2.0       2026-02-03 [1] RSPM
 evaluate            1.0.5       2025-08-27 [1] RSPM
 fastmap             1.2.0       2024-05-15 [1] RSPM
 formatters        * 0.5.12.9002 2026-01-03 [1] https://p~
 generics            0.1.4       2025-05-09 [1] RSPM
 glue                1.8.0       2024-09-30 [1] RSPM
 htmltools           0.5.9       2025-12-04 [1] RSPM
 htmlwidgets         1.6.4       2023-12-06 [1] RSPM
 jsonlite            2.0.0       2025-03-27 [1] RSPM
 knitr               1.51        2025-12-20 [1] RSPM
 lifecycle           1.0.5       2026-01-08 [1] RSPM
 magrittr            2.0.4       2025-09-12 [1] RSPM
 otel                0.2.0       2025-08-29 [1] RSPM
 pillar              1.11.1      2025-09-17 [1] RSPM
 pkgcache            2.2.4       2025-05-26 [1] RSPM
 pkgconfig           2.0.3       2019-09-22 [1] RSPM
 processx            3.8.6       2025-02-21 [1] RSPM
 ps                  1.9.1       2025-04-12 [1] RSPM
 R6                  2.6.1       2025-02-15 [1] RSPM
 random.cdisc.data   0.3.16.9007 2025-11-13 [1] https://p~
 rlang               1.1.7       2026-01-09 [1] RSPM
 rlistings         * 0.2.13.9002 2026-01-03 [1] https://p~
 rmarkdown           2.30        2025-09-28 [1] RSPM
 sessioninfo         1.2.3       2025-02-05 [1] any (@1.2.3)
 stringi             1.8.7       2025-03-27 [1] RSPM
 stringr             1.6.0       2025-11-04 [1] RSPM
 testthat            3.3.2       2026-01-11 [1] RSPM
 tibble            * 3.3.1       2026-01-11 [1] RSPM
 tidyselect          1.2.1       2024-03-11 [1] RSPM
 vctrs               0.7.1       2026-01-23 [1] RSPM
 withr               3.0.2       2024-10-28 [1] RSPM
 xfun                0.56        2026-01-18 [1] RSPM
 yaml                2.3.12      2025-12-10 [1] RSPM

 [1] /usr/local/lib/R/site-library
 [2] /usr/local/lib/R/library
 [3] /github/home/R/x86_64-pc-linux-gnu-library/4.5
 * ── Packages attached to the search path.

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

.lock file

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

Download