Hello,
I have what may be a basic question. I have data like this:
country year series1 series2 series3
1 1 1000 . .
1 2 1035 . .
1 1 . 50 .
1 2 . 53 .
1 1 . . 7
1 2 . . 8.5
2 etc
Is there anyway I can basically collapse these so that:
country year series1 series2 series3
1 1 1000 50 7
1 2 1035 53 8.5
for a number of countries?
Thanks for your help.
Justin
*
* 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/