Options Dialog Box




General Options

Ask Permission before Overwriting Files

The option Ask Permission Before Overwriting Files is on by default.  If a file, or a database table exists, you will be prompted for permission before it is overwritten.


If you wish to suppress these warning messages, click on the box to remove the check mark.


Write New, Numeric Variable Names (Vn)

When you go from one format to another, by default Stat/Transfer will create legal variable names for you, based as much as possible on the original names.  In particular, when you transfer from systems such as Paradox or JMP, which allow long variable names with embedded spaces, to older systems which restricts variable names to eight characters, by default Stat/Transfer will truncate for you.  However, these truncated names often have little resemblance to the names you started with.  Stat/Transfer will use the variable names as variable labels, so that your original names are available.


If you check the option Write new, numeric variable names. (Vn), instead of the default variable names, Stat/Transfer will create new variable names of the form V1...VN.  This is chiefly useful when dealing with truncated names.  If your output system supports variable labels, it is sometimes better to check this option and have Stat/Transfer simply create numeric names for your variables.  You can then use the variable labels for the description.


Because this option is likely to be useful only in special circumstances, it reverts to the default between sessions.


Preserve value label tags and sets

Many software packages allow users to assign the same set of value labels to more than one variable. (In SAS, the term for value labels is "user-defined format").  For example, a survey with a list of questions with "Yes" and "No" responses could use the same set of value labels for the variables associated with each of these questions.


If the option Preserve value label tags and sets is checked, the mapping of value label sets to multiple variables will be preserved on output.  If  tags are used in the input file to identify value labels sets, these will be preserved.  Otherwise, tags will be constructed by Stat/Transfer (LABA-LABZ and so on).


If this option is not checked, each labeled variable will have a unique value label set and the tag used to identify the set will be constructed from the name of the variable.


This option is off by default.




Seed for Sampling Functions

By default, the sampling functions in WHERE expressions will generate a starting seed randomly, based on the clock time.  This means that each time you run a transfer on a given file you will select a different sample.  If, in contrast, you need a reproducible sample, you can enter a seed for the random sampling process.  The seed should  be a positive  integer in the range of one through 2,147,483,646.

Variable name case conversions

Stat/Transfer always follows the variable-naming rules of the output file type and will convert input names so that they will conform to those rules.  Some older packages require upper case variable names.  Other more modern packages allow mixed case variable names.  Some packages, notably Stata, S-PLUS and R allow mixed case variable names, but are case sensitive.  In these case-sensitive systems, if Stat/Transfer were to move data from an upper-case system and do no case-conversion, the user of the data set would need to always hold down the shift key when typing in variable names.


Stat/Transfer allows you to specify your case conversion preferences for case-insensitive packages as well as case-sensitive packages.


The available options are given in the drop-down menus for both case-sensitive and case-insensitive programs and are:


  •     Convert to lower

  •     Preserve if mixed case

  •     Preserve always

  •     Convert to upper


The default for case-insensitive programs is "Preserve always".


The default for case-sensitive programs is "Preserve if mixed case".  This choice is designed to handle mixed case variable names such as "FamilyIncome".  If both upper and lower case letter are found in a variable name, it will be left untouched.  Otherwise it will be converted to lower case. 


Formats which are considered case-sensitive on output are: Stata, S-PLUS, R, and Matlab. 


Formats that require upper-case variable names are: SAS version six, SAS XPORT, SPSS Portable, SYSTAT, Epi Info, and older xBASE versions such as Clipper and dBASE II.


All other formats are case-insensitive.