Comma-Delimited (CSV) Text Files (SAVE TRANSLATE command)

Variables in the active dataset become columns, and cases become rows in the text file.

  • If you specify FIELDNAMES, variable names are written in 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.
  • Use the TEXTOPTIONS subcommand to override the default delimiter, qualifier, decimal indicator, or data value formatting. See the topic TEXTOPTIONS Subcommand (SAVE TRANSLATE command) for more information.
  • System-missing values are translated to a blank space in text files.