These pre-defined country codes are sourced from ISO 3166 Standards. See also Wikipedia.
Details
country_code
is the 3-letter ISO 3166-1 county code commonly found in the
ADSL COUNTRY
variable.
country_name
is the country long name corresponding to to the 3-letter code.
country_number
is the numeric code corresponding to an alphabetic sorting of
the 3-letter codes.
To see the entire table in the console, run print(country_code_lookup)
.
Examples
library(tibble)
library(dplyr, warn.conflicts = FALSE)
library(lubridate)
# Create reference dataset for periods
adsl <- tribble(
~USUBJID, ~SEX, ~COUNTRY,
"ST01-01", "F", "AUT",
"ST01-02", "M", "MWI",
"ST01-03", "F", "GBR",
"ST01-04", "M", "CHE",
"ST01-05", "M", "NOR",
"ST01-06", "F", "JPN",
"ST01-07", "F", "USA"
)
covar <- adsl %>%
derive_vars_merged(
dataset_add = country_code_lookup,
new_vars = exprs(COUNTRYN = country_number, COUNTRYL = country_name),
by_vars = exprs(COUNTRY = country_code)
)
covar
#> # A tibble: 7 × 5
#> USUBJID SEX COUNTRY COUNTRYN COUNTRYL
#> <chr> <chr> <chr> <dbl> <chr>
#> 1 ST01-01 F AUT 16 Austria
#> 2 ST01-02 M MWI 157 Malawi
#> 3 ST01-03 F GBR 80 United Kingdom of Great Britain and Northern I…
#> 4 ST01-04 M CHE 42 Switzerland
#> 5 ST01-05 M NOR 168 Norway
#> 6 ST01-06 F JPN 116 Japan
#> 7 ST01-07 F USA 235 United States of America