Create table with difference sort of data proportion

[deleted_user]

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.