SPSS TO EXCEL copying variable names

[ig]

I am trying to copy the value labels to Excel but it cuts off the value labels field at just one item. Do you know how I can import all the value labels (as well as the codes) for each and every variable?

[Vik Rubenfeld]

Try control-click (on a Mac - it's probably command-click, alt-click, etc. on a PC) on the table to be copied. Select "Export..." on the pop-up menu. A dialog box will pop up. Select "Excel" from the type menu.

[John F Hall]

Are you sure you are not confusing variable names and variable labels?

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of ig
Sent: 07 November 2012 18:01
To: [hidden email]
Subject: SPSS TO EXCEL copying variable names

I am trying to copy the value labels to Excel but it cuts off the value
labels field at just one item. Do you know how I can import all the value
labels (as well as the codes) for each and every variable?




--
View this message in context:
http://spssx-discussion.1045642.n5.nabble.com/SPSS-TO-EXCEL-copying-variable
-names-tp5716088.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command SIGNOFF SPSSX-L For a list of
commands to manage subscriptions, send the command INFO REFCARD

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[David Marso]

This is not the abomination Twitter.  Do not Tweet!
You are not limited to 128 bytes to communicate your needs.
Take a few minutes to describe how you wish to have your Excel sheet appear .
What are you currently doing when attempting to achieve this task.
My ESPss (TM) and InterneTelepathy (TM) suggest you study the
DISPLAY DICTIONARY command.
--

ig wrote

I am trying to copy the value labels to Excel but it cuts off the value labels field at just one item. Do you know how I can import all the value labels (as well as the codes) for each and every variable?

[GauravSrivastava]

Please use display data file information to export value and variable labels of you data file.
file --> display data file information --> current file or external file

Hope this is what you are looking for!!

Regards,
Gaurav

[ig]

I am trying to export the values from SPSS to a format that is reusable with Excel.

Example:
NAME   LABEL                 VALUES
y003      Autonomy Index    {-2, Obedience/Religious Faith}...

In SPSS, I have to click on “{-2, Obedience/Religious Faith}...” to see the rest of the values available for the given label.
When I copy the values from SPSS to Excel, I only have “{-2, Obedience/Religious Faith}...”
BUT the real value list also includes all of the following items:
   value Y003:
      -2 = 'Obedience/Religious Faith'  
      -1 = '-1'  
      0 = '0'  
      1 = '1'  
      2 = 'Determination, perseverance/Independence'

THANKS!!

[David Marso]

Both Gaurav (Menu) and I (Syntax) have posted the solution(s).
--

ig wrote

I am trying to export the values from SPSS to a format that is reusable with Excel.

Example:
NAME   LABEL                 VALUES
y003      Autonomy Index    {-2, Obedience/Religious Faith}...

In SPSS, I have to click on “{-2, Obedience/Religious Faith}...” to see the rest of the values available for the given label.
When I copy the values from SPSS to Excel, I only have “{-2, Obedience/Religious Faith}...”
BUT the real value list also includes all of the following items:
   value Y003:
      -2 = 'Obedience/Religious Faith'  
      -1 = '-1'  
      0 = '0'  
      1 = '1'  
      2 = 'Determination, perseverance/Independence'

THANKS!!

[ig]

YES, the display data file information gives me the whole variable views. Thank you for sharing this information.