半年度数据如何设置面板

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

各位大神，

1.我的数据是半年度数据，设置面板数据的时候，计算gen 净利润增长率=(净利润-L.净利润)/L.净利润 结果全是missing value。半年度数据是没有办法做面板吗？

2.我手动把 日期 1998-06-30 替换为 1 ，1998-12-31替换为2，以此类推，这样面板就能正常算了，但是，这次数据量太大了，没办法手动替换，我写命令 replace date=1 if date=="1998-06-30" 又错误提示 type mismatch。请问如何用命令 把字符格式的日期替换成数子 1、2、3这样

谢谢了！

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏3 回帖

关键词：年度数据 mismatch missing replace Match

你若要问程序，永远附上相关资料 (请不要用截图)；若附上资料，永远用 dataex 印出资料。
•        先 ssc install dataex (并见说明)，将原始 Stata 资料中具有”代表性”的一部分资料列出，以供有意回答者实验之用，并能提供具体操作指令。
•        请参考说明 https://bbs.pinggu.org/thread-5048204-1-1.html。

相关资料如下：
----------------------- copy starting from the next line -----------------------

1. * Example generated by -dataex-. To install: ssc install dataex
   
2. clear
   
3. input str6 gdStkcd str10 Reptdt double 净利润
   
4. "600893" "1998-06-30"    6616438.76
   
5. "600893" "1998-12-31"    22919342.5
   
6. "600893" "1999-06-30"    16593076.3
   
7. "600893" "1999-12-31"    7222111.42
   
8. "600893" "2000-06-30"  -29633045.63
   
9. "600893" "2000-12-31"   -8388671.41
   
10. "600893" "2001-06-30"  -28188220.72
    
11. "600893" "2001-12-31" -162261515.41
    
12. "600893" "2002-06-30"  -32841477.61
    
13. "600893" "2002-12-31"   40419105.45
    
14. "600893" "2003-06-30"   28584613.64
    
15. "600893" "2003-12-31"   47113768.87
    
16. "600893" "2004-06-30"   40345880.47
    
17. "600893" "2004-12-31"   37577781.18
    
18. "600893" "2005-06-30"   22042008.94
    
19. "600893" "2005-12-31"    23883780.5
    
20. "600893" "2006-06-30"   21904651.47
    
21. "600893" "2006-12-31"   26398804.04
    
22. "600893" "2007-06-30"   42473478.75
    
23. "600893" "2007-12-31"   47864656.26
    
24. "600893" "2008-06-30"   41745746.65
    
25. "600893" "2008-12-31"  129990149.09
    
26. "600893" "2009-01-01"  129990149.09
    
27. "600893" "2009-03-31"   19218367.45
    
28. "600893" "2009-06-30"   72015056.65
    
29. "600893" "2009-09-30"  102973787.32
    
30. "600893" "2009-12-31"  164098566.17
    
31. "600893" "2010-01-01"  164098566.17
    
32. "600893" "2010-03-31"   30598671.89
    
33. "600893" "2010-06-30"   90052549.29
    
34. "600893" "2010-09-30"  145031637.66
    
35. "600893" "2010-12-31"  219644111.15
    
36. "600893" "2011-01-01"  219644111.15
    
37. "600893" "2011-03-31"   39832667.03
    
38. "600893" "2011-06-30"  116471870.24
    
39. "600893" "2011-09-30"   177771378.6
    
40. "600893" "2011-12-31"  252748796.52
    
41. "600893" "2012-01-01"  252748796.52
    
42. "600893" "2012-03-31"   43819404.83
    
43. "600893" "2012-06-30"   93227357.91
    
44. "600893" "2012-09-30"  183514052.95
    
45. "600893" "2012-12-31"  284165431.89
    
46. "600893" "2013-01-01"  284165431.89
    
47. "600893" "2013-03-31"   46434683.33
    
48. "600893" "2013-06-30"  123686781.82
    
49. "600893" "2013-09-30"  204495677.38
    
50. "600893" "2013-12-31"  329347575.08
    
51. "600893" "2014-01-01"  853643446.89
    
52. "600893" "2014-03-31"   63977516.57
    
53. "600893" "2014-06-30"  256990669.96
    
54. "600893" "2014-09-30"  497197656.35
    
55. "600893" "2014-12-31" 1001523995.79
    
56. "600893" "2015-01-01" 1001523995.79
    
57. "600893" "2015-03-31"  -45651497.15
    
58. "600893" "2015-06-30"  379613983.33
    
59. "600893" "2015-09-30"  526718747.92
    
60. "600893" "2015-12-31"  1075869439.3
    
61. "600893" "2016-01-01"  1075869439.3
    
62. "600893" "2016-03-31"  -99355764.73
    
