TYPE Subcommand (SAVE TRANSLATE command)

TYPE indicates the format of the resulting file.

  • TYPE can be omitted for spreadsheet files if the file extension that is named on OUTFILE is the default for the type of file that you are saving.
  • TYPE with the keyword DB2, DB3, or DB4 is required for translating to dBASE files.
  • TYPE takes precedence over the file extension.

ODBC. Database accessed via ODBC. See the topic ODBC Database Sources (SAVE TRANSLATE command) for more information.

XLS. Excel. See the topic Spreadsheets (SAVE TRANSLATE command) for more information.

CSV. Comma-delimited text data files. See the topic Comma-Delimited (CSV) Text Files (SAVE TRANSLATE command) for more information.

TAB. Tab-delimited text data files. See the topic Tab-Delimited Text Files (SAVE TRANSLATE command) for more information.

SAS. SAS data files and SAS transport files. See the topic SAS Files (SAVE TRANSLATE command) for more information.

STATA. Stata data files. See the topic Stata Files (SAVE TRANSLATE command) for more information.

DB2. dBASE II. See the topic dBASE (SAVE TRANSLATE command) for more information.

DB3. dBASE III or dBASE III PLUS. See the topic dBASE (SAVE TRANSLATE command) for more information.

DB4. dBASE IV. See the topic dBASE (SAVE TRANSLATE command) for more information.

WK1. 1-2-3 Release 2.0. See the topic Spreadsheets (SAVE TRANSLATE command) for more information.

WKS. 1-2-3 Release 1.4. See the topic Spreadsheets (SAVE TRANSLATE command) for more information.

SYM. Symphony releases. See the topic Spreadsheets (SAVE TRANSLATE command) for more information.

SLK. Multiplan (symbolic format). See the topic Spreadsheets (SAVE TRANSLATE command) for more information.

PC. SPSS/PC+ system files. This format is available only on Windows operating systems. See the topic SPSS/PC+ System Files (SAVE TRANSLATE command) for more information.

Example 

SAVE TRANSLATE OUTFILE='PROJECT.XLS' /TYPE=XLS (/VERSION=8).
  • SAVE TRANSLATE translates the active dataset into the Excel workbook file named PROJECT.XLS.