Skip to contents

Reshape format of partial dates

Source: R/dates.R
reshape_pdates.Rd

Re-arranges partial dates from a format of "UN-UNK-UNKN" ("DD-MMM-YYYY") to "UN/UN/UNKN" ("MM/DD/YYYY").

Usage

reshape_pdates(dates, output_sep = "/")

Arguments

dates

a character vector of partial dates

output_sep

the date component separator for the output, default is "/"

Value

a character vector of partial dates in the format "UN/UN/UNKN"

("MM/DD/YYYY")

Details

  • The separator character between dates components for the input vector dates can be any commonly used date separator ("/", "-", ".", " ").

  • In the starting format, the month ("UNK") is a three letter abbreviation but, in the output format, the month is converted to a number

  • The output format is a character vector, not a Date vector, to make some common SDTM date workflow operations easier

  • The case of the input month abbreviation does not matter; "Feb", "feb", and "FEB" will yield the same results

See also

reshape_adates(), impute_pdates(), trim_dates(), vignette("Dates")

Examples

dates <- c(
  "UN-UNK-UNKN",
  "UN/UNK/UNKN",
  "UN-UNK-2017",
  "UN-Feb-2017",
  "05-Feb-2017",
  "05-UNK-2017",
  "05-Feb-UNKN",
  NA
)
reshape_pdates(dates)
#> [1] "UN/UN/UNKN" "UN/UN/UNKN" "UN/UN/2017" "02/UN/2017" "02/05/2017"
#> [6] "UN/05/2017" "02/05/UNKN" NA