Bookmark and Share

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]

st: restructure panel data


From   "DeMichele, Matthew" <mdemichele@rti.org>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: restructure panel data
Date   Sat, 8 Feb 2014 11:37:53 -0500

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

Matthew 



*
*   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/


© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index