addAgeQuery: Query to add the age of the individuals at a certain date

In PatientProfiles: Identify Characteristics of Patients in the OMOP Common Data Model

Query to add the age of the individuals at a certain date

Description

Same as addAge(), except query is not computed to a table.

Usage

addAgeQuery(
  x,
  indexDate = "cohort_start_date",
  ageName = "age",
  ageGroup = NULL,
  ageMissingMonth = 1,
  ageMissingDay = 1,
  ageImposeMonth = FALSE,
  ageImposeDay = FALSE,
  ageUnit = "years",
  missingAgeGroupValue = "None"
)

Arguments

x	Table with individuals in the cdm.
indexDate	Variable in x that contains the date to compute the demographics characteristics.
ageName	Age variable name.
ageGroup	if not NULL, a list of ageGroup vectors.
ageMissingMonth	Month of the year assigned to individuals with missing month of birth.
ageMissingDay	day of the month assigned to individuals with missing day of birth.
ageImposeMonth	TRUE or FALSE. Whether the month of the date of birth will be considered as missing for all the individuals.
ageImposeDay	TRUE or FALSE. Whether the day of the date of birth will be considered as missing for all the individuals.
ageUnit	Unit for age it can either be 'years', 'months' or 'days'.
missingAgeGroupValue	Value to include if missing age.

Value

tibble with the age column added.

Examples

library(PatientProfiles)

cdm <- mockPatientProfiles(source = "duckdb")

cdm$cohort1 |>
  addAgeQuery()

PatientProfiles documentation built on Feb. 24, 2026, 5:10 p.m.