Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: RE: re: moving averages in panel data


From   Darian Woods <Darian.Woods@motu.org.nz>
To   "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu>
Subject   st: RE: re: moving averages in panel data
Date   Tue, 22 Dec 2009 16:55:07 +1300

Ah! Exactly what I needed. Thank you Kit.

-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Kit Baum
Sent: Tuesday, 22 December 2009 3:45 p.m.
To: statalist@hsphsun2.harvard.edu
Subject: st: re: moving averages in panel data

<>
Darian said

Thanks. Although 'tssmooth ma' doesn't seem to work because my data is not time-series data. In fact, it's not even panel data. It's product by country by year. So each year in each country has multiple observations due to the different products. That means that 'tsset year' or 'tsset year country' doesn't work, which makes tssmooth not work either.
Help with either moving averages or tips on working with this two-cross-sections-and-time data would be appreciated (without reshaping).


You can form a panel where the unit is the country-product, e.g. kiwi fruit exported by NZ. For that you have a time series. Use egen group() function to form a counter for each combination of country and product, and use that as the panel id variable. Then all time series functions will work properly.

Kit Baum   |   Boston College Economics & DIW Berlin   |   http://ideas.repec.org/e/pba1.html
                              An Introduction to Stata Programming  |   http://www.stata-press.com/books/isp.html
   An Introduction to Modern Econometrics Using Stata  |   http://www.stata-press.com/books/imeus.html


*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   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