stata年月日如何转换为年月

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

目前有数值型和字符型的年月日数据，也有单独的年和月的数据，但是后期需要用“年月”的数据取滞后项做格兰杰检验，所以求助一个把年月日拆分为年月、或者把单独的年和月合并成年月（可用来做面板，取滞后项）的日期。需要分类的变量为RetHold,其他变量及数据如下，感谢！

1. * Example generated by -dataex-. To install: ssc install dataex
   
2. clear
   
3. input str10 trddt float(date year month Rethold)
   
4. "2017-01-03" 20822 2017 3 .4745918
   
5. "2017-01-04" 20823 2017 3 .4745918
   
6. "2017-01-05" 20824 2017 3 .4745918
   
7. "2017-01-06" 20825 2017 3 .4745918
   
8. "2017-01-09" 20828 2017 3 .4745918
   
9. "2017-01-10" 20829 2017 3 .4745918
   
10. "2017-01-11" 20830 2017 3 .4745918
    
11. "2017-01-13" 20832 2017 3 .4745918
    
12. "2017-01-16" 20835 2017 3 .4745918
    
13. "2017-01-17" 20836 2017 3 .4745918
    
14. "2017-01-18" 20837 2017 3 .4745918
    
15. "2017-01-19" 20838 2017 3 .4745918
    
16. "2017-01-20" 20839 2017 3 .4745918
    
17. "2017-01-23" 20842 2017 3 .4745918
    
18. "2017-01-24" 20843 2017 3 .4745918
    
19. "2017-01-25" 20844 2017 3 .4745918
    
20. "2017-01-26" 20845 2017 3 .4745918
    
21. "2017-02-03" 20853 2017 3 .4745918
    
22. "2017-02-06" 20856 2017 3 .4745918
    
23. "2017-02-07" 20857 2017 3 .4745918
    
24. "2017-02-08" 20858 2017 3 .4745918
    
25. "2017-02-09" 20859 2017 3 .4745918
    
26. "2017-02-10" 20860 2017 3 .4745918
    
27. "2017-02-13" 20863 2017 3 .4745918
    
28. "2017-02-14" 20864 2017 3 .4745918
    
29. "2017-02-15" 20865 2017 3 .4745918
    
30. "2017-02-16" 20866 2017 3 .4745918
    
31. "2017-02-17" 20867 2017 3 .4745918
    
32. "2017-02-20" 20870 2017 3 .4745918
    
33. "2017-02-21" 20871 2017 3 .4745918
    
34. "2017-02-22" 20872 2017 3 .4745918
    
35. "2017-02-23" 20873 2017 3 .4745918
    
36. "2017-02-24" 20874 2017 3 .4745918
    
37. "2017-02-27" 20877 2017 3 .4745918
    
38. "2017-02-28" 20878 2017 3 .4745918
    
39. "2017-03-01" 20879 2017 3 .4745918
    
40. "2017-03-02" 20880 2017 3 .4745918
    
41. "2017-03-03" 20881 2017 3 .4745918
    
42. "2017-03-06" 20884 2017 3 .4745918
    
43. "2017-03-07" 20885 2017 3 .4745918
    
44. "2017-03-08" 20886 2017 3 .4745918
    
45. "2017-03-09" 20887 2017 3 .4745918
    
46. "2017-03-10" 20888 2017 3 .4745918
    
47. "2017-03-13" 20891 2017 3 .4745918
    
48. "2017-03-14" 20892 2017 3 .4745918
    
49. "2017-03-15" 20893 2017 3 .4745918
    
50. "2017-03-16" 20894 2017 3 .4745918
    
51. "2017-03-17" 20895 2017 3 .4745918
    
52. "2017-03-20" 20898 2017 3 .4745918
    
53. "2017-03-21" 20899 2017 3 .4745918
    
54. "2017-03-22" 20900 2017 3 .4745918
    
55. "2017-03-23" 20901 2017 3 .4745918
    
56. "2017-03-24" 20902 2017 3 .4745918
    
57. "2017-03-27" 20905 2017 3 .4745918
    
58. "2017-03-28" 20906 2017 3 .4745918
    
59. "2017-03-29" 20907 2017 3 .4745918
    
60. "2017-03-30" 20908 2017 3 .4745918
    
61. "2017-03-31" 20909 2017 3 .4745918
    
62. "2017-04-05" 20914 2017 6 .3750323
    
63. "2017-04-06" 20915 2017 6 .3750323
    
64. "2017-04-07" 20916 2017 6 .3750323
    
65. "2017-04-10" 20919 2017 6 .3750323
    
66. "2017-04-11" 20920 2017 6 .3750323
    
67. "2017-04-12" 20921 2017 6 .3750323
    
68. "2017-04-13" 20922 2017 6 .3750323
    
69. "2017-04-14" 20923 2017 6 .3750323
    
70. "2017-04-17" 20926 2017 6 .3750323
    
71. "2017-04-18" 20927 2017 6 .3750323
    
72. "2017-04-19" 20928 2017 6 .3750323
    
73. "2017-04-20" 20929 2017 6 .3750323
    
74. "2017-04-21" 20930 2017 6 .3750323
    
75. "2017-04-24" 20933 2017 6 .3750323
    
76. "2017-04-25" 20934 2017 6 .3750323
    
77. "2017-04-26" 20935 2017 6 .3750323
    
78. "2017-04-27" 20936 2017 6 .3750323
    
79. "2017-04-28" 20937 2017 6 .3750323
    
80. "2017-05-02" 20941 2017 6 .3750323
    
81. "2017-05-03" 20942 2017 6 .3750323
    
82. "2017-05-04" 20943 2017 6 .3750323
    
83. "2017-05-05" 20944 2017 6 .3750323
    
84. "2017-05-08" 20947 2017 6 .3750323
    
85. "2017-05-09" 20948 2017 6 .3750323
    
86. "2017-05-10" 20949 2017 6 .3750323
    
87. "2017-05-11" 20950 2017 6 .3750323
    
88. "2017-05-12" 20951 2017 6 .3750323
    
89. "2017-05-15" 20954 2017 6 .3750323
    
90. "2017-05-16" 20955 2017 6 .3750323
    
91. "2017-05-17" 20956 2017 6 .3750323
    
92. "2017-05-18" 20957 2017 6 .3750323
    
93. "2017-05-19" 20958 2017 6 .3750323
    
94. "2017-05-22" 20961 2017 6 .3750323
    
95. "2017-05-23" 20962 2017 6 .3750323
    
96. "2017-05-24" 20963 2017 6 .3750323
    
97. "2017-05-25" 20964 2017 6 .3750323
    
98. "2017-05-26" 20965 2017 6 .3750323
    
99. "2017-05-31" 20970 2017 6 .3750323
    
100. "2017-06-01" 20971 2017 6 .3750323
     
101. "2017-06-02" 20972 2017 6 .3750323
     
102. "2017-06-05" 20975 2017 6 .3750323
     
103. "2017-06-06" 20976 2017 6 .3750323
     
104. end
     
105. format %td date

复制代码

扫码加我 拉你入群

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

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

分享0 收藏0 回帖

关键词：Stata tata 年月日 generated generate 日期变量

感谢用 dataex 提供数据，请试试

1. gen wanted1 = mofd(date)
   
2. format wanted1 %tm

复制代码

黃河泉 发表于 2021-7-12 10:56
感谢用 dataex 提供数据，请试试

感谢黄老师的帮助！问题已解决~