Spreadsheets (SAVE TRANSLATE command)
Variables in the active dataset become columns, and cases become rows in the spreadsheet file.
- If you specify
FIELDNAMES
, variable names become the first row. - To save value labels instead of data values, use
the
CELLS
subcommand. See the topic CELLS Subcommand (SAVE TRANSLATE command) for more information. - System-missing values are translated to #NULL! in Excel files.
IBM® SPSS® Statistics formats are translated as follows:
IBM SPSS Statistics | 1-2-3/Symphony | Excel |
---|---|---|
Number | Fixed | 0.00;#,##0.00;... |
COMMA | Comma | 0.00;#,##0.00;... |
DOLLAR | Currency | $#,##0_);... |
DATE | Date | d-mmm-yy |
TIME | Time | hh:mm:ss |
String | Label | General |