VERSION Subcommand (SAVE TRANSLATE command)

VERSION specifies the file version for multiversion applications. For example, this subcommand is necessary to differentiate between different versions of Excel.

  • VERSION is required for all applications listed below, except Excel.
  • If VERSION is not specified with TYPE=XLS, the Excel file is saved in version 2.1 format.
Table 1. Version numbers and applications
Version Application
1 Symphony Release 1.0
2 Excel 2.1, Symphony Release 2.0, dBASE II
3 dBASE III or dBASE III PLUS
4 dBASE IV
5 Excel 95 Workbook, Stata 4–5
6 SAS v6, Stata 6
7 SAS v7–8, Stata 7
8 Excel 97–2003 Workbook, Stata 8
9 SAS 9, Stata 9
10 Stata 10
11 Stata 11
12 Excel 2007 Workbook, Stata 12
13 Stata 13
14 Stata 14
X SAS transport file

Example

SAVE TRANSLATE OUTFILE='STAFF.XLS' /TYPE=XLS /VERSION=8.
  • SAVE TRANSLATE creates an Excel workbook file in the version 97 format.