Convert a date character vector (usually '--DTC') into a Date vector (usually '--DT').
convert_dtc_to_dt(
dtc,
highest_imputation = "n",
date_imputation = "first",
min_dates = NULL,
max_dates = NULL,
preserve = FALSE
)
a date object
The --DTC date to convert.
Highest imputation level
The highest_imputation
argument controls which components of the DTC
value are imputed if they are missing. All components up to the specified
level are imputed.
If a component at a higher level than the highest imputation level is
missing, NA_character_
is returned. For example, for highest_imputation = "D"
"2020"
results in NA_character_
because the month is missing.
If "n"
is specified no imputation is performed, i.e., if any component is
missing, NA_character_
is returned.
If "Y"
is specified, date_imputation
should be "first"
or "last"
and min_dates
or max_dates
should be specified respectively. Otherwise,
NA_character_
is returned if the year component is missing.
Permitted Values: "Y"
(year, highest level), "M"
(month), "D"
(day), "n"
(none, lowest level)
The value to impute the day/month when a datepart is missing.
A character value is expected, either as a
format with month and day specified as "mm-dd"
: e.g. "06-15"
for the
15th of June (The year can not be specified; for imputing the year
"first"
or "last"
together with min_dates
or max_dates
argument can
be used (see examples).),
or as a keyword: "first"
, "mid"
, "last"
to impute to the first/mid/last
day/month. If "mid"
is specified, missing components are imputed as the
middle of the possible range:
If both month and day are missing, they are imputed as "06-30"
(middle of the year).
If only day is missing, it is imputed as "15"
(middle of the month).
The argument is ignored if highest_imputation
is less then "D"
.
Minimum dates
A list of dates is expected. It is ensured that the imputed date is not
before any of the specified dates, e.g., that the imputed adverse event start
date is not before the first treatment date. Only dates which are in the
range of possible dates of the dtc
value are considered. The possible dates
are defined by the missing parts of the dtc
date (see example below). This
ensures that the non-missing parts of the dtc
date are not changed.
A date or date-time object is expected.
For example
impute_dtc_dtm(
"2020-11",
min_dates = list(
ymd_hms("2020-12-06T12:12:12"),
ymd_hms("2020-11-11T11:11:11")
),
highest_imputation = "M"
)
returns "2020-11-11T11:11:11"
because the possible dates for "2020-11"
range from "2020-11-01T00:00:00"
to "2020-11-30T23:59:59"
. Therefore
"2020-12-06T12:12:12"
is ignored. Returning "2020-12-06T12:12:12"
would
have changed the month although it is not missing (in the dtc
date).
Maximum dates
A list of dates is expected. It is ensured that the imputed date is not after any of the specified dates, e.g., that the imputed date is not after the data cut off date. Only dates which are in the range of possible dates are considered. A date or date-time object is expected.
Preserve day if month is missing and day is present
For example "2019---07"
would return "2019-06-07
if preserve = TRUE
(and date_imputation = "MID"
).
Permitted Values: TRUE
, FALSE
Usually this computation function can not be used with %>%
.
Date/Time Computation Functions that returns a vector:
compute_age_years()
,
compute_dtf()
,
compute_duration()
,
compute_tmf()
,
convert_date_to_dtm()
,
convert_dtc_to_dtm()
,
impute_dtc_dt()
,
impute_dtc_dtm()
convert_dtc_to_dt("2019-07-18")
convert_dtc_to_dt("2019-07")
Run the code above in your browser using DataLab