Export Options

Adjust the options on the bottom half of the Export dialog according to your intended uses for the exported files.

Output Variables as

Table variables may be coded in the export data file as numbers or as the label text, with or without quotes. The code equivalents will appear in the export dictionary file. Choose the coding method that will be the most compatible with your target software package. The Numeric Representation option is disabled for Case Listing matrices.

Numeric Representation

The groupings of each variable will be recoded to numbers, starting with zero, in the order in which the groupings are listed in the variable's definition. For example, if the variable were "Sex" with the values in the order "Male and female”, "Male”, and "Female”, then the recoding would be: 0 = "Male and female", 1 = "Male”, and 2 = "Female”. If the order of the variable groupings in the database dictionary were changed to "Male", "Female”, and "Male and female”, then the recoding would be: 0 = "Male”, 1 = "Female”, and 2 = "Male and female”.

Labels Enclosed in Quotes

The labels of the variable groupings and values will be the same as the text shown on your matrix, with double quotes surrounding them. For a Case Listing matrix, Unformatted labels will not appear in quotes in the data file.

Labels without Quotes

The labels of the variable groupings and values will be the same as the text shown on your matrix, without double quotes surrounding them, unless you have selected the Enclose Fields Containing Delimiter in Quotes option.

Line Delimiter

Line breaks in the data file are significant; depending on the type of matrix, they may indicate the end of a row of data, or they may separate different sets of statistics. DOS/Windows and UNIX use different character sequences to represent a line break. Choose the option that matches the platform on which you will be using your exported data file.

DOS/Windows (CR/LF)

DOS/Windows expects both a carriage return (CR) and a line feed (LF).

UNIX (LF)

UNIX expects only a line feed (LF).

Field Delimiter

Export data files are in a delimited format; that is, each data item (field) is separated by a certain character. Select the character to be used as the field delimiter from this list. Tab, space, comma, and semi-colon are allowed. Variables that are output as labels will likely include spaces and commas, and may include semicolons. Therefore, when choosing the character to be used as the field delimiter, follow these guidelines:

Missing Character

When a statistic cannot be calculated in an analysis, the cell of the matrix is marked with a footnote. No number appears in the cell. Choose a missing character to represent the empty cell.

Space

A space is placed wherever the value of a missing cell would appear. If you have chosen a space as the field delimiter, you may not want to choose a space as the missing character.

Period

A period is placed wherever the value of a missing cell would appear. You should consider if your software package will handle a period as a numeric missing rather than as text.

Enclose Fields Containing Delimiter in Quotes

This option will place double quotes around any field value which contains the field delimiter character. For example, if you selected the comma for your field delimiter, the label All Sites will not appear with quotes in your data file, but "Uterus, NOS" will because it contains a comma.

Remove all Thousands Separators (Commas)

This option removes all commas acting as thousands separators from the calculated statistics. You may wish to select this option, even if you are using a field delimiter other than the comma. The absence of the thousands separators may be easier for your software package to handle.

Remove Flags (Footnote Characters)

When checked, this option removes all footnote characters from the data file. Footnote characters can indicate such things as a positive significance test or the reason for an empty cell. When deciding whether to select this option, you should consider if the footnote information will be helpful in your analysis of the data file. This option is disabled when working with a Case Listing matrix.

Output Variable Names Before Data

This option lists the variable names before the data in the export dictionary file. The variable names are always in quotes. This can be useful when you import/copy data into another software package that uses field names.

Preserve Matrix Columns and Rename Fields

Checking this option displays the Edit Export Column Names dialog where you can makes changes to the Edit Variable Names.

Defaults

Click this button if you make changes to the export options and wish to return to the default settings.

Set Default

Once you have edited the export options, you may set the current settings as the defaults by clicking this button. This may be useful if you use certain export settings regularly. These options will now be the defaults any time you open a session or matrix in SEER*Stat, and will be applied whenever you click the Defaults button.