Stat/Transfer by Circle Systems
Ever had a colleague send you an XYZ file that you wanted in ABC
format—say, an SPSS file that you wanted in Stata format or vice versa?
Stat/Transfer makes it easy to move data among the different spreadsheet and
statistical programs by providing a fast and reliable way to convert files
from one format to another.
Stat/Transfer was developed by
Circle Systems, Seattle, Washington, and may be
purchased through StataCorp.
Stat/Transfer 12 supports all Stata datasets, from Stata 1 through the current
Stat/Transfer 12 is available for Windows (both 64-bit and 32-bit),
Mac OS X,
Linux (both 64-bit x86 and 32-bit),
Stat/Transfer supported programs
Microsoft Access (Versions 2.0 through Office XP version)
dBASE (all versions)
Delimited ASCII with a Stat/Transfer SCHEMA file
Data Documentation Initiative (DDI) Schemas New
Excel worksheets (all versions, including Excel 2013) New
Fixed format ASCII
GAUSS (Windows and Unix)
JMP 10 New
MATLAB Seven Datasets
Minitab 14 (read only)
MPLUS (write only)
ODBC data sources (Oracle, Sybase, Informix, etc.)
Open Document Spreadsheets
Quattro Pro for DOS and Windows
S-PLUS (now supported through version 7)
SAS CPORT datasets and catalogs (read only)
SAS for Unix—HP, IBM, Sun
SAS for Unix—DEC Alpha
SAS for Windows and OS/2
SAS PC/DOS 6.04 (read only)
SAS Value Labels
SAS version 7–9
SPSS through version 21 New
SPSS Datafiles (Windows and Unix)
SPSS Portable Files
Stata (all versions, including 13) New
Statistica versions 7–8 (Windows only)
SYSTAT 13 New
Triple-S Survey Interchange Format
New in Stat/Transfer 12
Stat/Transfer version 12 has many new and improved features:
- Cross-platform licensing. Now one activation code can be used on Windows, Mac, or Linux. For example, you can activate a copy on your Windows work machine and your Mac computer at home with no extra charge.
- Windows 8 and Mac OS-X 10.8 (Mountain Lion) support.
- New options. Now you can optionally preserve the width of input strings, write variable labels to worksheet files, and control default input and output directories. A new option now controls the conversion of strings to variable length strings in Stata 13.
- Advanced ODBC options. It is now possible to use ODBC to read and write to Filemaker databases by using new options to set your user ID and password. In addition, there are new advanced tools to execute SQL statements and control the use of Unicode.
- Command processor. A new switch allows you to read a file of options to be set before a copy command executed from the operating system or Stata command line.
- Features for network users. You can now install and uninstall silently, without prompts or user intervention, install licenses along with the software, and use one copy of a lease license to serve all the machines on a network.
Stat/Transfer version 12 has added full support for the following formats:
- Excel 2013
- JMP version 10
- JMP compressed files
- SPSS 21 gsav compressed files
- Stata 13 (with strL support)
- SAS 64-bit catalogs
- SYSTAT 13
- Worksheet pages can be concatenated into a single output file.
- Value label tags and sets can be preserved.
- SAS value labels can now be read form transport files, CPORT files,
datasets, and catalogs.
- JMP support has been expanded.
- Users can specify any delimiter for ASCII files and can combine adjacent
- Generated programs and ASCII files can now preserve input widths.
- In R and S-Plus, factors can now be converted to numeric variables with
labels to string variables.
- Support for longer string variables and longer value and variable labels
has been added; Stat/Transfer is compatible with the limits of
all supported programs.
- A built-in logging and FTP facility is now available for
- Data viewer allows you to preview data in a scrollable grid before you perform
- Option to control the version and "flavor" of the output Stata dataset
that will be written by Stat/Transfer.
- Web self-update (Windows version).
- Wildcards for tables and worksheet pages (move multiple tables in a single command).
- Complete online documentation.
- Preserves all of the precision of your data.
- Support for extended (.A–.Z) missing values in Stata and SAS.
- Produces HTML tables from data.
- Automatically selects appropriate output dataset storage types.
- Automatically optimizes output dataset storage types.
- Allows manual control over output dataset storage types.
- Produces missing values automatically.
- Preserves variable names, value labels, and variable labels.
- Supports value labels for string variables.
- Allows selection of subsets of variables and cases for transfer.
- Allows choice of worksheet page.
- Runs in both menu-driven and batch modes.
- Optionally enter transfer commands with copylike syntax.
- Optionally build batch jobs and shortcuts for repetitive transfers.
- Extensive options for customization.
- Handles up to 8,000 variables; no limit on observations.
Command processor features
- The command processor now has a flexible syntax for specifying input and
output tables simultaneously.
- The command processor now allows multiple input files to be combined
into a single output file.
- Automatic wildcard transfers (e.g., copy *.dta *.sd2).
- Build batch jobs and shortcuts for repetitive transfers.
- Directly zip files or run other DOS or Windows programs.
- Enter transfer commands with a copylike syntax.
- Keep or drop processing for field selection.
- Save ODBC information for prompt-free connections.
- Time and date-time types.
- User-configurable formats for both reading and writing.
- Fully Year-2000 (and Year-1600) compliant.
User interface features
- Quick variable selection using wildcards and ranges.
- More control over how worksheet ranges and field names are read.
- Easy output path selection using a most-recently-used list.
- More control over how user-missing values are processed.