Hi Georg,

Try something like

add val lab myvariable 97 ''.

(untested - I do not have Tables licensed here)

Greetings

Jan

-----Original Message----- From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of Georg Maubach Sent: Wednesday, February 08, 2006 7:35 PM To: SPSSX-L@LISTSERV.UGA.EDU Subject: Deleting a Value Label

Dear Listers,

we need to delete a value label from a hole bunch of variables to properly do a CTABLES like this:

1 very good 10 2 indifferent 0 3 very bad 12 99 don*t know/no answer 4

The actual coding is:

1 very good 10 2 indifferent 0 3 very bad 12 97 don't know 1 98 no answer 3

We need to recode all variables like

RECODE ALL (97, 98 = 99) .

But: We need the zero as a value in CTABLES for all categories with no response. The solution to just recode is not sufficient cause the CTABLES would look like this

1 very good 10 2 indifferent 0 3 very bad 12 97 don't know 0 98 no answer 0 99 don't know/no answer 4

but we want to have

1 very good 10 2 indifferent 0 3 very bad 12 99 don't know/no answer 4

Therefore we would like to delete the value label from all the variables. Is there a way to delete the value label completely using SPSS 13.0 so that it does not show up in CTABLES?

Any hint is appreciated.

Best regards

Georg Maubach Market Analyst Deutsche Post World Net Business Consulting GmbH Market Research Service Center