add daily dose information to a drug_exposure table

Usage

addDailyDose(drugExposure, ingredientConceptId, name = NULL)

Arguments

drugExposure

drugExposure it must contain drug_concept_id, quantity, drug_exposure_start_date and drug_exposure_end_date as columns

ingredientConceptId

ingredientConceptId for which to filter the drugs of interest

name

Name of the computed table, if NULL a temporary table will be generated.

Value

same input table

Examples

# \donttest{
library(DrugUtilisation)
library(dplyr)
#> 
#> Attaching package: ‘dplyr’
#> The following objects are masked from ‘package:stats’:
#> 
#>     filter, lag
#> The following objects are masked from ‘package:base’:
#> 
#>     intersect, setdiff, setequal, union

cdm <- mockDrugUtilisation()

cdm[["drug_exposure"]] |>
  filter(drug_concept_id == 2905077) |>
  addDailyDose(ingredientConceptId = 1125315)
#> Warning: `addDailyDose()` was deprecated in DrugUtilisation 0.7.0.
#> # Source:   table<og_021_1734615685> [?? x 25]
#> # Database: DuckDB v1.1.3 [unknown@Linux 6.8.0-1017-azure:R 4.4.2/:memory:]
#>   drug_exposure_id person_id drug_concept_id drug_exposure_start_date
#>              <int>     <int>           <int> <date>                  
#> 1               12         6         2905077 2019-05-13              
#> 2               21         9         2905077 2019-03-29              
#> # ℹ 21 more variables: drug_exposure_end_date <date>,
#> #   drug_type_concept_id <int>, quantity <dbl>,
#> #   drug_exposure_start_datetime <date>, drug_exposure_end_datetime <date>,
#> #   verbatim_end_date <date>, stop_reason <chr>, refills <int>,
#> #   days_supply <int>, sig <chr>, route_concept_id <int>, lot_number <chr>,
#> #   provider_id <int>, visit_occurrence_id <int>, visit_detail_id <int>,
#> #   drug_source_value <chr>, drug_source_concept_id <int>, …
# }