Saving data files in external formats

  1. Make the Data Editor the active window (click anywhere in the window to make it active).
  2. From the menus choose:

    File > Save As...

  3. Select a file type from the drop-down list.
  4. Enter a file name for the new data file.

Options

Depending on the file type, additional options are available.

Encoding
Available for SAS files and text data formats: tab-delimited, comma-delimited, and fixed ASCII text.
Write variable names to file
Available for Excel, tab-delimited, comma-delimited, 1-2-3, and SYLK. For Excel 97 and later versions, you can write either variable names or labels. For variables without defined variable labels, the variable name is used.
Sheet name
For Excel 2007 and later versions, you can specify a sheet name. You can also append a sheet to an existing file.
Save value labels to a .sas file
SAS 6 and later versions.

For information on exporting data to database tables, see Exporting to a Database.