Create variable - mean per age

[Ana Vasconcelos]

Hello,

I would like to create a variable that says the mean value of income (prfitba_w3) by age (dvage). Can you help me with this?
Thank you very much in advance.
* Example generated by -dataex-. For more info, type help dataex
clear
input long pidp int dvage byte prfitba_w3 float wave
82167813 20 . 2
340034695 22 . 4
612239375 18 . 5
1157072379 24 . 2
476444731 21 . 1
829872693 19 . 1
639631821 25 . 5
1565598011 22 . 2
1022224971 23 . 4
884455611 25 . 1
1570371724 25 . 1
1224246175 16 . 4
1226278802 20 . 4
477011851 17 . 3
1430507855 19 . 3
564500653 20 . 1
819053282 24 . 3
138027093 19 . 1
1156329135 20 . 3
206428289 24 . 2
1498338535 16 . 1
1226416731 24 . 4
273538177 18 . 5
284464484 22 . 2
1226155688 23 . 2
408174775 20 . 2
952569175 19 . 1
952367964 23 . 1
1156188375 25 . 4
1496701103 17 1 1
750650655 17 . 3
1375810130 22 . 3
1103816850 24 . 4
816971739 21 . 2
1634600335 22 . 1
205145139 22 . 3
817846889 18 . 2
1225147171 21 . 1
476520899 17 . 4
952050339 21 . 4
273095495 22 . 3
688228768 23 . 3
885106379 16 . 2
1089193415 18 . 2
817755111 25 . 5
409110455 23 . 4
1632637855 18 . 1
205626579 17 . 5
273715659 16 . 4
411557777 16 . 4
1020199931 17 . 1
343136849 21 . 1
1564763659 22 . 4
136828939 20 . 3
952229859 17 . 5
231969773 22 . 2
546148127 21 . 1
1020588891 20 . 1
1428502535 22 . 2
1429650375 18 . 4
1157147175 21 . 1
1224741215 22 . 3
224929729 22 . 3
885030899 23 . 5
1022258975 18 . 3
816954055 23 . 5
273140375 23 . 3
477005047 25 . 1
1156260459 20 . 4
340720813 21 . 2
1021845535 18 . 2
748911901 22 . 2
680181575 19 3 1
1360246859 16 . 3
272979887 22 . 1
1632928895 19 . 3
273097535 25 . 1
545274351 16 . 1
612949307 16 . 4
137632088 24 . 2
138794135 17 . 2
557619053 21 . 2
68945895 19 . 2
1632615415 17 . 1
1224808535 16 . 4
761968577 22 . 4
612508663 16 . 1
545812227 18 . 2
476442695 17 . 5
1021020007 25 . 2
81651693 21 . 1
825853968 21 . 2
1020029939 17 . 2
748040807 25 . 1
1361944884 18 . 3
1088997575 21 . 5
1033511690 22 . 3
81651697 23 . 3
1020697695 17 . 3
476766371 18 . 2
end
label values dvage c_dvage
label values prfitba_w3 c_prfitba_w3
label def c_prfitba_w3 1 "up to 3,599", modify
label def c_prfitba_w3 3 "6,600 - 9,599", modify
[/CODE]

[Carlo Lazzaro]

Ana:
the way income is reported does not make it suitable for further elaborations.
Therefore, I 've created a fake income variable for te following toy-example:

. g fake_income=runiform()*1000000

. bysort dvage: egen wanted=mean( fake_income)

.

[Ana Vasconcelos]

Thank you very much!