Output File Type | Export Data Tool Filenames | Data Viewer Export Filenames | Notes |
---|---|---|---|
CSV | filename.csv | filename.csv | Written natively, one file per dictionary record. Handles quote marks properly. |
Excel | (n/a) | filename.xlsx | Written natively to a single workbook, one worksheet per dictionary record. |
JSON | (n/a) | filename.json | Written natively to a single file as an array of case objects. |
R | filename.dat filename.R | filename.RData | Written natively to a single file, one vector per dictionary record. |
SAS | filename.dat filename.sas | filename.xpt filename.xpt.sas | Written natively to the two files shown. |
SPSS | filename.dat filename.sps | filename.sav | Written natively, one file per dictionary record. |
Stata | filename.dat filename.dct filename.do | filename.dta | Written natively, one file per dictionary record. |
Export Format | Export Filename | Output Box Checked? | Dictionary Record-to-Export File Relationship | Notes on "Output" Checkbox |
---|---|---|---|---|
CSV | record_name.csv | No | 1 .csv file for each record | |
CSV | record_name.csv | Yes | 1 .csv file for each record | No effect, same files output as when 'No' chosen |
Excel | filename.xlsx | No | 1 .xlsx file for the entire data file | Each record is a separate worksheet |
Excel | record_name.xlsx | Yes | 1 .xlsx file for each record | |
JSON | filename.json | No | 1 .json file for the entire data file | Each record is a separate array of objects |
JSON | record_name.json | Yes | 1 .json file for each record | |
R | filename.RData | No | 1 .RData file for the entire data file | Each record is a separate vector |
R | record_name.RData | Yes | 1 .RData file for each record | |
SAS | filename.xpt filename.xpt.sas | No | 1 .xpt/.sas file pair for the entire data file | |
SAS | record_name.xpt record_name.xpt.sas | Yes | 1 .xpt/.sas file pair for each record | |
SPSS | record_name.sav | No | 1 .sav file for each record | |
SPSS | record_name.sav | Yes | 1 .sav file for each record | No effect, same files output as when 'No' chosen |
Stata | record_name.dta | No | 1 .dta file for each record | |
Stata | record_name.dta | Yes | 1 .dta file for each record | No effect, same files output as when 'No' chosen |