Fastest way to convert text choices on collection form to numerical values on table
Hi I'm trying to enter 400 data observation via collection form into a database.
Some of my variables are multiple choices (such as gender, marriage status, and race) right now text variables.
How do I enter them so in data collection form they are still seen as "Male" "Female" and "single" "married" but become numerical values in the table.
When I download later into excel sheet, I want most of my values to be numerical.
See my response to your other post for ideas on how to do this.