roche_derive_rave_row: Utility function to obtain Rave form name and row number

In sdtmchecks: Data Quality Checks for Study Data Tabulation Model (SDTM) Datasets

Utility function to obtain Rave form name and row number

Description

This function derives the Rave form name and row number from xxSPID. The xxSPID string may yield unexpected results for outsourced studies. Log forms will show the row number as #n. Non-log forms may show #0 after the form name.

Usage

roche_derive_rave_row(
  dts,
  domains = c("ae", "ce", "cm", "ds", "lb", "mh", "pr", "rs", "ss", "tr", "tu")
)

Arguments

dts	SDTM dataframe - e.g., AE
domains	domains you wish to identify a xxSPID variable from

Value

dataframe with Rave row number

Author(s)

Stella Banjo (HackR 2021)

Examples

AE <- data.frame(
  STUDY = c(rep("1", 6)),
  DOMAIN = c(rep("AE", 6)),
  USUBJID = c(rep("PT1", 6)),
  AESEQ = c(1, 2, 3, 4, 5, 6),
  AETERM = rep("AE Raw Term",6),
  AEDECOD = rep("AE Preferred Term",6),
  AESPID = c("FORMNAME-R:13/L:13XXXX",
             "FORMNAME-R:16/L:16XXXX",
             "FORMNAME-R:2/L:2XXXX",
             "FORMNAME-R:19/L:19XXXX",
             "FORMNAME-R:5/L:5XXXX",
             "FORMNAME-R:20/L:20XXXX"),
  AESTDTC = c(rep("2020-01-01", 6)),
  stringsAsFactors = FALSE
)

roche_derive_rave_row(AE)

sdtmchecks documentation built on Sept. 11, 2024, 9:34 p.m.