Hello, I am a novice user of stata....

I ask you for help solving my problem generating new var...


I was trying to generate new variable which was to take a mean by district (var name : "name_3") excluding myself ("hhid")....

Can you guys give me some tips to create such var in my situation?

below is the code that I tried, but seems make no sense..

bys name_3 : egen peerdiv1 = mean(diversity1) if 000
name_3 hhid di1 di1 di1 di1 di1 ?
An Minh 909 2 1 0.996933 0.0625 4
An Minh 910 1 0 1 0.015625 5
An Minh 911 1 0 1 0.015625 5
An Minh 912 4 1 0.924703 0.25 2
An Phu 913 1 0 1 0.015625 5
An Phu 914 1 0 1 0.015625 5
An Phu 915 1 0 1 0.015625 5
An Phu 916 2 1 0.555556 0.0625 1

Appreciate your wisdom in advance,

Manny