Formats

Stat/Transfer Version 12 supports the following file formats.

1-2-3 Files

Stat/Transfer will read files from any version of 1-2-3. It writes Version One files, which can be read by any version of 1-2-3, and which were a universal format for PC software data interchange. Multiple page worksheets are supported on input.

Return to top

Access (Windows only)

Stat/Transfer will read and write Microsoft Access databases through the most current versions. Although the data are transferred through the Microsoft Access ODBC driver, Access files are treated like a normal Stat/Transfer file type. You can thus choose the file from the normal Open or Close dialog boxes, and you need not be concerned with the process of configuring an ODBC data source for each file.

Stat/Transfer can either read single tables or multiple tables that are joined in an Access “view”. On output, new data may be appended to an existing table, tables can be created in a new file, new tables can be created in an existing file, or existing tables can be overwritten with a new table.

Return to top

ASCII - Delimited

Stat/Transfer will read and write delimited data files.

When reading delimited files, you can specify that Stat/Transfer automatically determine if the first row contains variable names, or you can manually control how the first row of the data set will be treated. You can also explicitly specify the delimiter character or you can allow the program to sense it automatically. Numerous options are available for controlling how dates are read, and how text fields are quoted. There are numerous options for controlling the character sets in which data are read or written.

Return to top

ASCII / Text - Fixed Format

Stat/Transfer will read and write fixed format files with its own Schema file format. This format is extremely convenient to use and allows for the specification of missing values, value labels and variable labels. Stat/Transfer can also write fixed format data with programs for SAS, SPSS, or Stata. These are extremely useful for archiving data or passing data to your colleagues.

Return to top

Data Documentation Initiative (DDI) Schemas

The Data Documentation Initiative (DDI) is an open, international effort to provide a standard way of describing data from the social, behavioral and economic sciences. DDI schemas are in XML and can describe metadata across the life-cycle from questionnaire design through analysis. Stat/Transfer supports version 3.1 of the specification and will read and write XML schemas and associated delimited data files.

Return to top

 

dBASE, FoxPro (and Compatible) Files

Stat/Transfer reads and writes files that are compatible with all versions of dBASE and compatible programs such as Foxpro, Clipper, and Alpha Four.

Return to top

Epi Info

Stat/Transfer supports all versions through the most recent, Version Six. Because the file format includes enough information for the program to construct a data entry screen, Stat/Transfer uses variable labels, if available, to label the entry fields.

Return to top

Excel

Stat/Transfer will read files written by all versions of Microsoft Excel. It writes Version 2.1 files, files for Excel 97-2003 and those for Excel 2007-13. Multiple page worksheets from Versions Five and above are supported. You can choose a page of a multiple page workbook with a single click of your mouse. Multiple worksheet pages in the input file can be combined into a single output file.

Return to top

Gauss

Stat/Transfer reads and writes Gauss’s universal file format in addition to the older Gauss 89 format used for Windows.

Return to top

gretl

Stat/Transfer reads and writes gretl cross-sectional data files.

Return to top

HTML Tables

Stat/Transfer will write HTML tables for use in Web pages.

Return to top

JMP

Stat/Transfer fully supports files written on either the Windows or Macintosh platforms. All versions through Version 10 are supported as well as all of the newer numeric types.

Return to top

LIMDEP

Stat/Transfer reads and writes the native internal file format of all versions of LIMDEP for Windows.

Return to top

Matlab

Matrices from all versions of Windows, Macintosh, and Unix Matlab are supported. Matlab datasets are supported for versions greater than seven.

Return to top

Mineset

Stat/Transfer reads and writes portable files for this data visualization package developed by Silicon Graphics and now supported by Vero Software.

Return to top

Minitab

Stat/Transfer reads worksheets from any version of Minitab through Version Fourteen. It writes files in Version Eleven format and fully supports the newer Date and Date/Time types.

Return to top

Mplus

Stat/Transfer supports exporting to Mplus for Windows.

Return to top

 

NLOGIT

Stat/Transfer supports all versions of NLOGIT for Windows.

Return to top

ODBC

