Search code examples
spss

In SPSS, is it possible to export a dataset file to .CSV with the value names instead of the value numbers?


In my SPSS file, I have a variable called "X". It has four values: 1="dog", 2="cat", 3="hyena", 4="parrot".

If I export my data to a .CSV file, here's what it looks like:

X
1
2
3
4

I want the exported .CSV to look like this:

X
dog
cat
hyena
parrot

is this possible?


Solution

  • Yes, it is possible (at least in SPSS 20). In File Menu, choose, "Save As...", in the drop down menu in the dialog box that opens choose "Save as type: 'Comma delimited (*.csv)')", and underneath that select "Save value labels where defined instead of data values" (or hit "Alt-a") and choose "Save".