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
Regression Tobit Panel Data Fixed Effect (Estimation of Panel Data Censored Regression Model) Use Pantob With STATA 17Regression Tobit Panel Data Fixed Effect (Estimation of Panel Data Censored Regression Model) Use Pa…
Table for Regression outputHi I would like to create a regression output table for multiple regressions that displays the coeff…
Different Results When Running IV RegressionHi all, This is my 3rd post so far on this topic and I am so lost. Thank you guys so much for havin…
How to count strings across variables*Hello, How can I count string values (Topic_1 through to Topic_4) across multiple variables ? I want…
Problem with did_multiplegt Code: did_multiplegt ln_gift id month shock , controls(member age gender) robust_dynamic dynamic…
Subscribe to:
Post Comments (Atom)
0 Response to Question on analyzing multiple answers question
Post a Comment