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: Reshape long multiple variables per year (semesters)
From
maria pilar <[email protected]>
To
[email protected]
Subject
st: Reshape long multiple variables per year (semesters)
Date
Sun, 11 Nov 2012 04:27:44 +0000 (UTC)
I have a database that tracks disbursements twice a year (june and december), and the variables (columns) appeared as JUN93, DEC93, JAN95, DEC94, and so on. Each project can last several years. I renamed the semesters x (june) and y (december).
It looks like this
Operationnumber TYPE x1993 y1993 x1994 y1994 x1995 y1995 x1996 y1996 x1997
a DEL 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
b DEL 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
c DEL 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
d DEL 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
e DEL 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
I tried the following, and go some message I do not understand (any insights appreciated)
. reshape long x y, i(operationnumber) j(year)
(note: j = 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005
> 2006 2007 2008)
y1998: 26 values would be changed; not changed
x1999: 20 values would be changed; not changed
y1999: 22 values would be changed; not changed
x2000: 20 values would be changed; not changed
y2000: 24 values would be changed; not changed
y2001: 229 values would be changed; not changed
x2002: 195 values would be changed; not changed
y2002: 268 values would be changed; not changed
x2003: 225 values would be changed; not changed
x2007: 258 values would be changed; not changed
Data wide -> long
----------------------------------------------------------------------------
> -
Number of obs. 1525 -> 24400
Number of variables 34 -> 5
j variable (16 values) -> year
xij variables:
x1993 x1994 ... x2008 -> x
y1993 y1994 ... y2008 -> y
----------------------------------------------------------------------------
> -
And the database now looks like
operationnumber year type x y
a 1993 MIF 0 0
a 1994 MIF 0 0
a 1995 MIF 0 0
a 1996 MIF 0 0
a 1997 MIF 0 0
a 1998 MIF 0 0
a 1999 MIF 0 625000
a 2000 MIF 0 0
b 1993 MIF 0 0
b 1994 MIF 0 0
b 1995 MIF 0 0
b 1996 MIF 0 0
b 1997 MIF 0 0
b 1998 MIF 0 0
b 1999 MIF 0 0
b 2000 MIF 0 0
However this is not what I need.
I'd like something like this
operationnumber year type disbursement
a x 1993 MIF 0
a y 1993 MIF 0
a x 1994 MIF 0
a y 1994 MIF 0
a x 1995 MIF 0
a y 1995 MIF 0
b x 1993 MIF 0
b y 1993 MIF 0
b x 1994 MIF 0
b y 1994 MIF 0
b x 1995 MIF 0
b y 1995 MIF 0
If it makes sense...
Thanks to all!
*
* 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/