snurhussein/PSPPConvert.md

Last active October 31, 2021 23:49

Star (16) You must be signed in to star a gist
Fork (3) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/snurhussein/008dbe9858b12235f0d5.js"></script>
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 commented May 5, 2021

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.