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
load_database()
Load a list in an environment
edc_database
EDCimport Database
edc_lookup()
Retrieve the lookup table from options

Modifying databases

edc_unify_subjid()
Harmonize the subject ID of the database
edc_split_mixed()
Split mixed datasets
edc_clean_names()
Clean up the names of all datasets

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

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

edc_find_value() edc_find_column()
Search 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
edc_viewer()
Shiny data explorer

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
edc_crf_plot() edc_pal_crf()
Show the current CRF status distribution
edc_patient_gridplot()
Patient gridplot
edc_population_plot()
Plot the populations

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
get_datasets()
Retrieve the datasets as a list of data.frames
edc_left_join()
Join within the EDCimport framework

Examples

edc_example()
Example database

Manual correction

manual_correction() reset_manual_correction() experimental
Manual correction