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.
I'd create a calculation field and export the data from it:
Case (ethnicity = "African American" ; 1 ; ethnicity = "Asian", 2 ; ethnicity = "Hispanic" ; 3 ; 4 )