1 Reply Latest reply on May 13, 2010 2:52 PM by philmodjunk

    Value Lists

    ANP

      Title

      Value Lists

      Your post

      Hello:

       

      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.