 |
 |
 |
 |
 |
 |
 |
Version 9 File Formats
Stat/Transfer Version 9 supports the following file formats.
- 1-2-3
- Access (Windows version only)
- ASCII - Delimited
- ASCII- Fixed Format
- dBASE and compatible formats
- Epi Info
- Excel
- FoxPro
- Gauss
- HTML Tables (write only)
- JMP
- LIMDEP
- Matlab
- Mineset
- Minitab
- NLOGIT
- ODBC (Windows and Mac versions only)
- OSIRIS (read-only)
- Paradox
- Quattro Pro
- R
- SAS Data Files
- SAS Value Labels
- SAS CPORT (read-only)
- SAS Transport Files
- S-PLUS
- SPSS Data
- SPSS Portable
- Stata
- Statistica (Windows version only)
- SYSTAT
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 are a universal format for PC software data interchange. Multiple page worksheets are supported.
Stat/Transfer will read and write Microsoft Access databases through the Office XP version. Although the data are transferred through the Microsoft Access ODBC driver, Access files are treated as 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 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.
Stat/Transfer will read and write delimited ASCII files.
When reading Delimited ASCII 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.
Stat/Transfer will read and write Fixed Format ASCII 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. It will also write Fixed Format ASCII with programs for SAS, SPSS, and Stata. These are extremely useful for archiving data or passing data to your colleagues.
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.
Epi Info
Stat/Transfer supports all version 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.
Stat/Transfer will read files written by all versions of Microsoft Excel. It writes Version 2.1 files and files for Excel 97 and higher versions. Multiple page worksheets in Versions Five and above are supported. You can choose a page of a multiple page workbook with a single click of your mouse.
Gauss
Stat/Transfer reads and writes Gauss’s universal file format in addition to the older Gauss 89 format used for Windows.
Stat/Transfer will write HTML tables for use in Web pages.
JMP
Stat/Transfer fully supports files written on either the Windows or Macintosh platforms. All versions through Version 5 are supported as well as all of the newer numeric types.
Stat/Transfer reads and writes the native internal file format of the latest version of LIMDEP for Windows.
Matlab matrices from Windows Macintosh, and Unix platforms are supported. Stat/Transfer will automatically recognize a file's platform of origin on input. On output, it writes files that can be read by any version of Matlab.
Stat/Transfer reads and writes portable files for this data visualization package from Silicon Graphics.
Stat/Transfer reads worksheets from any version of Minitab through Version Twelve. It writes files in Version Eleven format and fully supports the newer Date and Date/Time types.
NLOGIT
Stat/Transfer supports NLOGIT Version 3 for Windows.
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, 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.
The Stat/Transfer command processor allows you to save connection information, so you can automate ODBC transfers. It also allows you to submit SQL for specialized transfers.
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 is smart enough to automatically read your data whether they are in EBCDIC or ASCII format.
Stat/Transfer reads all versions of Paradox and writes Version 7 through 9 files.
Quattro Pro
All versions of Quattro Pro are supported. Stat/Transfer allows the selection of data from individual pages of a multiple page worksheet.
R
Stat/Transfer will read and write workspace files for Version 2 of R.
Stat/Transfer will read and write SAS Versions 6 through 9 data files for the Windows & OS/2 and Unix HP/Sun/IBM and Macintosh platforms
For Unix DEC, the current version of Stat/Transfer will both read and write Version 6 files.
You can control the “data representation” of the output SAS dataset.
Our transparent support for these variants of the
SAS file format means that you can read and write files for your Unix machine right on your PC (A trick that not even SAS itself can manage.)
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.
SAS CPORT Files
Stat/Transfer will read, but not write, Windows CPORT files for Versions higher than SAS Seven.
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.
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. Files written on 64 bit machines such as the DEC Alpha are not supported.
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.
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.
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. Older file formats of Versions 4 through 7 files 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.
Stat/Transfer fully supports Statistica through the latest version, Version Five. Value and variable labels are fully supported.
SYSTAT
Stat/Transfer reads and writes files that are compatible with all versions of SYSTAT. All features, including subscripted variables, are supported.
[Home] [Products] [Ordering] [Downloads] [Support] [Lists] [Contact Us]
Please contact our Webmaster with questions or comments.