Date: Mon, 20 Jan 2003 19:35:44 -0500
Reply-To: Raynald Levesque <rlevesque@videotron.ca>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: Raynald Levesque <rlevesque@videotron.ca>
Subject: Re: exporting SPSS 10 to Excel with labels
In-Reply-To: <10B7D57404FD0C4587019E88DACD09171A731B@ex2.asurite.ad.asu.edu>
Content-type: text/plain; charset=iso-8859-1
Hi
You can use the following method to export variable labels to xls:
1. Open a Draft Output window.
2. Use the summarize command to list the whole file. (variable labels and
value labels will be printed).
3. Go to the Draft Output and delete the stuff before the actual table.
4. Using the menu File>Export>All Text.
5. Read the file with Excel.
By curiosity could you tell me (either through the list or by email) what it
is that you want to do in Excel which is easier to do than in SPSS?
Have fun!
Raynald Levesque rlevesque@videotron.ca
Visit my SPSS Pages http://pages.infinit.net/rlevesqu/index.htm
-----Original Message-----
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU]On Behalf Of
Frances Peck
Sent: January 20, 2003 1:03 PM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: exporting SPSS 10 to Excel with labels
First, a caveat - I know this was recently discussed, and I deleted the
messages because (I said) if I am exporting to Excel, it is a file I
imported into SPSS from Excel in the first place... Yes, well, I have a HUGE
census file (.txt) that has an SPSS syntax file with it to write the labels,
so I can get it into SPSS without any problem. However, I want to map some
of these data and do a few things that are more easily done in Excel, and
darned if I can figure out how to get it out of SPSS 10 with the labels. It
is much too large to have to type in v labels in Excel. I am thinking I may
have to install a previous version of SPSS on one of the computers, take the
data in, and then save it back out that way. I know I used to be able to do
this in SPSS 8, and I think, 9.
What was the consensus in those discussions about getting the v labels into
Excel from SPSS 10? Thanks in advance.
Fran Peck
Council of Colleges of Arts and Sciences
Arizona State University
PO Box 873108
Tempe, AZ 85287-3108
Phone: 480-727-6064
FAX: 480-727-6078
Email: fpeck@asu.edu
