PKCL02

Listing of Drug A Urine Concentration and Volumes

Output

Standard Listing
Data Setup

Preview
Try this using WebR

Code

lsting <- as_listing(
  out,
  key_cols = c("TRT01A", "USUBJID", "VISIT"),
  disp_cols = names(out),
  main_title = paste0(
    "Listing of ", drug_a, " Urine Concentration and Volumes following ", unique(adpc_x$REGIMEN)[1],
    " of ", drug_a, ", PK Population\nProtocol: xxnnnnn"
  ),
  subtitles = paste("Analyte:", drug_a)
)

head(lsting, 20)

Listing of Drug X Urine Concentration and Volumes following BID of Drug X, PK Population
Protocol: xxnnnnn
Analyte: Drug X

——————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————
                                                  UR_Conc (ug/mL) -    Vurine (mL) -     UR_Conc (ug/mL) -     Vurine (mL) -     UR_Conc (ug/mL) -     Vurine (mL) -     UR_Conc (ug/mL) -     Vurine (mL) -     UR_Conc (ug/mL) -     Vurine (mL) -  
                                                  Urine Collection    Urine Collection   Urine Collection    Urine Collection    Urine Collection    Urine Collection    Urine Collection    Urine Collection    Urine Collection    Urine Collection 
                                                      Interval:          Interval:       Interval (hours):   Interval (hours):   Interval (hours):   Interval (hours):   Interval (hours):   Interval (hours):   Interval (hours):   Interval (hours):
Treatment Group        Subject ID         Visit        redose              redose              0 - 4               0 - 4               4 - 8               4 - 8              8 - 12              8 - 12              0 - 24              0 - 24      
——————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————
   A: Drug X      AB12345-BRA-1-id-105    Day 1           0                713.94              5.461               96.92               0.562              235.38               0.049              384.98                NA                  NA        
                                          Day 2          NA                  NA                 NA                  NA                  NA                  NA                  NA                  NA                   0                735.22      
                  AB12345-BRA-1-id-134    Day 1           0               1068.83              4.064               145.1               0.178              352.39               0.006              576.35                NA                  NA        
                                          Day 2          NA                  NA                 NA                  NA                  NA                  NA                  NA                  NA                   0                1080.14     
                   AB12345-BRA-1-id-42    Day 1           0                817.09              4.277              110.93               0.305              269.39               0.018               440.6                NA                  NA        
                                          Day 2          NA                  NA                 NA                  NA                  NA                  NA                  NA                  NA                   0                737.25      
                   AB12345-BRA-1-id-93    Day 1           0                864.61              4.324              117.38               0.278              285.06               0.015              466.23                NA                  NA        
                                          Day 2          NA                  NA                 NA                  NA                  NA                  NA                  NA                  NA                   0                757.23      
                  AB12345-BRA-11-id-217   Day 1           0                724.93              6.225               98.41               0.672              239.01               0.059              390.91                NA                  NA        
                                          Day 2          NA                  NA                 NA                  NA                  NA                  NA                  NA                  NA                   0                1185.46     
                  AB12345-BRA-11-id-345   Day 1           0                840.09              6.511              114.05               0.588              276.98               0.04               453.01                NA                  NA        
                                          Day 2          NA                  NA                 NA                  NA                  NA                  NA                  NA                  NA                   0                883.89      
                  AB12345-BRA-11-id-397   Day 1           0                974.41              5.478              132.28               0.354              321.26               0.017              525.44                NA                  NA        
                                          Day 2          NA                  NA                 NA                  NA                  NA                  NA                  NA                  NA                   0                918.67      
                  AB12345-BRA-11-id-50    Day 1           0                922.97              4.122               125.3               0.228               304.3               0.01                497.7                NA                  NA        
                                          Day 2          NA                  NA                 NA                  NA                  NA                  NA                  NA                  NA                   0                808.08      
                  AB12345-BRA-13-id-177   Day 1           0                694.09              4.267               94.23               0.421              228.84               0.038              374.28                NA                  NA        
                                          Day 2          NA                  NA                 NA                  NA                  NA                  NA                  NA                  NA                   0                908.45      
                  AB12345-BRA-14-id-23    Day 1           0                722.84              4.254               98.13               0.386              238.32               0.032              389.78                NA                  NA        
                                          Day 2          NA                  NA                 NA                  NA                  NA                  NA                  NA                  NA                   0                 862.1

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)

drug_a <- "Drug X"
spec <- "URINE"

