I have a data set of 987 respondents. I asked them on there most common sources of treatment and they could choose more than one source out of a possible 10 choices. I have created the following loop and it works perfectly as i can now report frequency of each type of source of care. I would like to collapse/combine district hospital, sub district hospital, health center and dispensary into a category called "government facility" and private hospital, private clinic and mission hospital into a category called "private facility" etc. How do i go about this bearing in mind this was a multiple answers question?
Thanks in advance.
forvalues i=1/10 {
generate treatment`i' = regexm(trtmntsrc,"`i'")
replace treatment`i'=. if Trttype!=1
tab treatment`i',miss
recode treatment`i' (1=1 "Yes") (0=0 "No"), gen(treatment_new`i')
tab treatment_new`i'
}
rename treatment_new1 district_hospital
rename treatment_new2 sub_district_hospital
rename treatment_new3 health_center
rename treatment_new4 dispensary
rename treatment_new5 community_health
rename treatment_new6 mission_hospital
rename treatment_new7 private_hospital
rename treatment_new8 private_clinic
rename treatment_new9 pharmacy
rename treatment_new10 shop
Related Posts with Question on analyzing multiple answers question
ivreghdfe: how to first-stage regression predicted valueshello, i'm using ivreghdfe, and i'm interested in obtained predicted values of the endogenous variab…
Invalid lvalHi, I am new to mata, and I'm replicating an old code that uses it. Unfortunately, I'm getting the …
How to create groups with an equal number of observations?Hi, I have a enormous data set and I would like to create ten groups (country) with an equal number…
getting estimated y vale for regressions on subsamples of a panel datasetDear Statalist, I need to have estimated value of an independent variable for a panel data set for …
How to get the value of the first occurence on the first rowI have a data in this format below. I want to generate another column (X) that gave me the value of …
Subscribe to:
Post Comments (Atom)
0 Response to Question on analyzing multiple answers question
Post a Comment