Date: Mon, 20 Jan 2003 19:23:47 -0500
Reply-To: Raynald Levesque <firstname.lastname@example.org>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: Raynald Levesque <email@example.com>
Subject: Re: exporting .sav-file to excel
Content-type: text/plain; charset=iso-8859-1
I am not aware of reasons why one should go through a *.dbf file to end up
with an *.xls file.
You say:"not printing value labels but values"
Note that in 11.5 (and maybe in 11 I do not remember), you can save value
labels in SPSS using:
SAVE TRANSLATE OUTFILE='C:\Temp\test eee data.xls'
/TYPE=XLS /VERSION=8 /MAP /REPLACE /FIELDNAMES
The keyword CELLS =value if you want to export values and CELLS =labels if
you want to export labels.
Raynald Levesque firstname.lastname@example.org
Visit my SPSS Pages http://pages.infinit.net/rlevesqu/index.htm
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU]On Behalf Of
Roland van der Laak
Sent: January 20, 2003 5:01 PM
Subject: exporting .sav-file to excel
I'm wondering if there are any problems one could encounter when from SPSS
you save your initial .sav-file as an .xls (excel)-file. I know of the
restriction of 256 variables, not printing value labels but values, and the
fact that user missing values are printed differently in excel, but are
there ANY other reasons one should not save the .sav-file as .xls ? One of
my colleagues argues one should always first save the .sav-file as a
.dbf-file and then import it into excel, but I save as .xls from SPSS all of
the times and didn''t encounter any problems yet...