63. "600893" "2016-06-30"   113795815.3
    
64. "600893" "2016-09-30"  348142320.17
    
65. "600893" "2016-12-31"  915998760.78
    
66. "600893" "2017-01-01"  915998760.78
    
67. "600893" "2017-03-31"  -92992449.41
    
68. "600893" "2017-06-30"  158139900.07
    
69. "600893" "2017-09-30"  376429319.66
    
70. "600893" "2017-12-31"  935343768.02
    
71. "600893" "2018-01-01"  935343768.02
    
72. "600893" "2018-03-31"  -50182860.33
    
73. "600893" "2018-06-30"  372090455.22
    
74. "600893" "2018-09-30"  671628987.11
    
75. "600893" "2018-12-31" 1083551078.46
    
76. "600893" "2019-03-31"    9587465.94
    
77. "600893" "2019-06-30"  339838714.46
    
78. "600893" "2019-09-30"  453361546.98
    
79. end

复制代码

------------------ copy up to and including the previous line ------------------
非常感谢！

黃河泉 发表于 2020-1-6 17:03
你若要问程序，永远附上相关资料 (请不要用截图)；若附上资料，永远用 dataex 印出资料。
•        先 ssc  ...

黄老师，您好！相关资料如下
----------------------- copy starting from the next line -----------------------

1. * Example generated by -dataex-. To install: ssc install dataex
   
2. clear
   
3. input str6 gdStkcd str10 Reptdt double 净利润
   
4. "600893" "1998-06-30"    6616438.76
   
5. "600893" "1998-12-31"    22919342.5
   
6. "600893" "1999-06-30"    16593076.3
   
7. "600893" "1999-12-31"    7222111.42
   
8. "600893" "2000-06-30"  -29633045.63
   
9. "600893" "2000-12-31"   -8388671.41
   
10. "600893" "2001-06-30"  -28188220.72
    
11. "600893" "2001-12-31" -162261515.41
    
12. "600893" "2002-06-30"  -32841477.61
    
13. "600893" "2002-12-31"   40419105.45
    
14. "600893" "2003-06-30"   28584613.64
    
15. "600893" "2003-12-31"   47113768.87
    
16. "600893" "2004-06-30"   40345880.47
    
17. "600893" "2004-12-31"   37577781.18
    
18. "600893" "2005-06-30"   22042008.94
    
19. "600893" "2005-12-31"    23883780.5
    
20. "600893" "2006-06-30"   21904651.47
    
21. "600893" "2006-12-31"   26398804.04
    
22. "600893" "2007-06-30"   42473478.75
    
23. "600893" "2007-12-31"   47864656.26
    
24. "600893" "2008-06-30"   41745746.65
    
25. "600893" "2008-12-31"  129990149.09
    
26. "600893" "2009-01-01"  129990149.09
    
27. "600893" "2009-03-31"   19218367.45
    
28. "600893" "2009-06-30"   72015056.65
    
29. "600893" "2009-09-30"  102973787.32
    
30. "600893" "2009-12-31"  164098566.17
    
31. "600893" "2010-01-01"  164098566.17
    
32. "600893" "2010-03-31"   30598671.89
    
33. "600893" "2010-06-30"   90052549.29
    
34. "600893" "2010-09-30"  145031637.66
    
35. "600893" "2010-12-31"  219644111.15
    
36. "600893" "2011-01-01"  219644111.15
    
37. "600893" "2011-03-31"   39832667.03
    
38. "600893" "2011-06-30"  116471870.24
    
39. "600893" "2011-09-30"   177771378.6
    
40. "600893" "2011-12-31"  252748796.52
    
41. "600893" "2012-01-01"  252748796.52
    
42. "600893" "2012-03-31"   43819404.83
    
43. "600893" "2012-06-30"   93227357.91
    
44. "600893" "2012-09-30"  183514052.95
    
45. "600893" "2012-12-31"  284165431.89
    
46. "600893" "2013-01-01"  284165431.89
    
47. "600893" "2013-03-31"   46434683.33
    
48. "600893" "2013-06-30"  123686781.82
    
49. "600893" "2013-09-30"  204495677.38
    
50. "600893" "2013-12-31"  329347575.08
    
51. "600893" "2014-01-01"  853643446.89
    
52. "600893" "2014-03-31"   63977516.57
    
53. "600893" "2014-06-30"  256990669.96
    
54. "600893" "2014-09-30"  497197656.35
    
55. "600893" "2014-12-31" 1001523995.79
    
56. "600893" "2015-01-01" 1001523995.79
    
57. "600893" "2015-03-31"  -45651497.15
    
58. "600893" "2015-06-30"  379613983.33
    
59. "600893" "2015-09-30"  526718747.92
    
