Hi,
I want to create a variable that gives me the amount of children aged 17 and younger (children17) for each household.
For that I have these vars:
hhid -> household id
pid_1 - pid_8 -> id of the individual in the household between 1 and 8 (so a person can have no. 1, 2,3...or 8 referring to a certain household id)
age_1 - age_8 -> age of each individual (no.1 - no.8) in a household
relrefp -> the relationship to the reference person of the hh: each of the children need relrefp==3 (daughter/son)
I tried to create such a variable with a loop several ways but somehow I do not find the correct solution.
forv i = 1(1)8 {
2. gen children17=`i' if age_`i'<=17 & relrefp_`i'==3
3. }
This is probably still not that close to the solution, as stata tells me that "variable children17 already defined", though it´s not in the datasat before starting the loop.
Perhaps someone with much more experience in stata loops can give me the right hints?
Related Posts with Loop over households and individuals
Summing the values of a variable WITHOUT taking into the frequencyHello all, Following on from https://www.statalist.org/forums/for...ir-frequencies, I did the follo…
Need guidance with covariate-adjusted discrete-time survival analysis (Cox model)Hello, I am trying to run covariate-adjusted discrete-time survival analysis, specifically using th…
Transition MatrixHello, I am trying to generate a transition matrix of the change in the employment status of individ…
Exporting Descriptive Statistics using proportion (%) for multinomial results into excelI would appreciate some advice on how to use a short cut (if there is one!) as the put excel command…
BacktestingHi everyone, I am trying to run a backtesting model for the data I have. I am not an expert with st…
Subscribe to:
Post Comments (Atom)
0 Response to Loop over households and individuals
Post a Comment