ANY-maze Help > The ANY-maze reference > The Data page > Transferring data to specific programs > Transferring data to Systat
Transferring data to Systat
Introduction
Systat is a popular statistical analysis program. You can transfer data from ANY-maze to Systat either by copying and pasting, or by saving the data in a dBase file (recommended).
Copy and paste
Copying and pasting data into Systat works correctly, but you need to be a little careful.
If you copy the entire ANY-maze Data page spreadsheet (i.e. without selecting anything), then when you paste it into Systat, the column titles will appear as the first row. As Systat uses the contents of the first row to determine what type of data is in each column, it will think everything is text (the column titles being textual) and will create its variables accordingly.
Fortunately this is easy to overcome - just select the entire table before copying it. When ANY-maze copies a selection, it doesn't include the column titles in the copied data.
Saving data to a dBase file
The easiest way to transfer data into Systat is to save it as a dBase file and then open the file in Systat. There's one downside to this - if your data includes any dates, then according to the Systat 10.2 help file, they'll be converted to numbers (quote from the Systat help):
Date fields are converted to numeric values. For example, if your dBase file contained a value for November 2, 1987, it would be stored as 19871102. Importing converts this to 0.19871102E + 8.
Incidentally, Systat doesn't import ANY-maze CSV or tab-separated files correctly, as it appears to treat spaces as separators - therefore the only one of ANY-maze's formats which it does correctly support is dBase.
How to open a dBase file in Systat
These instructions are for Systat version 10.2
| 1. | Click the File menu. |
| 2. | Select Open; the Open file window will appear. |
| 3. | Towards the bottom of the window is a list titled Files of Type. Select 'dBase files'. |
| 4. | In the main part of the window, navigate to the file you saved from within ANY-maze and select it. |
| 5. | Click the Open button. |
See also:
| • | Selecting cells, columns or rows |
| • | Copying and saving data |
| • | The save data window |
© Copyright 2003-2026 Stoelting Co. All rights reserved
ANY-maze help topic T0892