adpc <- random.cdisc.data::cadpc
adpc_x <- adpc %>%
  mutate(REGIMEN = ifelse("REGIMEN" %in% names(adpc), REGIMEN, "BID")) %>%
  filter(
    grepl(drug_a, PARAM),
    ASMED == spec
  )

out <- adpc_x %>%
  tidyr::pivot_longer(
    cols = c(AVAL, PCVOL),
    names_to = "URCD",
    values_to = "VALUE"
  ) %>%
  mutate(
    URCD = case_when(
      URCD == "AVAL" ~ "UR_Conc",
      URCD == "PCVOL" ~ "Vurine",
      TRUE ~ URCD
    ),
    UNIT = case_when(
      URCD == "UR_Conc" ~ as.character(AVALU),
      URCD == "Vurine" ~ as.character(PCVOLU),
      TRUE ~ "NA"
    )
  ) %>%
  mutate(
    PARAM_INT = paste0(
      URCD, " (", UNIT, ") -\nUrine Collection\nInterval",
      ifelse(PCTPT == "Predose", "", " (hours)"), ":\n",
      gsub("[PTH]", "", PCTPT)
    )
  ) %>%
  select(TRT01A, USUBJID, VISIT, PARAM_INT, VALUE) %>%
  unique() %>%
  tidyr::pivot_wider(
    id_cols = c(TRT01A, USUBJID, VISIT),
    names_from = PARAM_INT,
    values_from = VALUE
  )

var_labels(out) <- names(out)
out <- out %>% var_relabel(
  TRT01A = "Treatment Group",
  USUBJID = "Subject ID",
  VISIT = "Visit"
)

Reproducibility

Timestamp

[1] "2025-08-13 17:35:03 UTC"

Session Info

─ Session info ───────────────────────────────────────────────────────────────
 setting  value
 version  R version 4.5.0 (2025-04-11)
 os       Ubuntu 24.04.2 LTS
 system   x86_64, linux-gnu
 ui       X11
 language (EN)
 collate  en_US.UTF-8
 ctype    en_US.UTF-8
 tz       Etc/UTC
 date     2025-08-13
 pandoc   3.7.0.2 @ /usr/bin/ (via rmarkdown)
 quarto   1.7.32 @ /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.2       2024-07-29 [1] RSPM
 cli                 3.6.5       2025-04-23 [1] RSPM
 codetools           0.2-20      2024-03-31 [2] CRAN (R 4.5.0)
 curl                6.4.0       2025-06-22 [1] RSPM
 digest              0.6.37      2024-08-19 [1] RSPM
 dplyr             * 1.1.4       2023-11-17 [1] RSPM
 evaluate            1.0.4       2025-06-18 [1] RSPM
 fastmap             1.2.0       2024-05-15 [1] RSPM
 formatters        * 0.5.11.9002 2025-08-13 [1] https://p~
 generics            0.1.4       2025-05-09 [1] RSPM
 glue                1.8.0       2024-09-30 [1] RSPM
 htmltools           0.5.8.1     2024-04-04 [1] RSPM
 htmlwidgets         1.6.4       2023-12-06 [1] RSPM
 jsonlite            2.0.0       2025-03-27 [1] RSPM
 knitr               1.50        2025-03-16 [1] RSPM
 lifecycle           1.0.4       2023-11-07 [1] RSPM
 magrittr            2.0.3       2022-03-30 [1] RSPM
 pillar              1.11.0      2025-07-04 [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
 purrr               1.1.0       2025-07-10 [1] RSPM
 R6                  2.6.1       2025-02-15 [1] RSPM
 random.cdisc.data   0.3.16.9006 2025-08-13 [1] https://p~
 rlang               1.1.6       2025-04-11 [1] RSPM
 rlistings         * 0.2.12.9001 2025-08-13 [1] https://p~
 rmarkdown           2.29        2024-11-04 [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.5.1       2023-11-14 [1] RSPM
 testthat            3.2.3       2025-01-13 [1] RSPM
 tibble            * 3.3.0       2025-06-08 [1] RSPM
 tidyr               1.3.1       2024-01-24 [1] RSPM
 tidyselect          1.2.1       2024-03-11 [1] RSPM
 vctrs               0.6.5       2023-12-01 [1] RSPM
 withr               3.0.2       2024-10-28 [1] RSPM
 xfun                0.52        2025-04-02 [1] RSPM
 yaml                2.3.10      2024-07-26 [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

Output

Reproducibility

Timestamp

Session Info

.lock file

`.lock` file