Writing value labels instead of values to XL

[Bauer, Craig]

Hi all

I have a data set where each record represents data for one person.  I
have a variable in this file called Q1, which represents the gender for
that individual.  The values are 1 for Male, and 2 for Female.
Naturally, the data in this variable contains 1's and 2's, and the value
labels are Male and Female, respectively.

What I am being asked to do is save out a file to Excel that contains
the labels, not the values.  So instead of 1's and 2's, they want to see
the text strings "Male" and "Female" in the excel file

We've done that in the past by using the menu system on SPSS for the PC
to display value labels instead of values on the main data sheet,
highlight all, and copy/paste to Excel.  

I need to be able to do this operation for very large files, and do it
automatically overnight.  As a result, I'm looking for syntax to save
the data as an Excel file (or a delimited text file, such as .csv or
tab-delimited) where it writes out the label, rather than the actual
value.

I have access to SPSS v13, v15, and v11.x for a Linux server

Anyone know how to do this?

Thanks!

Craig

[Bauer, Craig]

Hi again

Never mind, got it, apologies for the false alarm - one of my colleagues
found it under the "save translate" command.

Thanks

Craig

> _____________________________________________
> From:         Bauer, Craig  
> Sent: Tuesday, April 17, 2007 5:23 PM
> To:   'SPSSX(r) Discussion'
> Subject:      Writing value labels instead of values to XL
>
>
> Hi all
>
> I have a data set where each record represents data for one person.  I
> have a variable in this file called Q1, which represents the gender
> for that individual.  The values are 1 for Male, and 2 for Female.
> Naturally, the data in this variable contains 1's and 2's, and the
> value labels are Male and Female, respectively.
>
> What I am being asked to do is save out a file to Excel that contains
> the labels, not the values.  So instead of 1's and 2's, they want to
> see the text strings "Male" and "Female" in the excel file
>
> We've done that in the past by using the menu system on SPSS for the
> PC to display value labels instead of values on the main data sheet,
> highlight all, and copy/paste to Excel.  
>
> I need to be able to do this operation for very large files, and do it
> automatically overnight.  As a result, I'm looking for syntax to save
> the data as an Excel file (or a delimited text file, such as .csv or
> tab-delimited) where it writes out the label, rather than the actual
> value.
>
> I have access to SPSS v13, v15, and v11.x for a Linux server
>
> Anyone know how to do this?
>
> Thanks!
>
> Craig
>
>

[Beadle, ViAnn]

It also exists as well as in the Save dialog from the File menu for the syntax adverse.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Bauer, Craig
Sent: Tuesday, April 17, 2007 4:38 PM
To: [hidden email]
Subject: Re: Writing value labels instead of values to XL

Hi again

Never mind, got it, apologies for the false alarm - one of my colleagues
found it under the "save translate" command.

Thanks

Craig

> _____________________________________________
> From:         Bauer, Craig
> Sent: Tuesday, April 17, 2007 5:23 PM
> To:   'SPSSX(r) Discussion'
> Subject:      Writing value labels instead of values to XL
>
>
> Hi all
>
> I have a data set where each record represents data for one person.  I
> have a variable in this file called Q1, which represents the gender
> for that individual.  The values are 1 for Male, and 2 for Female.
> Naturally, the data in this variable contains 1's and 2's, and the
> value labels are Male and Female, respectively.
>
> What I am being asked to do is save out a file to Excel that contains
> the labels, not the values.  So instead of 1's and 2's, they want to
> see the text strings "Male" and "Female" in the excel file
>
> We've done that in the past by using the menu system on SPSS for the
> PC to display value labels instead of values on the main data sheet,
> highlight all, and copy/paste to Excel.
>
> I need to be able to do this operation for very large files, and do it
> automatically overnight.  As a result, I'm looking for syntax to save
> the data as an Excel file (or a delimited text file, such as .csv or
> tab-delimited) where it writes out the label, rather than the actual
> value.
>
> I have access to SPSS v13, v15, and v11.x for a Linux server
>
> Anyone know how to do this?
>
> Thanks!
>
> Craig
>
>