Skip to contents

Reading databases

read_trialmaster()
Read the .zip archive of a TrialMaster export
read_all_xpt()
Read all .xpt files in a directory
read_all_sas()
Read all .sas7bdat files in a directory
read_all_csv()
Read all .csv files in a directory

Checking databases

edc_data_warn() edc_data_stop() edc_data_warnings()
Standardized warning system
assert_no_duplicate()
Assert that a dataframe has one row per patient
edc_warn_patient_diffs()
Check the validity of the subject ID column
edc_warn_extraction_date()
Warn if extraction is too old
crf_status_plot() edc_pal_crf()
Show the current CRF status distribution
edc_population_plot()
Plot the populations

Project management

edc_inform_code()
Shows how many code you wrote
search_for_newer_data()
Search for newer data
save_sessioninfo()
Save sessionInfo() output

Searching databases

find_keyword()
Find a keyword in the whole database
lastnews_table()
Get a table with the latest date for each patient
edc_db_to_excel() edc_browse_excel()
Save the database as an Excel file
get_common_cols() summary(<common_cols>) experimental
Get columns that are common to multiple datasets

Options

edc_options()
Set global options for EDCimport
edc_peek_options()
See which EDCimport option is currently set.
edc_reset_options()
Reset all EDCimport options.

Graphics

edc_swimmerplot()
Swimmer plot of all dates columns

Helpers

unify()
Unify a vector
fct_yesno()
Format factor levels as Yes/No
table_format()
Identify if a dataframe has a long or a wide format
save_plotly()
Save a plotly to an HTML file
select_distinct()
Select only distinct columns
harmonize_subjid()
Harmonize the subject ID of the database
get_datasets()
Retrieve the datasets as a list of data.frames
get_meta_cols()
Get columns shared by most datasets
get_subjid_cols() get_crfname_cols()
Get key column names
get_key_cols()
Important column names
split_mixed_datasets()
Split mixed datasets

Lookup Utils

edc_lookup()
Retrieve the lookup table from options
extend_lookup()
Extend the lookup table
build_lookup()
Generate a lookup table

List Utils

load_list()
Load a list in an environment
load_as_list()
Load a .RData file as a list
save_list()
Save a list as .RData file

Examples

Manual correction