Assigning the same value for same observation

[Annie Sylth]

Hi, I'm new to stata and I need some help.
Below I have the data on number of members in a household, total income of that household, incomer per head and id of each person in the same household. I want to match the value of "income per head" same for every person with the same "id" to see their average income, but don't know how to do it. Can anyone help me?
Thank you very much.

[Nick Cox]

Please read and act on https://www.statalist.org/forums/help#stata (no screenshots, please copy and paste example data from dataex output).

I suggest one of

bysort newid : egen mean_income = mean(income)

bysort newid : egen mean_income2 = max(income_per_head)

and study of

help egen

[Carlo Lazzaro]

Annie:
you're probably looking for something along the following toy-example:

. set obs 8

. g household_id=1 in 1/4

. replace household_id=2 if household_id==.

. bysort household_id: g id=_n

. bysort household_id: g overall_income=10000 if _n==1

. replace overall_income=0 if overall_income==.

. bysort household_id: egen average_income=mean(overall_income)

. list, sepby( household_id)

PS: I've come late to the party!