dfFindUniqueEuctrRecord: Select a single trial record from records of different EU...

View source: R/dbFindIdsUniqueTrials.R

dfFindUniqueEuctrRecordR Documentation

Select a 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 = "DE",
  include3rdcountrytrials = TRUE
)

Arguments

df

A data frame created from the database collection 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 DE or lacking this, any random Member State's record for the trial will be returned. For a list of codes of EU Member States, please see vector countriesEUCTR. Specifying "3RD" will return the Third Country record of trials, where available.

include3rdcountrytrials

A logical value if trials should be retained that are conducted exclusively in third countries, that is, outside the European Union. Ignored if prefermemberstate is set to "3RD".

Details

Note: To deduplicate trials from different registers, please first use function dbFindIdsUniqueTrials.

Value

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


ctrdata documentation built on Nov. 24, 2023, 5:11 p.m.