Collapse

make sure you understand this one...

create aggregate data

collapse (mean) occ_fem=sex occ_ave=wage (count) occ_n=sex, by(occ)

simple example:

clear set obs 10 gen x=_n gen y=group(2) list tab y, sum(x) C:\papers\soc709\new\labs\soc709 lab1.htm