How to remove extraneous value labels. Keep only that actuallu occur in data.

Posted by Art Kendall on
URL: http://spssx-discussion.165.s1.nabble.com/How-to-remove-extraneous-value-labels-Keep-only-that-actuallu-occur-in-data-tp5739723.html

I am posting this question in case somebody has already worked this out.

I have variables with way too many value labels.  I received string
variables with mixed spellings, capitalizations, and even languages. I
AUTORECODEd and then RECODEd to collapse categories. So now there are labels
for values that do not occur in the data.

One kludge way to clean then up would be be to do
FREQUENCIES MISSING= INCLUDE.
Then highlight-copy-and-paste labels from the output file  into a  syntax
file.
Then edit that syntax file as a new set of value labels

Any suggestions?



-----
Art Kendall
Social Research Consultants
--
Sent from: http://spssx-discussion.1045642.n5.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