Dr. Attaullah Shah
Keymaster
Post count: 106

If you just need the mean for each industry, then you use the option stat(). See for example:

sysuse nlsw88, clear
bys industry : asdocx sum wage, stat(mean) replace

----+---------------------------------
  1 |                            wage 
----+---------------------------------
  2 |Ag/Forestry/Fisheries      5.621 
  3 |Business/Repair Svc        7.516 
  4 |Construction               7.565 
  5 |Entertainment/Rec ~c       6.724 
  6 |Finance/Ins/Real E~e       9.843 
  7 |Manufacturing              7.502 
  8 |Mining                     15.35 
  9 |Personal Services          4.401 
 10 |Professional Servi~s       7.871 
 11 |Public Administrat~n       9.148 
 12 |Transport/Comm/Uti~y      11.443 
 13 |Wholesale/Retail T~e       6.126 
--------------------------------------