stata求某一时点前连续数值的个数

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

* 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，将其生成一个新的变量
感谢！！

扫码加我 拉你入群

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

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

分享0 收藏0 回帖

关键词：Stata tata generated generate Forecast

比如说，group17中，第一行有连续一个，第二行有连续两个，第三行有连续三个

Izabella00 发表于 2020-8-15 16:56
比如说，group17中，第一行有连续一个，第二行有连续两个，第三行有连续三个

就目前资料而言，似乎可以

1. bys group: gen wanted = sum(super_pre)

复制代码

但我猜测你发的资料"不具代表性"，可能会出现不是你要的结果！