getData4leuko: get the leukocyte count from the table FRM_LABORWERTE

In maciejrosolowski/progressdatenbankderivate: Extract and Process Data from the Database of the PROGESS Study

get the leukocyte count from the table FRM_LABORWERTE

Description

The values with COL == "LEUKO" in the table FRM_LABORWERTE are returned with the suffix "_dbb". The maximum over the values with COL in "LEUKO", "LEUKOMIN" or "LEUKOMAX" within each combination of patient and event is returned with the suffix "_max". Similarly, the minimum over these values is returned with the suffix "_min".

Usage

getData4leuko(FRM_DIL_LABORWERTE)

Arguments

FRM_DIL_LABORWERTE

data.table containing the table FRM_DIL_LABORWERTE from the database of the PROGRESS study

Value

data.table in the wide format. Each row corresponds to one patient and the columns contain leukocyte count (dbb, min, max) at a given time.

Examples

## Not run: 
excel_fn <- paste0("/net/ifs1/san_projekte/projekte/",
"PROGRESS/Datenmanagement/Data_freezes/",
"20190320/PROGRESS-freeze_201903_01.xlsx")
FRM_DIL_LABORWERTE <- readxl::read_excel(excel_fn, "FRM_DIL_LABORWERTE")
data.table::setDT(FRM_DIL_LABORWERTE)
leuko_dat <- getData4leuko(FRM_DIL_LABORWERTE)
leuko_dat

## End(Not run)

maciejrosolowski/progressdatenbankderivate documentation built on Nov. 29, 2024, 3:39 a.m.