dbFindIdsUniqueTrials: Deduplicate records to provide unique clinical trial...

Description Usage Arguments Value Examples

View source: R/utils.R

Description

If records for a clinical trial are found from more than one register, the record from EUCTR is returned. The function currently relies on CTGOV recording other identifiers such as the EudraCT number in the field "Other IDs".

Usage

1
2
3
4
5
6
7
dbFindIdsUniqueTrials(
  preferregister = c("EUCTR", "CTGOV", "ISRCTN"),
  prefermemberstate = "GB",
  include3rdcountrytrials = TRUE,
  con,
  verbose = TRUE
)

Arguments

preferregister

A vector of the sequence of preference for registers from which to generate unique _id's, default c("EUCTR", "CTGOV", "ISRCTN")

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.

con

A src connection object, as obtained with nodbi::src_mongo() or nodbi::src_sqlite()

verbose

If set to TRUE, prints out information about numbers of records found at subsequent steps when searching for duplicates

Value

A vector with strings of keys ("_id" in the database) that represent non-duplicate trials.

Examples

1
2
3
4
5
6
7
8
9
## Not run: 
db <- nodbi::src_sqlite(
  collection = "my_collection"
)
dbFindIdsUniqueTrials(
  con = db
)

## End(Not run)

ctrdata documentation built on Nov. 22, 2021, 1:06 a.m.