I'm running Stata 15.1 on OSX. My ultimate goal is to create a graph that displays the age-adjusted median incomes for different European ethnic groups. I know how to create a simple median income variable by group (egen medincome_group=median(inctot), by(ancestgroup)), but I'm not sure how to create one that adjusts for the effects of age differences. Can anyone point me in the right direction?
Here is some example data:
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input long inctot float ancestgroup 184000 10 7200 10 24000 3 43000 1 52000 10 38900 21 . 5 135000 8 13000 2 . 10 60000 6 40000 10 15000 5 103620 2 34500 3 50000 3 42000 10 17400 17 79000 5 . 9 . 3 49700 21 . 15 13800 5 39000 3 0 5 25000 5 27500 5 190 5 34800 5 81100 3 45700 5 1310 2 36000 5 80900 10 0 3 37000 11 0 10 24400 15 60000 1 . 5 . 5 25000 3 74000 5 41000 2 30000 9 32000 5 6000 14 32600 1 25000 3 10000 1 26000 5 148000 1 47200 10 14000 3 28000 8 43600 3 70900 1 0 3 55000 9 0 10 25000 42 . 5 75000 5 50000 5 68000 10 10800 5 60030 21 26100 1 11200 1 30000 6 406000 2 92900 1 5300 14 4500 2 110600 3 70000 2 130000 10 15090 10 40000 19 25000 5 8700 5 50000 14 36000 21 16000 9 17000 5 . 3 10000 5 29800 5 0 2 7300 5 425300 21 50000 5 45000 5 16800 1 7200 5 10000 1 126000 5 34000 8 14800 5 end label values ancestgroup ethnic1b label def ethnic1b 1 "British/English", modify label def ethnic1b 2 "Scottish", modify label def ethnic1b 3 "Irish", modify label def ethnic1b 5 "German", modify label def ethnic1b 6 "Dutch", modify label def ethnic1b 8 "Russian", modify label def ethnic1b 9 "French", modify label def ethnic1b 10 "Italian", modify label def ethnic1b 11 "Greek", modify label def ethnic1b 14 "Swedish", modify label def ethnic1b 15 "Norweigan", modify label def ethnic1b 17 "Hungarian", modify label def ethnic1b 19 "Czech", modify label def ethnic1b 21 "Polish", modify label def ethnic1b 42 "Yugoslavian", modify
0 Response to Creating age-adjusted group-level median income variable
Post a Comment