Thank you Nick for suggesting this nice solution to my problem. For those
interested the alternative to my previous posting is:
*=====================================
u ctypes, clear
drop *_*
egen cmiss = rmiss(c?)
gen cpresent = 3 - cmiss
tab cpresent cmixtures
drop cmixtures-cpresent
reshape long c, i(id plot)
drop if area == .
drop if id == .
drop if c == .
su
bysort id plot : gen Area = area / _N
tabstat Area, by(c) s(sum)
*======================================
Best regards,
Adama
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/