Hello, I am fairly new to STATA. I have my excel data base and I want it to look like this:
So basically I asked people what form of AI they used and the had the chance to select multiple I have them 5 options and the sixth option was "Other" where they could write the one they used.
I am having trouble figuring out how to make STATA turn the others into and "Other" variable and everytime someone used ChatGTP count it as 1 rather than if someone used ChatGTP+Gemini count it as 0 for ChatGTP but 1 for ChatGTP+Gemini.
TLDR;
I want it to look like this in STATA
rather than this that is what i'm facing up against
So basically I asked people what form of AI they used and the had the chance to select multiple I have them 5 options and the sixth option was "Other" where they could write the one they used.
I am having trouble figuring out how to make STATA turn the others into and "Other" variable and everytime someone used ChatGTP count it as 1 rather than if someone used ChatGTP+Gemini count it as 0 for ChatGTP but 1 for ChatGTP+Gemini.
TLDR;
I want it to look like this in STATA
rather than this that is what i'm facing up against
Attached Files
Comment