FoxPro Files
Previous Topic  Next Topic 

Stat/Transfer will read and write FoxPro files.


Standard extension:  dbf


Reading FoxPro Files

FoxPro files can have indices for key fields, which are stored in separate files.  Stat/Transfer ignores these indices, and treats all files sequentially.


On input, FoxPro numeric data and character variables are converted in a straightforward manner.  Logical variables are converted to numbers ('True' becomes '1', 'False' becomes '0').  Memo Fields cannot be converted and will not appear on the Variable Selection dialog box.  Deleted records are not transferred.


Writing Fox Pro Files

Users should be aware that FoxPro files are limited to 128 variables.


FoxPro stores numeric data in fixed length character format.  It is thus not very suitable for numbers which vary widely in magnitude, or which are either very large or very small.


When Stat/Transfer is transferring data from a system in which the width and number of decimal places are known, it uses that information to set the format of each field in the output FoxPro files.  For systems, such as SYSTAT, in which this information is not recorded in the file, Stat/Transfer uses sets the formats based on the target type of the variable.


Missing Data

FoxPro does not directly support missing values.  On input to Stat/Transfer, blanks in a FoxPro file are interpreted as missing values.  If a data set is being transferred to an FoxPro file format, missing values in the input files are set to blank in the FoxPro file.  Blanks are interpreted as zero by FoxPro.  Many other programs, including Stat/Transfer, interpret these blanks as missing.


Output Variable Types

The output variable type that results from each target variable type is given in the following table:



Target Type

Output Type


byte

Number (width 4; 0 decimal places)


int

Number (width 6; 0 decimal places)


long

Number (width 11; 0 decimal places)


float

double

Float (width 16)



string

Character


date

Date


time

date/time

Character (written using ASCII format options currently in effect)