60. "600893" "2015-12-31"  1075869439.3
    
61. "600893" "2016-01-01"  1075869439.3
    
62. "600893" "2016-03-31"  -99355764.73
    
63. "600893" "2016-06-30"   113795815.3
    
64. "600893" "2016-09-30"  348142320.17
    
65. "600893" "2016-12-31"  915998760.78
    
66. "600893" "2017-01-01"  915998760.78
    
67. "600893" "2017-03-31"  -92992449.41
    
68. "600893" "2017-06-30"  158139900.07
    
69. "600893" "2017-09-30"  376429319.66
    
70. "600893" "2017-12-31"  935343768.02
    
71. "600893" "2018-01-01"  935343768.02
    
72. "600893" "2018-03-31"  -50182860.33
    
73. "600893" "2018-06-30"  372090455.22
    
74. "600893" "2018-09-30"  671628987.11
    
75. "600893" "2018-12-31" 1083551078.46
    
76. "600893" "2019-03-31"    9587465.94
    
77. "600893" "2019-06-30"  339838714.46
    
78. "600893" "2019-09-30"  453361546.98
    
79. end

复制代码

------------------ copy up to and including the previous line ------------------

黃河泉 发表于 2020-1-6 17:03
你若要问程序，永远附上相关资料 (请不要用截图)；若附上资料，永远用 dataex 印出资料。
•        先 ssc  ...

黄老师，我附上了相关资料，抱歉给你添麻烦了，刚刚用您的命令导出数据的时候，因为原数据包含所有上市公司，只有100个数据被导出来，所以导出来的数据全部成不同公司同一个年份的数据了，所以我就想着保留三个公司的数据，用keep if gdStkcd=="900937"|"900941"|"600762"，结果stata报错说type mismatch。请问相同时保留三家以上的公司，应该如何写命令，十分非感谢黄老师！

墨韵瑶台 发表于 2020-1-9 17:51
黄老师，我附上了相关资料，抱歉给你添麻烦了，刚刚用您的命令导出数据的时候，因为原数据包含所有上市公 ...

你的資料混杂了"季"与"半年"资料 (分界点 2009 年)。

1. encode Reptdt , generate(date)
   
2. encode gdStkcd , generate(id)
   
3. 
   
4. // 把字符串日期转换为数值型
   
5. gen ymd = date(Reptdt, "YMD")  
   
6. format ymd %td
   
7. 
   
8. gen yt = year(ymd)    // 提取年份
   
9. gen mt = month(ymd)   // 提取月份
   
10. 
    
11. keep if mt == 6 | mt == 12  // 删掉1月、9月数据  ，这里不确定对不对？
    
12. 
    
13. // 6月看作上半年、12月看作下半年
    
14. gen halfyearid = 1
    
15. replace halfyearid = 2 if mt == 12
    
16. 
    
17. // 用年和半年时间id合成半年时间
    
18. gen myhalfyear =yh(yt, halfyearid)   
    
19. format myhalfyear %th
    
20. 
    
21. xtset id myhalfyear

复制代码

黃河泉 发表于 2020-1-9 18:12
你的資料混杂了"季"与"半年"资料 (分界点 2009 年)。

1. * Example generated by -dataex-. To install: ssc install dataex
   
2. clear
   
3. input str6 gdStkcd str10 Reptdt double 净利润
   
4. "600762" "1998-06-30"    -4298571.83
   
5. "600762" "1998-12-31"   -66375548.99
   
6. "600762" "1999-06-30"    -8655894.91
   
7. "600762" "1999-12-31"    -54590165.1
   
8. "600762" "2000-06-30"     4350433.02
   
9. "600762" "2000-12-31"     9441165.36
   
10. "600762" "2001-06-30"    14781637.12
    
11. "600762" "2001-12-31"    32709692.87
    
12. "600762" "2002-06-30"    16430562.58
    
13. "600762" "2002-12-31"    25345738.82
    
14. "600762" "2003-06-30"    10270468.12
    
15. "600762" "2003-12-31"    18165488.36
    
16. "600762" "2004-06-30"     8899868.39
    
17. "600762" "2004-12-31"   -74583911.29
    
18. "600762" "2005-06-30"   -24887451.56
    
19. "600762" "2005-12-31"     -142302456
    
20. "600762" "2006-06-30"   -28025299.41
    
21. "600762" "2006-12-31"     6383679.71
    
22. "600762" "2007-06-30"   -11394306.43
    
23. "900937" "1998-06-30"    131920384.9
    
24. "900937" "1998-12-31"   235140795.91
    
25. "900937" "1999-06-30"   135859688.49
    
26. "900937" "1999-12-31"   184128143.51
    
27. "900937" "2000-06-30"   141600067.03
    
