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?
appending a string and time variablesTwo of the variables in my dataset needs to be appended into a new variable. The first of represents…
Regarding the question of the spmatrix import comandi do a spmatrix import, while it Array i modify my matrix from the command of spmatrix export, so i…
Error Code r 601Hello, I am trying to import an excel file into STATA but I receive the error code r 601. I am usin…
Different markers with rcapsymHi, I would like to have 2 different markers for the starting points and the end points. So for exa…
How to drop duplicate ID observation series with different variable valuesHi all, I hava an panel dataset for firms and stock returns between 2005 and 2015. However, for som…
Subscribe to:
Post Comments (Atom)
0 Response to Can someone tell me why the variable 'id' can't be found please?
Post a Comment