Value Labels
Locked
 
|
Hello All,
Is there away to delete the values labels for all variables without accessing the variable view and deleting the labels one at a time? Thanks, Jamie -- James Algina Professor Research and Evaluation Methodology 119D Norman Hall P.O. Box 117047 University of Florida Gainesville, FL 32611 ===================== 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 |
|
I thought about, but did not try, something
like
val lab v1 to vn (lo thru hi)
'' .
It works with missing values using (), but not with
val lab.
Here's something I just tried on a real data
set.
You have to go into variable view, I'm afraid. <IMG src="file://C:\DOCUME~1\Owner\LOCALS~1\Temp\msohtml1\01\clip_image002.jpg" width=623 height=276 v:shapes="_x0000_i1025"> <IMG src="file://C:\DOCUME~1\Owner\LOCALS~1\Temp\msohtml1\01\clip_image004.jpg" width=623 height=276 v:shapes="_x0000_i1026"> Tried deleting whole column, but nothing happened, so highlight the cell with None <IMG src="file://C:\DOCUME~1\Owner\LOCALS~1\Temp\msohtml1\01\clip_image006.jpg" width=623 height=276 v:shapes="_x0000_i1027"> ctrl+c to copy cell then drag to all cells in column: <IMG src="file://C:\DOCUME~1\Owner\LOCALS~1\Temp\msohtml1\01\clip_image008.jpg" width=623 height=276 v:shapes="_x0000_i1028"> ctrl+v to paste to all cells in column <IMG src="file://C:\DOCUME~1\Owner\LOCALS~1\Temp\msohtml1\01\clip_image010.jpg" width=623 height=276 v:shapes="_x0000_i1029"> et voilà! That was fun!
Does this help?
John Hall http://surveyresearch.weebly.com
|
|
In reply to this post by James Algina
Dear James,
After some experimenting, the following syntax seems to work (v17): value labels all . HTH, Ruben van den Berg Methodologist TNS NIPO P: +31 20 522 5738 > Date: Mon, 17 May 2010 22:48:12 -0400 > From: [hidden email] > Subject: Value Labels > To: [hidden email] > > Hello All, > > Is there away to delete the values labels for all variables without > accessing the variable view and deleting the labels one at a time? > > Thanks, > > Jamie > > -- > James Algina > Professor > Research and Evaluation Methodology > 119D Norman Hall > P.O. Box 117047 > University of Florida > Gainesville, FL 32611 > > ===================== > 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 Express yourself instantly with MSN Messenger! MSN Messenger |
|
|
In reply to this post by James Algina
VALUE LABELS ALL. From: John F Hall [[hidden email]] I thought about, but did not try, something
like
val lab v1 to vn (lo thru hi)
'' .
It works with missing values using (), but not with
val lab.
Here's something I just tried on a real data
set.
You have to go into variable view, I'm afraid. <IMG src="file://C:\DOCUME~1\Owner\LOCALS~1\Temp\msohtml1\01\clip_image002.jpg" width=623 height=276 v:shapes="_x0000_i1025"> <IMG src="file://C:\DOCUME~1\Owner\LOCALS~1\Temp\msohtml1\01\clip_image004.jpg" width=623 height=276 v:shapes="_x0000_i1026"> Tried deleting whole column, but nothing happened, so highlight the cell with None <IMG src="file://C:\DOCUME~1\Owner\LOCALS~1\Temp\msohtml1\01\clip_image006.jpg" width=623 height=276 v:shapes="_x0000_i1027"> ctrl+c to copy cell then drag to all cells in column: <IMG src="file://C:\DOCUME~1\Owner\LOCALS~1\Temp\msohtml1\01\clip_image008.jpg" width=623 height=276 v:shapes="_x0000_i1028"> ctrl+v to paste to all cells in column <IMG src="file://C:\DOCUME~1\Owner\LOCALS~1\Temp\msohtml1\01\clip_image010.jpg" width=623 height=276 v:shapes="_x0000_i1029"> et voilà! That was fun!
Does this help?
John Hall http://surveyresearch.weebly.com
|
|
|
In reply to this post by James Algina
Jamie-
Sure, VALUE LABELS all. It'll spew out a bunch of errors if you have string variables, but all the value labels for the numeric variables will be gone. The value labels for string variables would have to be cleared one by one, but I would just use Excel to paste and concatenate ... If you paste your variable names in column A, then use this formula ... ="VALUE LABELS "&A1&"." Hope that helps, -Eric -----Original Message----- From: James Algina [mailto:[hidden email]] Sent: Monday, May 17, 2010 9:48 PM Subject: Value Labels Hello All, Is there away to delete the values labels for all variables without accessing the variable view and deleting the labels one at a time? Thanks, Jamie -- James Algina Professor Research and Evaluation Methodology 119D Norman Hall P.O. Box 117047 University of Florida Gainesville, FL 32611 ===================== 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 |
|
|
preserve. set errors none. value labels all. restore.
Jamie- Sure, VALUE LABELS all. It'll spew out a bunch of errors if you have string variables, but all the value labels for the numeric variables will be gone. The value labels for string variables would have to be cleared one by one, but I would just use Excel to paste and concatenate ... If you paste your variable names in column A, then use this formula ... ="VALUE LABELS "&A1&"." Hope that helps, -Eric -----Original Message----- From: James Algina [mailto:algina@...] Sent: Monday, May 17, 2010 9:48 PM Subject: Value Labels Hello All, Is there away to delete the values labels for all variables without accessing the variable view and deleting the labels one at a time? Thanks, Jamie -- James Algina Professor Research and Evaluation Methodology 119D Norman Hall P.O. Box 117047 University of Florida Gainesville, FL 32611 ===================== 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 |
| Free forum by Nabble | Edit this page |