Statistics files without the statistics package
Intact CSV Editor opens the files statistics software writes, and writes them too, so a dataset can be checked, cleaned and passed on without a licence for the package that made it.
| Format | Opens | Writes |
|---|---|---|
SPSS .sav | Yes | Yes — with the full column names beside the short ones |
Stata .dta | Yes | Yes — release 118, which Stata 14 and later read, and which holds UTF-8 |
SAS transport .xpt | Yes | Yes — in the 80-byte records SAS moves between machines |
SAS dataset .sas7bdat | Yes | — |
R data .rds | Yes | Yes — a data frame R reads with readRDS |
MATLAB .mat | Yes | Yes — a struct with a field per column, level 5 |
HDF5 .h5 | Yes | Yes — a dataset per column, which every HDF5 tool reads |
Then do what the data needs
Once open, a dataset is a table like any other: filter it, sort by several columns, summarise it with subtotals, count every column with Statistics — median, variance, quintiles — or join it to another file in SQL. Export it to CSV or Excel for a colleague, or to another package's format.
