I have this table:
ID AGE SEX Year Retired Wave
1 50 M Not retired 1
2 60 F 2001 1
3 70 M Not Retired 1
5 45 F 2001 1
1 51 M 2002 2
2 55 F Not Retired 3
6 65 F 2004 4
...
...
I would like to build a graph like this :
Proportion of female who retired by 2002= Retire by 2002 / ( Total just Retired + Non Retired in 2002 ) [ only wave 1 person involved ]
|
|
|
|
|____________
Age
Proportion of female who retired by 2002= Retire by 2002 / ( Total just Retired + Non Retired in 2002 ) [Only wave 2 Persons involved]
|
|
|
|______
Age
Secondly, how could I group the proportion by group age instead of just one age. 55-59 instead of 55, 56, 57 ...
Thank you.