全部版块 我的主页
论坛 计量经济学与统计论坛 五区 计量经济学与统计软件 Stata专版
1102 2
2020-08-15
* Example generated by -dataex-. To install: ssc install dataex
clear
input str6 Stkcd str10(Rptdt Fenddt) str134 AnanmID float(forecastterm super_pre group)
"000538" "2008-04-09" "2008-12-31" "30000000000000009207" 1 0 14
"000538" "2008-04-28" "2008-12-31" "30000000000000009207" 1 0 14
"000538" "2008-05-20" "2008-12-31" "30000000000000009207" 1 0 14
"000538" "2008-08-12" "2008-12-31" "30000000000000009207" 1 0 14
"000538" "2008-08-28" "2008-12-31" "30000000000000009207" 1 0 14
"000538" "2008-10-24" "2008-12-31" "30000000000000009207" 1 1 14
"000538" "2007-05-19" "2008-12-31" "30000000000000009207" 2 0 15
"000538" "2007-10-26" "2008-12-31" "30000000000000009207" 2 0 15
"000538" "2009-05-18" "2009-12-31" "30000000000000009207" 1 0 16
"000538" "2008-04-09" "2009-12-31" "30000000000000009207" 2 1 17
"000538" "2008-04-28" "2009-12-31" "30000000000000009207" 2 1 17
"000538" "2008-05-20" "2009-12-31" "30000000000000009207" 2 1 17
"000538" "2008-08-12" "2009-12-31" "30000000000000009207" 2 1 17
"000538" "2008-08-28" "2009-12-31" "30000000000000009207" 2 1 17
"000538" "2008-10-24" "2009-12-31" "30000000000000009207" 2 1 17
end


想请问如何求   在同一group,以某一时点往前一年内,有多少个连续的super_pre==1,将其生成一个新的变量
感谢!!

二维码

扫码加我 拉你入群

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

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

全部回复
2020-8-15 16:56:23
比如说,group17中,第一行有连续一个,第二行有连续两个,第三行有连续三个
二维码

扫码加我 拉你入群

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

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

2020-8-16 07:20:11
Izabella00 发表于 2020-8-15 16:56
比如说,group17中,第一行有连续一个,第二行有连续两个,第三行有连续三个
就目前资料而言,似乎可以
复制代码
但我猜测你发的资料"不具代表性",可能会出现不是你要的结果!
二维码

扫码加我 拉你入群

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

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

相关推荐
栏目导航
热门文章
推荐文章

说点什么

分享

扫码加好友,拉您进群
各岗位、行业、专业交流群