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
List of values of variable by patient-IDDear stata-community, I would like to have a list of how many patients that has a certain age, but o…
Extract entries across rows?Dear Statalist, Imagin 3 players transmitting messages, we say a player transmits a message correct…
Panel spatial correlation consistent least-squares dummy variables (PSCC-LSDV)Greetings, Dear all, Kindly guide how to estimate Panel spatial correlation consistent least-squares…
Generating a single descriptive statistics table for a range of variables using a foreach loopI have a healthcare dataset that codes a principal diagnosis using a variable 'I10_DX1' and secondar…
Difference in N of obs. in Cox modelHi, I have a problem regarding the difference in the number of observations between the Cox model a…
Subscribe to:
Post Comments (Atom)
0 Response to Question on analyzing multiple answers question
Post a Comment