Hi All,

I have a  huge data set with the following type;
  city year sex  obs
1      1990  M  25
1      1990  F   32
1      1991  M  15
1      1991  F   22
2      1990  M  42
2      1990  F  36
2      1991  M  12
2      1991  F  16

I want to calculate the percentage of M and F  by city, year and year
within city and also plot.
city 1    total Male= 40;  total female= 54;
                   %M= 40/(40+54)=42.6
                    %F= 54/(40+54)=57.4

and so on.

Can any body help me out?

Thanks in advance

	[[alternative HTML version deleted]]