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: restructure panel data
From
Nick Cox <[email protected]>
To
"[email protected]" <[email protected]>
Subject
Re: st: restructure panel data
Date
Sat, 8 Feb 2014 18:05:07 +0000
Working with precisely this data shape was the focus of
SJ-7-2 dm0031 . . . . . . . . . Stata tip 45: Getting those data into shape
. . . . . . . . . . . . . . . . . . . . . . . C. F. Baum and N. J. Cox
Q2/07 SJ 7(2):268--271 (no commands)
tip on applications of reshape and solving data
management problems
freely available and available for free at
http://www.stata-journal.com/sjpdf.html?articlenum=dm0031
Nick
[email protected]
On 8 February 2014 16:37, DeMichele, Matthew <[email protected]> wrote:
> I'm having trouble figuring out how to restructure the following data to
> long form by country and years. I have a data set that is organized (see
> below) by country (C1) but I want to restructure this in country and
> year with the rate and count as separate variables. Any suggestions?
> Thank you.
>
> C1 C2 C3 C4 C5
> 1995 1996 1997
> Anguilla Rate 10.19 12 13
> Anguilla Count 50 56 60
> Antigua and Barbuda Rate 11 15 14
> Antigua and Barbuda Count 100 120 115
>
*
* 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/