Date:         Mon, 20 Jan 2003 19:23:47 -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 .sav-file to excel
In-Reply-To:  <DAV564kd4nIc7JhtR9v0001c82b@hotmail.com>
Content-type: text/plain; charset=iso-8859-1

Hi

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
  /CELLS=labels .

The keyword CELLS =value if you want to export values and CELLS =labels if
you want to export labels.

Regards

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
Roland van der Laak
Sent: January 20, 2003 5:01 PM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: exporting .sav-file to excel


Hi Listers,

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

Just wondering...

Kind regards,
Roland