add_to_database: Adds a series of files to a database
In rOpenHealth/rEHR: Manipulating and Analysing Electronic Health Record Data

This function can be used to import a CPRD file or files into a SQLite database connection.

1 2	add_to_database(db, files, table_name, dateformat = "%d/%m/%Y", yob_origin = 1800, practid = TRUE, filenames = FALSE)

`db`	a database connection object
`files`	a character vector of filenames to files to be imported
`table_name`	a name for the table to import to
`dateformat`	the format that dates are stored in the CPRD data. If this is wrong it won't break but all dates are likely to be NA
`yob_origin`	value to add yob values to to get actual year of birth (Generally 1800)
`practid`	logical should practice id variable be constructed from the patient ids?
`filenames`	logical should the filename be included as a variable?

Will automatically unzip files before calling them in If practid is TRUE, a practid variable is constructed by converting the last 3 digits of the patient id (if supplied) to a numeric. If filenames is TRUE, source data filenames are included as a variable with the filetypes stripped away.

rOpenHealth/rEHR documentation built on March 19, 2018, 7:58 a.m.