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. It 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 and it 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 graphical user interface, a command processor allows you to run a transfer in batch mode. This makes it straightforward to set up fully automatic batch procedures for repetitive tasks.
THE STAT/TRANSFER USER INTERFACE
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 like.)
- If you want to transfer all variables and cases, click on ‘Transfer’ and you are done. (You can select variables and cases in the next two screens, the Variables dialog box and the Observations dialog box, before clicking on ‘Transfer’.
Stat/Transfer is intelligently designed to save you mouse clicks and keystrokes.
For instance, although the output path is automatically constructed from the input path, if you change the path to another drive or directory, that directory will be used for the automatically generated output paths of subsequent transfers. Thus, if you intend to move files from one drive or directory to another, Stat/Transfer will recognize that fact and not require you to navigate to your new directory every time. To further save key stokes, most recently used lists are maintained both for input files and for output directories.
The Variables screen allows you to choose which variables will be transferred to your output data set. You can also view the characteristics of each variable, such as the preferred output or “target” types, the variable labels and the value labels.
Stat/Transfer automatically makes an extra pass through your data to determine the best output variable type and the minimum string width for your variables. However, if you wish, you can manually choose the storage types of each of your variables.
You can quickly choose variables to keep or drop by using the “Quick Variable Selector” window, which accepts wildcards, lists and ranges of variable names. The “Quick Type Selector” similarly makes fast work of changing variable types.
The Observations screen allows you to select just the records you want from your input file. You can enter arithmetic expressions and selection conditions. You can also 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 screen allows you to control how Stat/Transfer operates. You can control, for instance, whether you want to be warned if a file is about to be overwritten. These options are organized by category and provide extensive control over transfer operations. The defaults are designed sensibly, so that in the most typical cases, the options need not be touched. However, at times the defaults will not be what you need, so Stat/Transfer gives you the flexibility to control every aspect of the transfer process when you need to.
RUN PROGRAM SCREEN
Stat/Transfer has always had a stand-alone command processor that allows transfers to be run in batch mode with simple commands. Now, the command processor and the user interface have become integrated. The user interface can automatically generate command files after your transfer has been performed and then you can then re-run these transfers right from the user interface. From the Run Program screen you can load programs, edit them if necessary, and call the command processor to run your programs.
The Log screen allows you to see progress and error messages, which can be read as the transfer progresses and can be saved to a file. In case of errors or problems, this file can be sent to Circle Systems technical support.
Stat/Transfer moves your data from one program to another with no loss of precision, while producing the smallest datasets possible. All of your metadata – value labels, variable labels and missing values – are accurately and effortlessly transformed.
Stat/Transfer can automatically produce a log documenting your transfer operations. It can also produce a Stat/Transfer command processor file that will enable you to re-run the transfer with just a few clicks. Because this program reflects the entire state of your options settings as well as all of the other information entered in the user interface, it allows you to thoroughly document your data transfer.
With Stat/Transfer you can produce just the output you need. It is easy to select variables, cases and data types. A variety of options (all with sensible defaults) allow you to tailor your transfer so that it meets the needs that you have today and in the future.
Most transfer operations take just a few seconds and few clicks of the mouse. Of course you could use other tools to do what Stat/Transfer does, but it would take you hours, days, and even weeks of effort to duplicate what Stat/Transfer does in a few seconds. What is your time worth?
|EASE OF USE
Fast transfers aren’t fast if you have to spend time puzzling over how to set them up. With Stat/Transfer’s intuitive user interface, most transfers can be performed with only a few mouse clicks. For more complicated operations, context sensitive help is a click away. Stat/Transfer is designed from top to bottom to save your valuable time.
Stat/Transfer Version 14 has added support for the following formats:
BayesiaLab (Write Only)
JSON-Stat (Read Only)
| EXTENDED ATTRIBUTE SUPPORT
Variable- and File-level metadata are now supported for reading and writing from the following formats:
SAS (extended attributes)
ASCII – Stat/Transfer Schemas
|ENHANCED SAS SUPPORT
Value Labels can now be written directly to native Windows SAS catalog files (sas7cat)
Optional control over date, time and date-time formats used for writing.
All SAS date and time formats are recognized on reading.
Labels for SAS extended missing are now supported.
|OTHER NEW FEATURES
Directory recursion is now available in the wildcard copy command
An extra variables can be created from the sheet name when combining worksheets
Extra string variables can be created from value labels when writing to delimited ASCII, described by a schema. These can then be read back in any format.
Much faster read of R files.
Postgres support in ODBC.
Excel Files > 4 GB
SAS files > 32K variables
Stata Files > 32K variables
dBASE > 2GB
THE COMMAND PROCESSOR
Improved Command Processor Eases Repetitive Transfers
The Stat/Transfer menu interface is fine 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 provides a command processor.
SINGLE USER LICENCE AGREEMENT AND LIMITED WARRANTY FOR STAT/TRANSFER
IMPORTANT – READ CAREFULLY BEFORE INSTALLING THE STAT/TRANSFER SOFTWARE. By clicking the “next” button, opening the sealed packet(s) containing the software, or using any portion of the software, you accept all of the following Circle Systems License Agreement.
THIS IS A LEGAL AGREEMENT BETWEEN CIRCLE SYSTEMS, INC. AND YOU, THE END USER. CAREFULLY READ THIS AGREEMENT BEFORE OPENING, INSTALLING, OR USING THE STAT/TRANSFER SOFTWARE (the “software”). CIRCLE SYSTEMS WILL NOT ACCEPT ANY PURCHASE ORDER OR SELL YOU A LICENSE TO INSTALL AND USE THE SOFTWARE UNLESS YOU AGREE TO ALL OF THE TERMS OF THIS LICENSE AGREEMENT. IF YOU DO NOT AGREE TO THESE TERMS, DO NOT OPEN THE DISK PACKAGE, OR INSTALL OR USE THE SOFTWARE ON YOUR COMPUTER; REMOVE ALL COPIES FROM YOUR COMPUTER AND RETURN THE SOFTWARE AND ANY ACCOMPANYING MATERIALS WITHIN 30 DAYS OF PURCHASE, WITH PROOF OF PURCHASE, FOR A FULL REFUND OF THE AMOUNT YOU ORIGINALLY PAID FOR THE SOFTWARE.
Circle Systems grants you the right to load and use one copy of the software on a single computer (your “Dedicated Computer”). You may transfer the software to another single Dedicated Computer provided you remove all copies of the software from the first computer when you install it on the other computer. If one individual uses the Dedicated Computer more than 80% of the time that it is in use, then that individual may also load and use the software on that individual’s portable or home computer. You may also make a copy of the software for backup or archival purposes. If you receive a copy of the software electronically and on disk, you may use the disk copy for archival purposes only.
Copyright and other intellectual property laws and international treaty protect this software. Copyright law prohibits you from making any other copy of the software and user manual without the permission of Circle Systems. You may not alter, modify, or adapt the software or user manual, or create any derivative works based on them. Circle Systems distributes the software in computer executable form only, and does not allow user access to the underlying source code and data. You may not reverse engineer, decompile, or disassemble the software to gain access to such code and data, except to the extent applicable law expressly permits such activity. Decompiling or disassembling the software may also violate the software’s copyright.
You may not sublicense, sell, rent, lend, lease, sublicense, or give away the software to others. You may, however, with the prior written permission of Circle Systems, transfer the software, written materials, and this license agreement as a package if the other party registers with Circle Systems and agrees to accept this agreement. You may not transfer a license originally sold in a volume or network license unless you transfer all the licenses at the site. You may not retain any copies of the software yourself once you have transferred it.
Any unauthorized copying, distribution, or modification of the software will automatically cancel your license to use the software and violate the software’s copyright.
LIMITED WARRANTY AND REMEDIES
Circle Systems warrants that the software will perform in substantial compliance with the specifications set forth in the user manual provided with the software, provided that it is not modified and it is used on the computer hardware and with the operating system for which it was designed. Circle Systems also warrants that any disk media and printed user manuals it provides are free from defects in materials and workmanship under normal use. These warranties are limited to the 30-day period from your original purchase. If you report in writing within 30 days of purchase a substantial defect in the software’s performance, Circle Systems will attempt to correct it or, at its option, authorize a refund of the amount you originally paid for the software. If you return faulty media or a printed user manual during this period, along with a dated proof of purchase, Circle Systems will replace it free of charge. You must insure items being returned, since Circle Systems does not accept the risk of loss or damage in transit.
THE WARRANTIES AND REMEDIES SET FORTH ABOVE ARE EXCLUSIVE AND IN PLACE OF ALL OTHERS, ORAL OR WRITTEN, EXPRESS OR IMPLIED. CIRCLE SYSTEMS DOES NOT AND CANNOT WARRANT THE PERFORMANCE OR RESULTS YOU MAY OBTAIN USING THE SOFTWARE. EXCEPT FOR THE FOREGOING LIMITED WARRANTY AND REMEDIES, AND FOR ANY WARRANTY, CONDITION, REPRESENTATION, OR TERM TO THE EXTENT TO WHICH IT CANNOT OR MAY NOT BE EXCLUDED OR LIMITED BY LAW APPLICABLE TO YOU IN YOUR JURISDICTION, CIRCLE SYSTEMS MAKES NO WARRANTIES, REPRESENTATIONS, OR CONDITIONS, EXPRESS OR IMPLIED, WITH RESPECT TO THE SOFTWARE, MEDIA, OR USER MANUAL, INCLUDING THEIR MERCHANTABILITY, SATISFACTORY QUALITY, NONINFRINGEMENT OF THIRD PARTY RIGHTS, INTEGRATION, OR FITNESS FOR A PARTICULAR PURPOSE. CIRCLE SYSTEMS WILL IN NO EVENT BE LIABLE FOR ANY DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES ARISING FROM THE USE OF OR INABILITY TO USE THE SOFTWARE OR MANUAL, EVEN IF CIRCLE SYSTEMS HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.
Because software is inherently complex and may not be completely free of errors, Circle Systems is not responsible for any costs including, but not limited to, lost profits or revenue, loss of time or use of the software, loss of data, the cost of
recovering software or data, the cost of substitute software, claims by third parties, or similar costs. In no event will the liability of Circle Systems exceed the amount paid for the software.
NOTICE TO U.S. GOVERNMENT END USERS
The software and manual are “Commercial Items,” as that term is defined at 48 C.F.R. 2.101, consisting of Commercial Computer Software and Commercial Computer Software Documentation, as such terms are used in 48 C.F.R. 12.212 or 48 C.F.R. 227.7202, as applicable. Consistent with 48 C.F.R. 12.212 or 48 C.F.R. 227.7202-1 through 227.7202-4, as applicable, the Commercial Computer Software and Commercial Computer Software Documentation are being licensed to U.S. Government end users only as Commercial Items and with only those rights as are granted to all other end users pursuant to the terms and conditions herein. Unpublished-rights reserved under the copyright laws of the United States. Circle Systems, Inc., 1001 Fourth Avenue, Suite 3200, Seattle, WA 98154 USA.
This is the complete and exclusive statement of the agreement between you and Circle Systems. It supersedes any prior agreement or understanding, oral or written, between you and Circle Systems, its agents and employees, with respect to this subject. No Circle Systems distributor, dealer, or agent is authorized to make any modification, extension, or addition to this Agreement and the limited warranty and limitation of liability. The laws of the State of Washington, USA govern this agreement.
Windows XP, Vista, Windows 7, 8 or 10
APPLE Mac / OS-X
Apple Mac OS-X 10.4 (Tiger), 10.5 (Leopard), 10.6 (Snow Leopard), 10.7 (Lion), 10.8 (Mountain Lion – S/T V12 and above), 10.9 (Mavericks – ST V12 and above) and macOS Sierra and High Sierra
Intel or AMD x86-64 processor
Intel or SPARC Processsor
Per gli utenti Stat/Transfer sono disponibili il Manuale dell’Utente e la Quick Start Guide. Entrambi, possono essere scaricati nella versione pdf cliccando negli appositi link.
Quick Start Guide Version 13 – che contiene anche le istruzioni per l’installazioneStat/Transfer User Manual Version 14
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. These were a universal format for PC software data interchange. Multiple page worksheets are supported on input.
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.
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.
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.
DATA DOCUMENTATIO 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.
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.
Stat/Transfer supports all versions through 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, files for Excel 97-2003 and those for Excel 2007-16. 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.
Stat/Transfer reads and writes Gauss’s universal file format in addition to the older Gauss 89 format used for Windows.
Stat/Transfer reads and writes gretl cross-sectional data files.
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 are supported as well as all of the newer numeric types.
Stat/Transfer reads and writes the native internal file format of all versions of LIMDEP for Windows.
Matrices from all versions of Windows, Macintosh, and Unix Matlab are supported. Matlab datasets are supported for versions greater than seven.
Stat/Transfer reads and writes portable files for this data visualization package developed by Silicon Graphics..
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.
Stat/Transfer supports exporting to Mplus for Windows.
Stat/Transfer supports all versions of NLOGIT 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, 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
|OPEN DOCUMENT 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.
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.
Stat/Transfer reads all versions of Paradox and writes Version 7 through 9 files.
All versions of Quattro Pro are supported. Stat/Transfer allows the selection of data from individual pages of a multiple page worksheet.
Stat/Transfer will read and write workspace files for all versions of R.
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.
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.
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. New in version 14, is the ability to write native SAS catalogs for Windows.
Value labels can be read from catalogs, CPORT files, SAS data files, and from transport files.
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 and of being the standard format for the submission of data to the FDA.
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.
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.
SPSS PORTABLE FILE
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. 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.
Stat/Transfer fully supports Statistica Versions 5 and 7 through 10. Value and variable labels are fully supported.
Stat/Transfer reads and writes files that are compatible with all versions of SYSTAT. All features, including subscripted variables, are supported.
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.
© Copyright 2019 Circle Systems, Inc
Stat/Transfer has provided fast, reliable, and convenient data transfer between popular software packages for thousands of users, worldwide.
Stat/Transfer knows about statistical data – it handles missing data, value and variable labels and all of the other details that are necessary to move as much information as is possible from one file format to another.