AnsweredAssumed Answered

Value Lists

Question asked by ANP on May 13, 2010
Latest reply on May 13, 2010 by philmodjunk


Value Lists

Your post



I have built a database where most of the data is text data.  This option was chosen to increase ease with data entry.  Now I want to analyze this data under a data analysis software (SPSS).  Is there a simple way for me to convert my text data into numerical data.  For example, one of my variables, ethnicity, has options:  African American, Asian, Hispanic, and European.  I would like to convert African American to 1, Asian to 2, Hispanic to 3, and European to 4.  What are the best ways to convert text variables to numerical variables.