Help with graphs

[Carlos Gallego]

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

[Andrew Musau]

Since you have 12 posts on Statalist, you're not entirely new to this forum. Let's begin by examining a data example. After importing the data into Stata, you can copy and paste the result of the following.

preserve
contract, nomiss
dataex
restore