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?
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".