Re: st: Data management

[Kyle Hood <kyle.hood@yale.edu>]

n

If all the variables that are constant across years, just use the 
duplicates drop command.  If some of the variables are identified by 
country and year, use the collapse command

collapse (mean) x1 x2 x3 ... , by( countryid )

with a dataset this size, there should be no problems at all.

Kyle

On Tue, 24 Oct 2006, suryadipta.roy@lawrence.edu wrote:


> Hi,
>
> I have a (panel) dataset for around 100 countries for a period of 15 years 
> (on average) and I have the average values of some variables that are same 
> for all the years. I am trying to reduce the data to a single year for each 
> country and the "drop in" command for each country seems to be too repetitive 
> and labor-intensive. Can someone suggest another way in which I can get the 
> data for a single year for every country?
>
> Thanks,
> Suryadipta.
> *
> *   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/
*
*   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/