ANY-maze Help > The ANY-maze reference > The Data page > Transferring data to specific programs > Transferring data to SigmaStat

Transferring data to SigmaStat

Introduction

SigmaStat is a popular statistical analysis program. Transferring data from ANY-maze to SigmaStat is very simple - just save the data to transfer to a dBase file.

Copy and paste

Copying data and pasting into SigmaStat works perfectly, although you should note that if you copy the entire ANY-maze spreadsheet (i.e. without selecting anything) then when you paste it into SigmaStat, the column titles will appear as the first row of data. You can avoid this by either deleting this row, or by selecting all the rows in the Data page spreadsheet before copying them - see Selecting cells, columns or rows for details.

In any case, if you want to transfer the entire spreadsheet to SigmaStat then the better option is to save it as a dBase file, as this way the columns will be titled for you.

Saving data to a file

SigmaStat can read data from CSV, tab-separated and dBase files. However, in the first two formats it doesn't take the first row as being column titles (i.e. variable names) and so the column titles appear as the first row of data.

The best format to use is dBase - this works perfectly.

How to open a dBase file in SigmaStat

These instructions are for SigmaStat for Windows version 3.00.0

 1.Click the File menu. 
 2.Select Open; the Open file window will appear.  
 3.At the bottom of the window is a list titled Files of Type. Select 'dBase'. 
 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. 
 6.The Select file type window will open - ensure 'dBase III or higher' is selected and click OK. 

In fact, you can also use the Import command from the File menu. This is almost identical to using the Open command (as described above), except that you can choose to import just a portion of the dBase file rather than all of it.

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 T0891