User Manual

Version 16




















ã Copyright 2022

All Rights Reserved

Circle Systems, Inc.



The Stat/Transfer program is licensed for use on a single computer system or network node.  Use by multiple users on more than one computer is prohibited.  If in doubt, please call and ask about our multi-user licenses.


Stat/Transfer is a trademark of Circle Systems, Inc.


This manual refers to numerous products by their trade names.  In most, if not all, cases these designations are claimed as trademarks or registered trademarks by their respective companies.




Table of Contents







License Agreement
What Stat/Transfer Does
Supported File Types
What's New in Stat/Transfer
Getting Started
Trial Mode Software
Network and Lease Licensing
Read-me File
Demo Files
Web Update
Technical Support
The Stat/Transfer User Interface
Starting Stat/Transfer
Transfer Dialog Box
Selecting the Input File Format
The File Specification Line
Selecting Worksheet Pages
Selecting Tables for Access and ODBC Input
Selecting Members of SAS CPORT and Transport Files
Most Recently Used File Lists
Data Viewer
Variable Selection Indicator
Selecting the Output File Format
Selecting the Output File
Table Names for Access and ODBC Output
Naming Members of SAS Transport Files
Resetting Stat/Transfer
Running the Program
Generating a Stat/Transfer Program
Automatic Logging
Variables Dialog Box
Variable Selection
Value Labels Browser
Output Variable Types
Target Output Variable Types
Automatic Optimization of Target Types
Manually Changing the Types of Output Variables
Automatic Dropping of Constants
Use Doubles Option
Observations Dialog Box
Selecting Cases
Missing Values
Sampling Functions
Options Dialog Box
General Options
User Missing Values
Date/Time Formats – Reading
Date/Time Formats - Writing
Encoding Options
ODBC/Access Options
ASCII/Text Files - Read
ASCII/Text Files - Write
SAS Reading
SAS Writing
JMP Options
R and S-PLUS Options
RATS Options
Output Options (1)
Output Options (2)
User Interface Options
Default Directories
Data Viewer Options
Stat/Transfer Program Generation
Transfer Logging / Statistics
Advanced ODBC Options
Restoring and Saving Options
Advanced ASCII Options
Run Program Dialog Box
About the Run Program Dialog Box
Log Dialog Box
About the Log Dialog Box
The Command Processor
Calling the Command Processor
Batch Transfers with Wildcards
Transfers from the Command Processor
Transfers from the Operating System Prompt
Combining Files
Specifying the File Type
File Format Specification
Special Cases when Specifying Files
Options Set by Parameters
Options for Pages and Tables
Options for Messages
Selecting Cases
Selecting Variables
Changing Output Variable Types
Setting Options with the SET Command
Startup Options File
Available Options
General Options
Optimization Options
User Missing Values Options
Date/Time Formats – Reading
Date/Time Formats - Writing
Encoding Options
ODBC Options
ASCII Options-Reading
ASCII Options-Write
SAS Reading
SAS Writing
Worksheet Options
JMP Options
R and S-PLUS Options
RATS Options
Output Options (1)
Output Options (2)
Advanced ASCII Options
Log Options
SET Options Used Only in Command Processor
Other Available Command Processor Commands
Command Files
ODBC Data Sources
The DBR and DBW Commands
Running Batch Jobs with ODBC
Variable Naming and Limits
Variable Names
Limitations on the Number of Variables
Limitations on Strings with Value Labels
Internal Limitations
Return Transfers to the Original Format
Supported Programs
Input and Output Variable Types
1-2-3 Worksheet Files
ASCII Files - Delimited
ASCII Files - Fixed Format
SCHEMA Files for ASCII Input
dBASE Files and Compatibles
DDI (Data Documentation Initiative) Schemas
Epi Info
Excel Worksheets
FoxPro Files
Gauss Files
GenStat Files
HTML Tables
JMP Files
Matlab Files
Mineset Files
Minitab Worksheets
Mplus Files
ODBC Data Sources
OpenDocument Spreadsheets
Paradox Tables
Quattro Pro Worksheets
RATS Files
SAS Data Files
SAS Value Labels
SAS Transport Files
S-PLUS Files
SPSS Data Files
SPSS Portable Files
Stata Files
Statistica Files