Stat/Transfer can read or write data to any file type for which you have, or can obtain, an ODBC driver. These include such relational databases as Oracle, SQL Server, MySQL, Sybase, DB2 or Informix, or flat-file databases such as Btrieve. When you select ODBC as an input or output file type, Stat/Transfer will present a list of installed data sources, instead of the Open or Save dialog boxes. If a password or other information is needed, you will be prompted automatically. You can also submit SQL for specialized transfers.

The Stat/Transfer command processor allows you to save connection information, so you can automate ODBC transfers

Return to top

OpenDocument Spreadsheets

The OpenDocument format for spreadsheets is an ISO standard XML format for spreadsheet data. It is supported by numerous applications, including OpenOffice.org, LibreOffice, and Google Docs. Stat/Transfer will read and write files compatable with all of these applications. The implementation is fully equivalent to that of Excel, and supports multiple sheets, range selections and all other options.

Return to top

 

OSIRIS

Because of the enormous amount of data available in this now-obsolete format, Stat/Transfer offers read-only access to OSIRIS files. Variable and value labels are fully supported and Stat/Transfer can automatically read your data whether they are in EBCDIC or ASCII format.

Return to top

Paradox

Stat/Transfer reads all versions of Paradox and writes Version 7 through 9 files.

Return to top

Quattro Pro

All versions of Quattro Pro are supported. Stat/Transfer allows the selection of data from individual pages of a multiple page worksheet.

Return to top

R

Stat/Transfer will read and write workspace files for all versions of R.

Return to top

RATS

RATS (Regression Analysis of Timeseries), is a general-purpose econometric and time series analysis package. Stat/Transfer can read and write RATS version 7 files.  

Return to top

 

SAS Data Files

Stat/Transfer will read and write SAS Versions 6 through 9 data files for Windows and Unix platforms . For version 7 and above, all common data representations are supported. Obsolete PC/DOS files are supported on input.

Return to top

SAS Value Labels

Stat/Transfer will transport value labels out of SAS for such packages as SPSS and Stata, and will, in addition, write a PROC FORMAT program for reading value labels from other packages into SAS. This feature is also handy if you are sending a SAS file with value labels to another user and do not want to send a whole format catalog.

Value labels can be read from catalogs, CPORT files, SAS data files, and from transport files.

Return to top

SAS CPORT Files

Stat/Transfer will read, but not write, Windows CPORT files for versions higher than SAS Seven.

Return to top

SAS Transport Files

These files, which can be read or written by SAS’s XPORT engine, provide a convenient way to move data from mainframe SAS and other versions for which direct data file support is not provided. They have the distinct advantage of being readable by any version of SAS and of being the standard format for the submission of data to the FDA.

Return to top

S-Plus

Stat/Transfer reads S-Plus matrices, lists and dataframes. It writes dataframes. Files can be read and written that are compatible with both Windows and Unix S-Plus versions.

Return to top

SPSS Data Files

You can read and write SPSS native data files for Windows, Macintosh, and Unix platforms. Stat/Transfer supports all of the features in these files such as value and variable labels. It will read both compressed and uncompressed files and writes the smallest possible compressed data files. Stat/Transfer can read Version 21 compressed, .gsav files.

Return to top

SPSS Portable Files

The Portable file format provides a convenient way to move data from your older mainframe systems. Stat/Transfer supports all of its features including value and variable labels and multiple missing values.

Return to top

Stata

Stata files are completely portable across platforms (the same file can be used on Unix, the PC and on the Mac.) Stat/Transfer can read all Stata files, including Stata/SE, and all versions of Stata can read the files that Stat/Transfer writes. All features are supported, including value and variable labels, extended missing values and longer variable names. Variable length strings, or strls, in version 13 are supported for reading and writing. Variable labels longer than Stata’s 80 character limit are written to Stata “notes”.

Older Stata file versions can optionally be written. Because Stata files are kept in memory, it is important to minimize the size of Stata datasets. With Stat/Transfer’s automatic optimization feature, you can be assured that you will have the smallest possible Stata files.

Return to top

Statistica

Stat/Transfer fully supports Statistica Versions 5 and 7 through 10. Value and variable labels are fully supported.

Return to top

SYSTAT

Stat/Transfer reads and writes files that are compatible with all versions of SYSTAT. All features, including subscripted variables, are supported.

Return to top

Triple-S

Triple-S is an open standard for the interchange of data and metadata between survey research software packages. Stat/Transfer fully supports the latest XML Version 2.

Return to top