Dear Statalist,

I am now setting the data to write the DID.
However, there is a problem with the arrangement of my data to use DID.

My data are like as below:

ID | revenue2007 | revenue2008 | revenue2009 | asset2009 | asset2010 | asset2011 | manufacture | wholesale | others

While manufacture, wholesale, and others are dummy variables. (Form of 0 1)

I would like to set the above data as follows.

ID year revenue asset type of business
1 0(2007)
1 1(2008)
1 2(2009)
1 0
1 1
1 2
1 0
1 1
1 2
2 0
.
.
where year 0 represents 2007, 1 does 2008, and 2 does 2009.
(Suppose the treatment was treated at 2008)


I tried to use 'reshape', but I do not know how to do it.
Thanks in advance.

HJ