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
Graph line with values for only a few groups over timeHi, I want to graph the development of the number of houses of the type "allmännyttan" (publicly ow…
OLS regression where one independent variable is a rare eventHello all, I am performance ols regression, something like: regress y i.x1##i.x2 x3 x4 x5, cluster…
SchemesI have just upgraded from 15 to 16. Is there any way to import my schemes from 15 without having to …
Keep last 4 digits of a numeric variableHi everyone, I would like to ask you how can I keep the last 4 digits of the variable date. It is a …
Managing workflow with the global macroHello Stata users, I am trying to use the global macro to switch between subfolders. For instance, …
Subscribe to:
Post Comments (Atom)
0 Response to Loop over households and individuals
Post a Comment