Stat/Transfer by Circle Systems

Stat/Transfer supported programs

1-2-3 Microsoft Access (Versions 2.0 through Office XP version) dBASE (all versions) Delimited ASCII Delimited ASCII with a Stat/Transfer SCHEMA file Epi Info Excel worksheets (all versions, including Excel 2007) Fixed format ASCII FoxPro GAUSS (Windows and Unix) JMP LIMDEP MATLAB MATLAB Seven Datasets  Mineset Minitab NLOGIT ODBC data sources (Oracle, Sybase, Informix, etc.) OSIRIS (read-only)

Paradox Quattro Pro for DOS and Windows R 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 Transport SAS Value Labels SAS Version 7–9 SPSS Version 17  SPSS Datafiles (Windows and Unix) SPSS Portable Files Stata (all versions, including 11) Statistica Versions 7–8  (Windows only) SYSTAT (Windows and Mac) Triple-S Survey Interchange Format

New in Stat/Transfer 10

Stat/Transfer Version 10 has many new and improved features:

• International character set support
  Stat/Transfer can now read datasets in any character set, including multibyte and far-eastern, and Unicode characters.
• Improved option screens
  The option screens have been expanded and reorganized to allow much greater control over the transfer process and the user interface.
• Automatic program generation
  You can specify that a program for the command processor be written when a transfer is carried out using the Stat/Transfer user interface. All the information you have specified for the transfer will be translated into a Stat/Transfer command file, including all of your option settings. This enables you to reproduce your transfer operation either from the user interface or as a batch job from your operating system. It also allows you to precisely document how your transfer was performed.
• Improved data viewer
  The data viewer has been improved and will now display long strings, international character sets, variable characteristics, and value labels.
• Value label browser
  You can now examine value labels for each variable on the variables tab.
• Quick variable type changer
  You can change the type of many variables at a time using wildcards, ranges, or lists.
• Automatic transfer logging
  You can tell Stat/Transfer to automatically write a log file to disk every time you do a data transfer. The log file will contain detailed information about what has occurred during your transfer. By default, this will go to the same directory as your output file.
• New user interface
  The user interface is now the same on Windows, Mac OS-X, and Linux.
• Expanded variable labels
  Variable labels longer than Stata’s maximum are now written to Stata both as truncated variable labels and in full as Stata notes.

Stat/Transfer Version 10 has added support for the following formats:

• Matlab Seven Datasets
• SPSS Version 17
• Statistica Versions 7-8 (on Windows)
• Triple-S Survey Interchange Format

Stat/Transfer features

• 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 black delimiters.
• 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 troubleshooting.
• Full compatibility with Microsoft Vista.
• Data viewer allows you to preview data in a scrollable grid before you perform your transfer
• 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 copy-like 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 copy-like syntax
• Keep or drop processing for field selection
• Save ODBC information for prompt-free connections

Date/time support

• 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