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 filename for the new data file.

To write variable names to the first row of a spreadsheet or tab-delimited data file:

  1. Click Write variable names to spreadsheet in the Save Data As dialog box.

To save value labels instead of data values in Excel files:

  1. Click Save value labels where defined instead of data values in the Save Data As dialog box.

To save value labels to a SAS syntax file (active only when a SAS file type is selected):

  1. Click Save value labels into a .sas file in the Save Data As dialog box.

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