Keeping Value Labels when exporting into excel

[Alina Sheyman-3]

I'm trying to export data out of SPSS into tab delimited format, but would
like to keep value labels instead of the original values (codes). Does
anyone know if there's a way to do this?

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Mahbub Khandoker]

Hi Alina,

You can carry out this through save as then select save as type as
excel\tab delimited then check "Save value labels where define instead
of data value".
The following syntax will do the same,

SAVE TRANSLATE OUTFILE='C:\Destination file.xls'
  /TYPE=TAB
  /MAP
  /REPLACE
  /FIELDNAMES
  /CELLS=LABELS.

Cheers!

Mahbub Khandoker
Decision Support
Tel: [phone] Ex 6534

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Alina Sheyman
Sent: Monday, June 02, 2008 12:27 PM
To: [hidden email]
Subject: Keeping Value Labels when exporting into excel

I'm trying to export data out of SPSS into tab delimited format, but
would
like to keep value labels instead of the original values (codes). Does
anyone know if there's a way to do this?

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

______________________________________________________________________
This email has been scanned by the CAMH Email Security System.
______________________________________________________________________



______________________________________________________________________
This email has been scanned by the CAMH Email Security System.
______________________________________________________________________

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Joel_Rivard]

Hi Alina,

Instructions for SPSS 15:

Click on File / Save as..
Change the "Save as Type" to a ".dat" file.
You'll notice that below the "Save as Type", there is a checkbox for "save value labels where defined instead of data values".  Make sure that this is checked. Give it a filename and save the file.

Joel


Joël Rivard
Data Technician
Maps, Data & Government Information Centre
Carleton University Library
[phone] ext.1685
[hidden email]

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Alina Sheyman
Sent: Monday, June 02, 2008 12:27 PM
To: [hidden email]
Subject: Keeping Value Labels when exporting into excel

I'm trying to export data out of SPSS into tab delimited format, but would
like to keep value labels instead of the original values (codes). Does
anyone know if there's a way to do this?

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD