Makes Your Data Instantly Usable
What do I obtain? | Supported Formats | Stat/Transfer Menu Interface | Stat/Transfer Command Interface | System Requirements | New Features in Stat/Transfer 11 | Further Information
What do I obtain?
Stat/Transfer is designed to simplify the transfer of statistical data between different programs.
Manual transfer is not only time-consuming, it is error-prone. For those in possession of data sets with many
variables, it represents a serious impediment to the use of more than one program.
Stat/Transfer removes this barrier by providing an extremely fast, reliable and automatic way to move data.
Stat/Transfer will automatically read statistical data in the internal format of one of the supported programs and
will then transfer as much of the information as is present and appropriate to the internal format of another.
Stat/Transfer preserves all of the precision in your data, while automatically minimizing the size of your output data
set. Stat/Transfer also allows control over the storage format of your output variables.
In addition to converting the formats of variables, Stat/Transfer also processes variable names, missing values and
value and variable labels automatically.
Stat/Transfer can save hours and even days of manual labor, while at the same time eliminating error. Furthermore, you
gain this speed and accuracy without losing flexibility, since Stat/Transfer allows you to select just the variables
and cases you want to transfer.
In addition to the standard Windows interface, a command processor on Windows and on Unix allows you to run a transfer
in batch mode. This makes it straightforward to set up fully automatic batch procedures for repetitive tasks
Stat/Transfer can handle datasets of virtually unlimited size at blazing speed. It is the quickest, easiest, and most
powerful way to move data between programs.
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
- Access (Windows version only)
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.
- ASCII - Delimited
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.
- ASCII - Fixed Format
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
- 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.
Stat/Transfer reads and writes Gauss’s universal file format in addition to the older Gauss 89 format used for
- HTML Tables (write only)
Stat/Transfer will write HTML tables for use in Web pages.
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
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.
- ODBC (Windows and Mac only)
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
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 (read-only)
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.
- Paradox (supported on the Windows platforms only)
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.
- SAS Data Files
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.)
- 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.
- SAS Transport
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.
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
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 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.
- Statistica (Windows only)
Stat/Transfer fully supports Statistica through the latest version, Version Five. Value and variable labels are
Stat/Transfer reads and writes files that are compatible with all versions of SYSTAT. All features, including
subscripted variables, are supported.
|Stat/Transfer Menu Interface
Stat/Transfer for Windows and Mac OS X has an easy-to-use menu interface with features such as:
- A user-friendly menu system.
- Automatic optimization of storage types to produce the smallest files
- Easy variable selection with ranges and wildcards.
- Powerful record selection and sampling.
- Complete online documentation.
- Extensive options for customizing Stat/Transfer.
- New, automatic web updates to make sure you have the latest version.
The Transfer screen allows you to perform routine transfers with a few mouse clicks.
- Select an input file type.
- Select the input file.
- Select the output file type.
- Stat/Transfer will then make up an output file specification for you. This will consist of the input
directory and file name with the correct extension appended for your new output type (You can change it if you
- Click on ‘Transfer’ and you are done. By default, all variables and cases are selected. (You can
change the default in the next two screens)
The Variables screen allows you to choose which variables will be transferred to your output data set.
You can, if you wish, choose the storage types of your variables and also activate the ‘Optimize’
feature, which makes an extra pass through your data to determine the smallest possible storage type for each
variable. You can then, if you wish, further hand-tune the storage type of each variable
The Observations screen allows you to select just the records you want in your output file. You can enter
arbitrary arithmetic expressions and use powerful sampling functions. Selection syntax is designed for ease of
use. For instance you can use wildcards and enter lists of conditions separated by commas as in:
where state = CA,AZ,W*,O*
The Options screens allow you to control how Stat/Transfer works. You can control, for instance, whether you
want to be warned if a file is about to be overwritten, whether you want the generally faster Windows 3.1 file
Open and Save dialog boxes, and whether you want Stat/Transfer to automatically make an optimization pass when
necessary to minimize the size of your output data set. Further options control the reading and writing of
dates and ASCII data files, and worksheets.
|Stat/Transfer Command Interface
On Windows and Unix an improved command processor makes it easy to:
- Enter transfer commands with a `copy' syntax.
- Use wildcards to copy groups of files with a single command.
- New syntax to copy multiple tables and sheets using wildcards.
- Build batch jobs and shortcuts for repetitive transfers.
- Save ODBC information for prompt-free connections when using Windows.
The Stat/Transfer menu interface is great for occasional use or for fine- tuning the characteristics of your
variables, but what if you need to move the same thirty files each week? For problems like this and for those users who
just can’t stand mice and menus, Stat/Transfer Version 11 provides a command processor.
This text-mode program will accept your commands in simple copy-like syntax. For instance:
copy in.sd2 out.sav
will convert the SAS file, in.
sd2 , to an SPSS file,
You can type such commands directly at the command processor’s prompt, or you can store them in a text file and
execute them later. Such deferred execution can be done either from the command processor’s prompt:
from the DOS (Windows) or operating system (MAC) command line:
or, for Windows, by simply double-clicking on the command file name from the Windows Explorer.
Further, for quick transfers, you can enter just the name of the program and the name of the files from the operating
system prompt. For instance:
st in.sd2 out.sav
will transfer a SAS file directly to an SPSS file, right from the operating system command line.
The command processor includes the ability to move a whole group of files using wildcards. For instance, the command:
st in*.sd2 out*.dta
will convert an entire directory of SAS files to Stata format and write the converted files to another directory.
Under Windows 95 or NT (or OS X), the command processor will execute other programs and operating system commands if
you precede their name with DOS (or with the word `shell”) or with an exclamation point (!). You can therefore
call programs such as Pkzip from your Stat/Transfer command files. For instance, the following sequence of commands
will extract a Stata file from a zip file, convert it to Access file and then delete the extracted file:
!pkunzip data.zip large.dta
!copy large.dta out.mdb
The command processor provides the ability to execute a ‘where’ command for record selection, a
’keep’ or ‘drop’ command for selecting variables and a variety of commands for specifying transfer
options and the information that is necessary to connect to ODBC databases.
On Windows platforms, to make ODBC connections even easier, the command processor provides the facilities to allow you
to be prompted once for connection information, and then to save a returned ODBC connection string to disk in
encrypted form so that it can be recalled for completely automatic and ‘promptless’ re-connections to your
|New Features in Stat/Transfer 11
Stat/Transfer Version 11 has added full support for the following formats:
- Data Documentation Initiative Schemas
- Open Document Spreadsheets
- MPlus (Write Only)
- Minitab 14 (Read Only)
- SPSS through Version 19
- Stata 12
Other New or improved features
- 64 Bit Windows Support. Stat/Transfer is now available as a native 64 Bit Windows application. (Both the 32
and 64 bit versions can be used under the same license.)
- Mac OS-X Lion Support. New support for OS-X 10.7
- New Options for ASCII and Text Files. You can now optionally read variable labels from the row following
the field names in worksheets.
- Read Variable Labels from Excel Files. You can now optionally read variable labels from the row following
the field names in Excel and other worksheet files.
- Time Series Options. An extensive set of options are available for controlling how time-series are read
from file formats such as RATS and how time series data are written to programs which expect rectangular data, such as
SAS and Stata.
- ODBC/Access Date and Time Sensing. You can now control the number of rows that are read to sense whether
Date/Time values in your database files should be read as dates, times or date/time values.
- Improved Character Substitution. When exact character matches are not possible in your output character
set, improved substitution algorithms usually find acceptable alternatives for single-byte characters.
|System Requirements Stat/Transfer 11
||At least a 1024*786 display
||At least a 1024*786 display
||At least a 1024*786 display
||2000, XP, Vista or Windows 7 (32 bit or 64 bit
||Apple Mac OS-X 10.4 (Tiger) or 10.5 (Leopard), 10.6 (Snow Leopard), 10.7 (Lion – S/T
- 32 or 64 bit
- Kernel 2.6 or higher
- glibc 2.3.3 or higher
- gtk 2.6.4 or higher
|Solaris 10 or higher
||Intel or AMD x86 processor
||Intel or PowerPC processor.
||Intel or AMD x86 processor
||Intel or SPARC Processor
||25 MB of free disk spac
||20 MB of free disk space
||20 MB of free disk space