Create copy of numeric var, but apply different value labels

Moderators: statman, Analyst Techy, andris, Fierce, GerineL, Smash

0101
Posts: 52
Joined: Fri Mar 04, 2011 9:42 pm

Create copy of numeric var, but apply different value labels

Postby 0101 » Wed Jan 04, 2012 9:43 pm

Using SPSS 19.

I have two variables with data like so:

Code: Select all

SubjectID  ColorNum  ColorDescription
----------  ---------  -----------------
1          1 = Green    Really green
2          2 = Red      The corvette color
3          3 = Blue     Sky
4          2 = Red      The corvette color
etc.
ColorNum is Numeric (and I'm showing the value and value labels).
ColorDescription is String.

I'm trying to create a numeric variable, ColorNumLong, that looks like this:

1 = Really Green
2 = The corvette color
3 = Sky

In other words, it copies the values from ColorNum (1, 2, etc.), and creates value labels using the corresponding value from ColorDescription (Really green, The corvette color, etc.)

One issue is that the ColorNum legend will sometimes change. So, 1 may = Green today, but it might = Blue tomorrow. So I can't simply develop a fixed legend of values and descriptions, and use Data > Copy data properties.

Any suggestions?

Who is online

Users browsing this forum: No registered users and 1 guest

cron