28. "900937" "2000-12-31"   224700163.51
    
29. "900937" "2001-06-30"   115836826.04
    
30. "900937" "2001-12-31"   281812597.68
    
31. "900937" "2002-06-30"   136145557.19
    
32. "900937" "2002-12-31"   249250818.73
    
33. "900937" "2003-06-30"   107557609.64
    
34. "900937" "2003-12-31"   201371368.77
    
35. "900937" "2004-06-30"   120260479.13
    
36. "900937" "2004-12-31"   255046022.69
    
37. "900937" "2005-06-30"    30087790.72
    
38. "900937" "2005-12-31"   125631458.89
    
39. "900937" "2006-06-30"    58182533.43
    
40. "900937" "2006-12-31"   127620093.93
    
41. "900937" "2007-06-30"    31430205.15
    
42. "900937" "2007-12-31"    49873843.31
    
43. "900937" "2008-06-30"   -15854191.98
    
44. "900937" "2008-12-31"    28583455.15
    
45. "900937" "2009-06-30"  -151457065.22
    
46. "900937" "2009-12-31"  -796485413.64
    
47. "900937" "2010-06-30"  -166777973.36
    
48. "900937" "2010-12-31"     4416281.27
    
49. "900937" "2011-06-30"  -336178607.26
    
50. "900937" "2011-12-31"    49110405.22
    
51. "900937" "2012-06-30"  -187710129.99
    
52. "900937" "2012-12-31"  -448885208.16
    
53. "900937" "2013-06-30"    13302234.66
    
54. "900937" "2013-12-31"    50960853.04
    
55. "900937" "2014-06-30"   300292047.88
    
56. "900937" "2014-12-31"   158081806.78
    
57. "900937" "2015-06-30"   283084527.85
    
58. "900937" "2015-12-31"    27633528.52
    
59. "900937" "2016-06-30"   384325189.87
    
60. "900937" "2016-12-31"   172230915.19
    
61. "900937" "2017-06-30"   135700133.27
    
62. "900937" "2017-12-31" -1204701562.36
    
63. "900937" "2018-06-30"   -53202175.08
    
64. "900937" "2018-12-31"  -881309653.04
    
65. "900937" "2019-06-30"    24249702.53
    
66. "900941" "1998-06-30"   171615073.05
    
67. "900941" "1998-12-31"   237238394.72
    
68. "900941" "1999-06-30"   128781607.36
    
69. "900941" "1999-12-31"   295242024.38
    
70. "900941" "2000-06-30"   180313154.87
    
71. "900941" "2000-12-31"   330004175.36
    
72. "900941" "2001-06-30"   107510346.51
    
73. "900941" "2001-12-31"   220761047.01
    
74. "900941" "2002-06-30"    73257411.23
    
75. "900941" "2002-12-31"  -184170349.13
    
76. "900941" "2003-06-30"   -662895213.1
    
77. "900941" "2003-12-31" -1195556372.65
    
78. "900941" "2004-06-30"    29990125.23
    
79. "900941" "2004-12-31"    51561966.26
    
80. "900941" "2005-06-30"   -54621851.64
    
81. "900941" "2005-12-31"  -270470124.67
    
82. "900941" "2006-06-30"    26470459.36
    
83. "900941" "2006-12-31"    69066625.14
    
84. "900941" "2007-06-30"    52009196.03
    
85. "900941" "2007-12-31"   201292365.87
    
86. "900941" "2008-06-30"    41665179.74
    
87. "900941" "2008-12-31"    103602694.3
    
88. "900941" "2009-06-30"    37675467.28
    
89. "900941" "2009-12-31"   104874790.46
    
90. "900941" "2010-06-30"    57902059.68
    
91. "900941" "2010-12-31"   168110231.44
    
92. "900941" "2011-06-30"    93524527.66
    
93. "900941" "2011-12-31"   193876912.41
    
94. "900941" "2012-06-30"    69102880.62
    
95. "900941" "2012-12-31"   192482046.89
    
96. "900941" "2013-06-30"    93417250.83
    
97. "900941" "2013-12-31"   208396017.32
    
98. "900941" "2014-06-30"    62184295.08
    
99. "900941" "2014-12-31"   177253788.76
    
100. "900941" "2015-06-30"    75397253.38
     
101. "900941" "2015-12-31"   169336339.96
     
102. "900941" "2016-06-30"    49267365.29
     
103. "900941" "2016-12-31"    92272567.09
     
104. end

复制代码

dlut123 发表于 2020-1-9 19:57
encode Reptdt , generate(date)
encode gdStkcd , generate(id)

非常感谢大神！您的代码非常好用，已经解决啦！

dlut123 发表于 2020-1-9 19:57

哭了呀找了一晚上终于找到能解决的大神了