Learn R Programming

ctrdata (version 1.1)

dfFindUniqueEuctrRecord: Select single trial record from records of different EU Member States

Description

The EUCTR provides one record per trial per EU Member State in which the trial is conducted. For all trials conducted in more than one Member State, this function returns only one record per trial.

Usage

dfFindUniqueEuctrRecord(
  df = NULL,
  prefermemberstate = "GB",
  include3rdcountrytrials = TRUE
)

Arguments

df

A data frame created from the database that includes the columns "_id" and "a2_eudract_number", for example created with function dbGetFieldsIntoDf(c("_id", "a2_eudract_number")).

prefermemberstate

Code of single EU Member State for which records should returned. If not available, a record for GB or lacking this, any other record for the trial will be returned. For a list of codes of EU Member States, please see vector countriesEUCTR. Alternatively, "3RD" will lead to return a Third Country record of a trial, if available.

include3rdcountrytrials

A logical value if trials should be retained that are conducted exclusively in third countries, that is, outside the European Union.

Value

A data frame as subset of df corresponding to the sought records.

Details

Note: To deduplicate trials from different registers (EUCTR and CTGOV), please first use function dbFindIdsUniqueTrials.