Averaging with a condition while generating a new variable

[Samyam Shrestha]

Hi there!

I have household-level data with unique household_id. For each household, I have data for village_id and income, among other variables.

Is there any way I can create a new variable called village_income_mean by averaging the income amounts across a village given by village_id?

Thanks!

[William Lisowski]

Something like the following would do what you want.

by village_id, sort: egen village_income_mean = mean(income)

[Samyam Shrestha]

Thanks a ton, William, it works! Also, any way I can create a variable with the standard deviation of income by village?

[William Lisowski]

The output of help egen lists all the functions that the egen command includes.