University College Dublin



Different File Formats and Their Programmes:SPSSSASExcelSTATARAccessNotepadNotes.savThis is an SPSS file formatIt can be opened using SASIt can be opened using ExcelExtra stata-programme required (available for free)It can be opened but extra r-programme is required (available for free)It can be opened but cumber-someIt cannot be opened in Notepad.sps is SPSS commands.por is SPSS portable (rarely used).sasIt can be opened but labels go missingThis is an SAS file formatIt can be opened if data saved in SAS-export format (.xpt)It can be opened if data saved in SAS-export format (.xpt)It can be opened but extremely cumbersomeIt cannot be opened in Notepad.xls/.xlsxIt can be openedIt can be openedThis is an Excel file formatFirst save as .csv.csv recommended over .xlsIt can be openedIt cannot be opened in Notepad.csvIt can be openedIt can be openedThis is an Excel file formatIt can be openedIt can be openedIt can be openedIt cannot be opened in NotepadComma-separated variables.dtaIt can be openedIt can be openedIt can be openedThis is a STATA file formatIt can be openedIt cannot be opened in AccessIt cannot be opened in Notepad.do is STATA commands.rdataIt cannot be opened in SPSSIt can be openedFirst save it as .csvIt cannot be opened in StataThis is an R file formatIt cannot be opened in AccessIt cannot be opened in Notepad.accFirst save as .xlsFirst save as .xlsIt can be openedIt can be opened - bit awkward, first save as .csvIt can be opened - bit awkward, first save as .csvThis is an MS Access file formatIt cannot be opened in Notepad.mbd is old Access extension ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download