Hi all,

I am new on Stata so my knowledge is limited. I have a variable that indicates whether the respondents' children are natural, adopted, foster etc. or not. This variable is repeated 20 times (asked to respondents depending on their children number). I would like to gather this information and create a new variable that indicates if the child is natural or not. I tried to create loop or tried to use egen command but I was unsuccessful...

that's why i write:
gen natural_child=.
replace natural_child=1 if rel_chil_1=1|6|7|8
replace natural_child=1 if rel_chil_2=1|6|7|8
replace natural_child=1 if rel_chil_3=1|6|7|8
.
.
.

Can you help me and show me how to create a new variable more efficient way?
Thanks in advance.

Kind regrads,
Martin.