Skip to content

Instantly share code, notes, and snippets.

@snurhussein

snurhussein/PSPPConvert.md

Last active October 31, 2021 23:49
Show Gist options
  • Star 16 You must be signed in to star a gist
  • Fork 3 You must be signed in to fork a gist
  • Save snurhussein/008dbe9858b12235f0d5 to your computer and use it in GitHub Desktop.
Save snurhussein/008dbe9858b12235f0d5 to your computer and use it in GitHub Desktop.
Download ZIP
Using PSPP to convert sav files to csv
Raw
PSPPConvert.md

#Converting SPSS files to csv with PSPP#

Install and open PSPP Use the File menu to open your file (it probably has a .sav extension) Go to File>New>Syntax to open PSPP's command line window

Enter:

SAVE TRANSLATE
  /OUTFILE="path/newcsvfile.csv"  //location for your new file
  /TYPE=CSV
  /FIELDNAMES       //optional command to insert fieldnames in the top row
  /CELLS=LABELS.     //optional command specifying to export "labels" from the SPSS codebook (e.g. excellent). Change "labels" to "values" for value reponses (e.g. "5" for "excellent")

RUN

@RobotimusPrimed
Copy link

Hello
I used your code (TY) to convert the NSSE files from sav to csv, however, now there are multiple problems and I am not sure if I can trust the conversion. Several columns that were numbers came in as custom columns and changed to dates. Other columns came in with a number, with the value label, and both, and some, the digit in sav file was converted to a word in the csv such as 1, one. Any suggestions?
Thank you.

@xlxs4
Copy link

xlxs4 commented May 11, 2021

Sorry to jump in on this, but you can follow something like this, and export to .csv from within Excel (and I would guess OpenOffice, etc.)

@snurhussein
Copy link
Author

Thanks @xlxs4 and sorry @RobotimusPrimed. I really have no idea what could be causing this.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment