Statalist The Stata Listserver


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: Data management


From   Kyle Hood <kyle.hood@yale.edu>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Data management
Date   Tue, 24 Oct 2006 19:36:10 -0400 (EDT)

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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index