addDateOfBirthQuery: Query to add a column with the individual birth date

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

Query to add a column with the individual birth date

Description

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

Usage

addDateOfBirthQuery(
  x,
  dateOfBirthName = "date_of_birth",
  missingDay = 1,
  missingMonth = 1,
  imposeDay = FALSE,
  imposeMonth = FALSE
)

Arguments

x	Table with individuals in the cdm.
dateOfBirthName	dateOfBirth column name.
missingDay	day of the month assigned to individuals with missing day of birth.
missingMonth	Month of the year assigned to individuals with missing month of birth.
imposeDay	TRUE or FALSE. Whether the day of the date of birth will be considered as missing for all the individuals.
imposeMonth	TRUE or FALSE. Whether the month of the date of birth will be considered as missing for all the individuals.

Value

The function returns the table x with an extra column that contains the date of birth.

Examples

library(PatientProfiles)

cdm <- mockPatientProfiles(source = "duckdb")

cdm$cohort1 |>
  addDateOfBirthQuery()

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