stata数据日期的年月日分离问题

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

我将锐思数据库下载下来的excel数据直接导入stata14，日期呈现30Jan2010的形式，为数值型数据，不知道如何分离出年份与月份？请各位前辈和老师指教～

. dataex Stkcd Accper 机构投资者持有A股比例_TotInsHoldperA in 1/20

----------------------- copy starting from the next line -----------------------
[CODE]
* Example generated by -dataex-. To install: ssc install dataex
clear
input str6 Stkcd int Accper double 机构投资者持有A股比例_TotInsHoldperA
"000002" 15156 .099051
"000002" 15340 .131773
"000002" 15521 .135864
"000002" 15613 .115236
"000002" 15705 .145403
"000002" 15886 .070986
"000002" 16070 .167411
"000002" 16252 .267346
"000002" 16344 .237202
"000002" 16436 .396038
"000002" 16526 .246494
"000002" 16617  .29196
"000002" 16709 .133805
"000002" 16801 .375607
"000002" 16891 .336517
"000002" 16982 .209282
"000002" 17074 .259574
"000002" 17166 .375594
"000002" 17256 .312577
"000002" 17347 .412371
end
format %td Accper
[/CODE]
------------------ copy up to and including the previous line ------------------

Listed 20 out of 60000 observations

扫码加我 拉你入群

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

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

分享0 收藏0 回帖