Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: RE: How do I properly tell Stata this data is Panel Data?
From
Nick Cox <[email protected]>
To
[email protected]
Subject
Re: st: RE: How do I properly tell Stata this data is Panel Data?
Date
Sat, 13 Oct 2012 00:12:38 +0100
This advice is quite incorrect: -xtset- or -tsset- will not accept
-quarter- as a time variable, because there are repeated values within
each panel.
You are best advised to calculate a quarterly date that combines the
two time variables.
gen qdate = yq(year, quarter)
format qdate %tq
xtset countynumber qdate
Nick
On Fri, Oct 12, 2012 at 11:08 PM, Sun Yutao <[email protected]> wrote:
> I think you should set the quarter as your time axis. And when you need to estimate something that is year-wide, you take sum or average depending on what you want exactly.
Andrew Nicholson
> Essentially my data looks as follows:
>
> County CountyNumber Year Quarter ......................
> Allen 1 2001 1
> Allen 1 2001 2
> Allen 1 2001 3
> Allen 1 2001 4
> Allen 1 2002 1
> ... ... ... ...
> Allen 1 2008 4
> Anderson 2 2001 1
> ... ... ... ...
> Anderson 2 2008 4
>
> It continues this way for 105 counties. My question is how do I use the xtset command when I have both Year and Quarter as time variables. County and CountyNumber are both classifying the same thing in the dataset.
>
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/faqs/resources/statalist-faq/
* http://www.ats.ucla.edu/stat/stata/