User Guide

20
Chapter 3
Optionally, you can:
 Read variable names from the first row for spreadsheet and tab-delimited files.
 Specify a range of cells to read for spreadsheet files.
 Specify a sheet within an Excel file to read (Excel 5 or later).
Data File Typ
es
SPSS. Opens d
ata files saved in SPSS format, including SPSS for Windows,
Macintosh, UNIX, and also the DOS product SPSS/PC+.
SPSS/PC+. Opens SPSS/PC+ data files.
SYSTAT. Ope
ns SYSTAT data files.
SPSS Portable. Opens data files saved in SPSS portable format. Saving a file in
portable format takes considerably longer than saving the file in SPSS format.
Excel. Open
s Excel files.
Lotus 1-2-3. Opens data files saved in 1-2-3 format for release 3.0, 2.0, or 1A of Lotus.
SYLK. Opens data files saved in SYLK (symbolic link) format, a format used by
some spread
sheet applications.
dBASE. Opens dBASE-format files for either dBASE IV, dBASE III or III PLUS,
or dBASE II. Each case is a record. Variable and value labels and missing-value
specificat
ions are lost when you save a file in this format.
SAS Long File Name. SAS version 7-9 for Windows, long extension.
SAS Short File Name. SAS version 7-9 for Windows, short extension.
SAS v6 for Wi
ndows.
SAS version 6.08 for Windows and OS2.
SAS v6 for UNIX. SAS version 6 for UNIX (Sun, HP, IBM).
SAS Transport. SAS transport file.
Text. ASCII
text file.