Date:         Thu, 1 Mar 2001 09:57:20 -0500
Reply-To:     "Flechet, Jef" <Jef.Flechet@BASES.COM>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         "Flechet, Jef" <Jef.Flechet@BASES.COM>
Subject:      Re: Exporting DATA to Excel
Content-Type: text/plain; charset="iso-8859-1"

Hi Raynald,

I am simply copying the data. I only tried it by hand to see what the result
was but later on that will be done automatically from the script (by copying
into the clipboard then pasting in Excel). The script further manipulates
the data in Excel, creates graph and so on. Thanks for your reply, I was not
aware that you could simply save the file as an excel file from SPSS. I have
to investigate this!!!!

   Thanks.

 Jef.

                -----Original Message-----
                From:   Raynald Levesque [mailto:rlevesque@VIDEOTRON.CA]
                Sent:   Wednesday, February 28, 2001 8:39 PM
                To:     SPSSX-L@LISTSERV.UGA.EDU
                Subject:        Re: Exporting DATA to Excel

                Hi Jef

                How do you export it?

                Using 10.07 and the following syntax, all decimals (not just
those visible
                in the data editor) are exported to excel:

                SAVE TRANSLATE OUTFILE='D:\data\test.xls'
                  /TYPE=XLS /MAP /REPLACE /FIELDNAMES.

                Raynald Levesque rlevesque@videotron.ca


                -----Original Message-----
                From: SPSSX(r) Discussion
[mailto:SPSSX-L@LISTSERV.UGA.EDU]On Behalf Of
                Flechet, Jef
                Sent: Wednesday, February 28, 2001 5:38 PM
                To: SPSSX-L@LISTSERV.UGA.EDU
                Subject: Exporting DATA to Excel


                Hello Everybody,

                I am trying to export an SPSS dataset into Excel. The data
are displayed
                with 2 decimals in the data editor. When I export to Excel,
the data are
                simply truncated (rounded) at 2 decimals!!! However, if you
take information
                from a Pivot Table and export it to Excel you get the entire
values!!!

                I know that I can change the number of decimals in the
Variable View pane
                but I need the true values!! Does anybody know how to copy
the true value of
                an SPSS dataset into Excel?? I need to repeat this task many
times!!

                  Any ideas??

                  Thanks

                  Jean-Francois