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?
The other answers relate to the GUI, but some people prefer using the syntax editor. If you fall into that category, from the programming perspective, you can do something like:
SAVE TRANSLATE OUTFILE='path\to\file.csv'
/TYPE=CSV
/MAP
/REPLACE
/FIELDNAMES
/CELLS=LABELS.
Notice the last line, /CELLS=LABELS.
-- If you wanted the values instead, you can change it to (surprise!) /CELLS=VALUES.