See -reshape- I think.
Euler P. G. de Mello wrote:
Dear statalisters, especially Mr. Winter,
NumFirms IP1 IP2 ... IP67 IPUsado
2 1 1 1 2
4 1.23 1.12 1.08 1
3 1.45 1.23 1.12 67
. 1.50 1.34 1.16 2
. 1.53 1.43 1.23 1
I need to create a new variable which would look like:
IP
1
1.12
1.23 this is the IP2 used for the first firm of the first
1.34 sector
1.43
1
1.12
1.23 this is the IP2 used for the second firm of the first
1.34 sector
1.43
1
1.23
1.45 this is the IP1 used for the first firm of the
1.50 second sector
1.53
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
