Hello Statalist
I have troubles with my data and i hope you can help me
My problem is that i have conducted a conjoint dataset. My total number of observations is 1251. In this dataset i have three rounds of 15 different dichotomous variables and that makes 45 diiferent dichotomous variabels. All respondets have answered three different of these. i have reshaped the dataset from long to wide and back to long again so my total numbers of observations increased to 1251x3 =3753. My problem is when i try to combine all my dichotomous variables into one combined dichotomous variabel my total number of observations is 1251 and not 3753. I think the problem is the way stata treats missing values. Because my 1251 observations have answered 3/45 different dichotomous variables, they are treated as missing values in the rest of the variables.
I have tried the replace command:
gen var1=.
replace var1=0 if var21 !=. & var22==0 | var22 !=. & var21==0 .... and so on but it doesn't work
egen var1, totalrow(varlist) will not work in my case either because i want my final variabel to be dichotomous aswell
I hope i have given you enough information to help me with me situation
Best regards
Rasmus
Related Posts with Combing dichotomous into one
How to best illustrate trends/distributions of many data points?Hi everyone, I have a lot of data from an experiment and would like to find the best way to display…
Help with Regression Interaction Term CommandDear all, I am using Stata 16, on mac. I need help estimating the following model Array Where educ…
not estimable margins after reghdfeDear Statalisters, I have a problem in computing the margins of a linear fixed effects regression th…
Using bysort egenHi everyone, I am using the command Code: bysort $id: egen . The result I got containing the missi…
Psmatch2 for prepensity score matching with specific categorical variablesHello Statalist community. I am currently trying to do a propensity score matching with the psmatch…
Subscribe to:
Post Comments (Atom)
0 Response to Combing dichotomous into one
Post a Comment