sum HH1 HH2 LN // HH1=cluster number, HH2=household number, LN=line number (child in household)
gen idnumber = string(HH1) + " " + string(HH2) + " " + string(LN)
gen id = string(HH1) + " " + string(HH2) // use this to merge with hh data below
save ch.dta, replace // this will save to current working directory
use "/Users/justinegosling/Desktop/Malawi_MICS5_Datasets/Malawi MICS 2013-14 SPSS Datasets/House hold.dta"
// 28479 observations, 177 variables
// this also has the same HH1 HH2 variables:
sum HH1 HH2
gen id = string(HH1) + " " + string(HH2) // to merge on household id with child data
merge 1:m id using "/Users/justinegosling/Desktop/Malawi_MICS5_Datasets/Malawi MICS 2013-14 SPSS Datasets/childrens .dta"
Can someone please tell me why after the above coding when I try to merge the data states response is: variable id not found r(111);
Many thanks
Related Posts with Can someone tell me why the variable 'id' can't be found please?
Interpreting fixed and random effects from a negative binomial mixed modelHi everyone. For a problem I am trying to tackle, I have created a negative binomial mixed model. T…
ivreg2 warning that covariance matrix is not of full rank. But can't figure out whyI am running fixed-effect instrumental variable panel regression. The data is unbalanced panel. The …
Color SchemeHi I have been using a user written command VennDiagram to draw venn diagram in Stata 15. I wanted …
debt thresholdsHi everyone I have already done the following fixed effects regression: xtreg labor productivity; d…
Stata code for Hsiao, Ching, and Wan (2012, Journal of Applied Econometrics)Dear All, Does anyone happen to have Stata code for the interesting model in "Hsiao, Cheng, H. Steve…
Subscribe to:
Post Comments (Atom)
0 Response to Can someone tell me why the variable 'id' can't be found please?
Post a Comment