read_all_sas {EDCimport} | R Documentation |
Read all .sas7bdat
files in a directory
Description
Read all .sas7bdat
files in a directory. Formats (factors levels) can be applied from a procformat.sas
SAS file, or from a format dictionary. See the "Format file" section below. Column labels are read directly from the .sas7bdat
files.
Usage
read_all_sas(
path,
...,
format_file = "procformat.sas",
subdirectories = FALSE,
datetime_extraction = "guess",
verbose = getOption("edc_read_verbose", 1),
clean_names_fun = NULL
)
Arguments
path |
[ |
... |
unused |
format_file |
[ |
subdirectories |
[ |
datetime_extraction |
[ |
verbose |
[ |
clean_names_fun |
|
Value
a list containing one dataframe for each .xpt
file in the folder, the extraction date (datetime_extraction
), and a summary of all imported tables (.lookup
).
Format file
format_file
should contain the information about SAS formats. It can be either:
a
procformat.sas
file, containing the whole PROC FORMATor a data file (
.csv
or.sas7bdat
) containing 3 columns:-
FMTNAME
the SAS format name (repeated) -
START
the variable level -
LABEL
the label associated to the level
You can get this datafile from SAS using
PROC FORMAT
with optionCNTLOUT
. Otherwise, you can useoptions(edc_var_format_name="xxx", edc_var_level="xxx", edc_var_label="xxx")
to specify different column names.-
See Also
Other EDCimport reading functions:
read_all_csv()
,
read_all_xpt()
,
read_trialmaster()
Examples
# Create a directory with multiple sas files.
path = paste0(tempdir(), "/read_all_sas")
dir.create(paste0(path, "/subdir"), recursive=TRUE)
haven::write_sas(attenu, paste0(path, "/attenu.sas7bdat"))
haven::write_sas(mtcars, paste0(path, "/mtcars.sas7bdat"))
haven::write_sas(mtcars, paste0(path, "/subdir/mtcars.sas7bdat"))
haven::write_sas(esoph, paste0(path, "/esoph.sas7bdat"))
db = read_all_sas(path, format_file=NULL, subdirectories=TRUE) %>%
set_project_name("My great project")
db
edc_lookup()