How to reshape this data to panel data?

[Raymond Zhang]

Dear all,How to reshape the data below to panel data?

clear
input double(year FDI_beijing FDI_tianjin FDI_hebei)
1995 1079.99 1520.64 541.75
1996 1552.9 2006.37 825.87
1997 1592.86 2511.35 1100.64
1998 2168 2113.61 1428.68
1999 1975.25 1763.99 1042.02
2000 1683.68 1166.01 679.23
2001 1768.18 2133.48 669.89
2002 1724.64 1581.95 782.71
2003 2191.26 1534.73 964.05
2004 2559.74 1720.91 699.54
2005 3526.38 3329 1912.56
2006 4551.91 4369 2382.74
2007 5065.72 5278 2416.21
2008 6081.72 7419.78 3418.68
2009 6120.94 9019.85 3598.24
2010 6363.58 10848.72 3830.74
2011 7054.47 13056 4680
2012 8041.6 15016 5804.86
2013 8524.18 16828.97 6447.2
2014 9040.85 18866.76 6371.96
2015 12996.35 21134.44 6180
2016 13028.58 10100 8150
2017 24309.09 10608 8489.51
2018 17310.89 4594 9080
2019 14212.99 4732 9850
2020 14100 . .
2021 15560 . .
end
[/CODE]

[Clyde Schechter]

reshape long FDI, i(year) j(city) string
replace city = proper(substr(city, 2, .))

[Raymond Zhang]

This is what I want.


+---------------------------+
| pro year FDI |
|---------------------------|
1. | beijing 1995 1079.99 |
2. | beijing 1996 1552.9 |
3. | beijing 1997 1592.86 |
4. | beijing 1998 2168 |
5. | beijing 1999 1975.25 |
|---------------------------|
6. | beijing 2000 1683.68 |
7. | beijing 2001 1768.18 |
8. | beijing 2002 1724.64 |
9. | beijing 2003 2191.26 |
10. | beijing 2004 2559.74 |
|---------------------------|
11. | beijing 2005 3526.38 |
12. | beijing 2006 4551.91 |
13. | beijing 2007 5065.72 |
14. | beijing 2008 6081.72 |
15. | beijing 2009 6120.94 |
|---------------------------|
16. | beijing 2010 6363.58 |
17. | beijing 2011 7054.47 |
18. | beijing 2012 8041.6 |
19. | beijing 2013 8524.18 |
20. | beijing 2014 9040.85 |
|---------------------------|
21. | beijing 2015 12996.35 |
22. | beijing 2016 13028.58 |
23. | beijing 2017 24309.09 |
24. | beijing 2018 17310.89 |
25. | beijing 2019 14212.99 |
|---------------------------|
26. | beijing 2020 14100 |
27. | beijing 2021 15560 |
28. | hebei 1995 541.75 |
29. | hebei 1996 825.87 |
30. | hebei 1997 1100.64 |
|---------------------------|
31. | hebei 1998 1428.68 |
32. | hebei 1999 1042.02 |
33. | hebei 2000 679.23 |
34. | hebei 2001 669.89 |
35. | hebei 2002 782.71 |
|---------------------------|
36. | hebei 2003 964.05 |
37. | hebei 2004 699.54 |
38. | hebei 2005 1912.56 |
39. | hebei 2006 2382.74 |
40. | hebei 2007 2416.21 |
|---------------------------|
41. | hebei 2008 3418.68 |
42. | hebei 2009 3598.24 |
43. | hebei 2010 3830.74 |
44. | hebei 2011 4680 |
45. | hebei 2012 5804.86 |
|---------------------------|
46. | hebei 2013 6447.2 |
47. | hebei 2014 6371.96 |
48. | hebei 2015 6180 |
49. | hebei 2016 8150 |
50. | hebei 2017 8489.51 |
|---------------------------|
51. | hebei 2018 9080 |
52. | hebei 2019 9850 |
53. | hebei 2020 . |
54. | hebei 2021 . |
55. | tianjin 1995 1520.64 |
|---------------------------|
56. | tianjin 1996 2006.37 |
57. | tianjin 1997 2511.35 |
58. | tianjin 1998 2113.61 |
59. | tianjin 1999 1763.99 |
60. | tianjin 2000 1166.01 |
|---------------------------|
61. | tianjin 2001 2133.48 |
62. | tianjin 2002 1581.95 |
63. | tianjin 2003 1534.73 |
64. | tianjin 2004 1720.91 |
65. | tianjin 2005 3329 |
|---------------------------|
66. | tianjin 2006 4369 |
67. | tianjin 2007 5278 |
68. | tianjin 2008 7419.78 |
69. | tianjin 2009 9019.85 |
70. | tianjin 2010 10848.72 |
|---------------------------|
71. | tianjin 2011 13056 |
72. | tianjin 2012 15016 |
73. | tianjin 2013 16828.97 |
74. | tianjin 2014 18866.76 |
75. | tianjin 2015 21134.44 |
|---------------------------|
76. | tianjin 2016 10100 |
77. | tianjin 2017 10608 |
78. | tianjin 2018 4594 |
79. | tianjin 2019 4732 |
80. | tianjin 2020 . |
|---------------------------|
81. | tianjin 2021 . |
+---------------------------+

[Raymond Zhang]

reshape long FDI, i(year) j(city) string
replace city = proper(substr(city, 2, .))

@Clyde Schechter Thanks very much.It works well.