Saving data files in external formats
- Make the Data Editor the active window (click anywhere in the window to make it active).
- From the menus choose:
- Select a file type from the drop-down list.
- Enter a filename for the new data file.
To write variable names to the first row of a spreadsheet or tab-delimited data file:
- Click Write variable names to spreadsheet in the Save Data As dialog box.
To save value labels instead of data values in Excel files:
- 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):
- 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.