hi, guys
I have a problem relating to generate new varible( basic data structual is as follows). I want average wage when individual's age is between 35-45.
I tried to write the code: bys person:egen avg=mean(wage),inrange(2030-age,2040-age) ( this is survey of 1995, so 1995-(age-35) is the year when indivial was 35 years old, and
person age sector year wage avgwage
1 45 2 1975 1030
1 45 2 1976 1076
1 45 2 1977 1084
... ... ... ... ...
1 45 2 2000 3089
2
I have a problem relating to generate new varible( basic data structual is as follows). I want average wage when individual's age is between 35-45.
I tried to write the code: bys person:egen avg=mean(wage),inrange(2030-age,2040-age) ( this is survey of 1995, so 1995-(age-35) is the year when indivial was 35 years old, and
1995-(age-45) is the year when he was 45 years old. I know it seems incorrect, but have no idea about how to fix it. Please do me a favor! Thans sooo much!
person age sector year wage avgwage
1 45 2 1975 1030
1 45 2 1976 1076
1 45 2 1977 1084
... ... ... ... ...
1 45 2 2000 3089
2
48 5 1975 1030
2 48 5 1976 1076
2 48 5 1977 1084
... ... ... ... ...
2 48 5 2000 3089
