Dear Statalisters,
my question is fairy basic but I fail to find a solution myself. I have a sample of projects of N firms from 1990 till now. It looks this:
year firm inventory
1990 X1 a
1990 x2 b
1990 x3 c
1990 x3 d
2000 x2 e
2000 x3 f
The problem is: the only thing I am really interested in is the number on the projects per firm per year. So it should look like this:
firm inv1990 inv2000
x1 1 0
x2 1 1
x3 2 1
Is there any count function which I can apply to modify my dataset like this given that the number of firms is quite large?
Thanks for your help!
--
Psst! Geheimtipp: Online Games kostenlos spielen bei den GMX Free Games! Spa�garantie pur:
http://games.entertainment.web.de/de/entertainment/games/free
*
* 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/