Hi! I have a Qualtrics survey with several questions that have "select all that apply" options. I want to separate out all the responses into dummy variables so they can be a bit more flexible. I originally did this:
gen feelings_traumatized = strmatch(feelings, "*4*")
label var feelings_traumatized "Experienced feeling traumatized"
label val feelings_traumatized feelings_traumatized
However, when I ran into a "select all that apply" question that had more than 9 responses available, the whole thing fell apart. I tried stuff like gen var_a = strmatch(var, "*1*" & !"*11*" & !"*21*"), but that didn't work.
Does anyone have a good way for dealing with cleaning these types of survey questions? If it helps, here is some of my output when I tab the variable:
Feelings | Freq. Percent Cum.
---------------------+-----------------------------------
1 | 1 0.29 0.29
1,2,3,5,7,8,11,16 | 1 0.29 0.59
1,3 | 2 0.59 1.17
1,3,5 | 1 0.29 1.47
1,3,5,11 | 1 0.29 1.76
1,3,5,13 | 1 0.29 2.05
1,3,5,6,7 | 1 0.29 2.35
1,3,5,7 | 6 1.76 4.11
1,3,5,7,11 | 2 0.59 4.69
1,3,5,7,11,16 | 1 0.29 4.99
I've been stuck on this for a while and would really appreciate any insight anyone can offer. Thank you!
Related Posts with Data cleaning: Select all that apply
How to replace missing observations with the weighted sum of other observationsHello All, I am currently working with a panel data-set where I have missing observations for every…
How to change the 'levelsof' a panel variable?Hello All, I am trying to create a synthetic control group using Stata's 'synth' package but when I…
Help with ANOVAI am a relatively new user of Stata and was trying to evaluate an ANOVA analysis and investigate the…
Bootstrap average of a variable formed by ml estimationHi, I am trying to boostrap the average of a column over several iterations. The column values are …
Egen invalid syntax errorI am at my wits end with this. Can someone please see the error in my code. It was working before. T…
Subscribe to:
Post Comments (Atom)
0 Response to Data cleaning: Select all that apply
Post a Comment