Date:         Fri, 27 Dec 2002 14:26:08 -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: Saving files with labels (an alternative)
In-Reply-To:  <JAEFJAPAEBFCDIHJIFKCKENMCKAA.rlevesque@videotron.ca>
Content-type: text/plain; charset=utf-8

Hi

As an alternative method:

1. Open a draft output window

2. List all cases (with value labels) using
SUMMARIZE
  /TABLES=ALL
  /FORMAT=VALIDLIST NOCASENUM TOTAL
  /TITLE='Case Summaries'
  /MISSING=VARIABLE
  /CELLS=COUNT .

3. In the Draft Output: Delete everything except the table of results
4. Use the menu: File> Export> All text

5. Import the txt file into excel

HTH

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
Raynald Levesque
Sent: December 27, 2002 11:27 AM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: Re: Saving files with labels


Hi

Using version 11.5 I am able to select the data in the data editor, copy it and paste it in excel 2000.  The value labels are copied when the labels are visible in the data editor. The values are copied otherwise.

There is a script to create a string variable which contains the value label of an other variable. See "Reverse auto recode 10.SBS" in http://pages.infinit.net/rlevesqu/SampleScripts.htm#Labels
However this is not easy to use when dealing with hundreds of variables.

HTH

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
Marcos Sanches
Sent: December 27, 2002 10:31 AM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: Re: Saving files with labels


        As it seems impossible to save values labels in Excel format, other
alternative would be to create a new string variable which contents are the
labels of the numeric variable. Is there a easy way to create such a string
variable, other than using RECODE? I am saying that because as long as I
know, if I use RECODE, I have to type all the labels, besides, I have over
100 variables with differents labels, than RECODE would be very tiresome.

        With SPSS 9.0 I remember it was possible to copy and paste directly from
SPSS to Excel. In SPSS 11 this is not possible, when I paste in Excel it
pastes only the values...

  Thanks,

  Marcos



-----Original Message-----
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU]On Behalf Of
Peck, Jon
Sent: Friday, December 27, 2002 12:37 PM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: FW: Re: [SPSSX-L] Saving files with labels


        -----Original Message-----
        From: Peck, Jon
        Sent: Fri 12/27/2002 8:36 AM
        To: ??????? ???????
        Cc:
        Subject: RE: Re: [SPSSX-L] Saving files with labels


        With 11.5, you have a choice of saving labels instead of values in
the Save As dialog box when you choose the Excel format.

                -----Original Message-----
                From: ??????? ??????? [mailto:eugen@KCPIK.ORG.UA]
                Sent: Fri 12/27/2002 7:56 AM
                To: SPSSX-L@LISTSERV.UGA.EDU
                Cc:
                Subject: Re: [SPSSX-L] Saving files with labels



                Hello Marcos!
                It is possible to save SPSS file in Excel with
                variables names as a first row in .xcl file.
                But I don't know about the possibility of
                saving variables and value labels.


                Marcos Sanches" <marcos_sanches@gallup.com> ???????/????????
? ????????
                ?????????:
news:000b01c2adae$ae840e80$b454a8c0@gallup.com.br...>
                Helo all,
                >
                >   Is it possible to save a SPSS file in Excel format,
keeping the labels
                of
                > the variables? I mean, I want only the labels, don't need
the values, I
                need
                > the labels in the Excel file. I am using version 11.
                >
                >    Thanks a lot,
                >
                >   Marcos
                >