ODBCOPTIONS subcommand (SAVE TRANSLATE command)

You can use ODBCOPTIONS to export defined value labels instead of data values.

ODBCOPTIONS VALLABELS=NONE | varlist

• The default setting is VALLABELS=NONE.
• If a variable list is specified, the value label text is exported instead of the data values.
• For values that do not have a defined value label, the data value is exported as a text string.
• This option is ignored for date format variables and variables that do not have any defined value labels.
• This option is only available for creating a new table, replacing an existing table, and adding new fields to an existing table. You cannot use this option for appending rows to an existing table or modifying the content of existing fields in a table.