全部版块 我的主页
› 论坛 › 计量经济学与统计论坛 五区 › 计量经济学与统计软件 › Stata专版
求助大神：stata如何统计当年与往年对比新增加的观测值的数量
evamxn
2017 9
2022-04-30
求助各位大神：我在使用上市公司专利分类号(ipc)统计每年与往年相比新增的ipc类型的数量。比如如下数据，公司00001，2010年申请专利ipc号的类型有G06,G07; 2013年专利号与2010年相比，新增了H04这一类型，则2013年新增为1；2016年与2010、2013年相比没有新增ipc类型，则新增为0。其他公司也是一样的。求教代码应该如何编写？万分感谢！
数据如下：clear
input str12 symbol float year str3 ipc
"000001" 2010 "G06"
"000001" 2010 "G06"
"000001" 2010 "G07"
"000001" 2013 "H04"
"000001" 2013 "G06"
"000001" 2013 "G07"
"000001" 2013 "H04"
"000001" 2013 "G06"
"000001" 2013 "G06"
"000001" 2013 "G06"
"000001" 2016 "G06"
"000001" 2016 "G06"
"000001" 2017 "G06"
"000001" 2017 "G06"
"000001" 2017 "G06"
"000001" 2017 "G06"
"000001" 2017 "H04"
"000001" 2017 "G06"
"000001" 2017 "G06"
"000001" 2017 "G06"
"000001" 2017 "G06"
"000001" 2017 "G06"
"000002" 2002 "E04"
"000002" 2002 "E04"
"000002" 2004 "E06"
"000002" 2004 "A47"
"000002" 2004 "E04"
"000002" 2004 "E06"
"000002" 2004 "E06"
"000002" 2004 "A47"
end





二维码

扫码加我 拉你入群

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

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

全部回复
雨天的幸福
2022-5-1 10:57:19
现在还需要吗？我或许可以帮你
二维码

扫码加我 拉你入群

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

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

evamxn
2022-5-1 11:13:19
雨天的幸福 发表于 2022-5-1 10:57
现在还需要吗？我或许可以帮你
需要需要，求助～
二维码

扫码加我 拉你入群

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

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

黃河泉
2022-5-1 21:25:30
根据
复制代码
Øyvind Snilsberg 之建议：
二维码

扫码加我 拉你入群

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

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

evamxn
2022-5-4 10:30:30
黃河泉 发表于 2022-5-1 21:25
根据Øyvind Snilsberg 之建议：
非常感谢黄老师的帮助
黄老师，想再请教您一个问题，如果我想统计过去5年新增的ipc数量，比如，2006年统计2002-2006年的新增ipc数量，2007年统计2003-2007年新增ipc数量，以此类推。应该怎么进一步编辑代码呢？数据如下：
clear
input str6 stkcd str4 year str3 ipc_3
"000002" "2002" "E04"
"000002" "2002" "E04"
"000002" "2004" "A47"
"000002" "2004" "E04"
"000002" "2004" "E04"
"000002" "2004" "E04"
"000002" "2004" "E06"
"000002" "2004" "E04"
"000002" "2004" "E04"
"000002" "2004" "E06"
"000002" "2004" "E04"
"000002" "2004" "E04"
"000002" "2004" "E04"
"000002" "2005" "A01"
"000002" "2005" "E04"
"000002" "2005" "E04"
"000002" "2005" "E06"
"000002" "2005" "E05"
"000002" "2005" "E04"
"000002" "2005" "F23"
"000002" "2006" "A47"
"000002" "2006" "A47"
"000002" "2006" "A47"
"000002" "2006" "B65"
"000002" "2006" "A47"
"000002" "2006" "A01"
"000002" "2006" "A47"
"000002" "2006" "D06"
"000002" "2006" "E03"
"000002" "2006" "A47"
"000002" "2006" "B65"
"000002" "2006" "A47"
"000002" "2006" "D06"
"000002" "2006" "A47"
"000002" "2006" "A47"
"000002" "2006" "A47"
"000002" "2006" "A47"
"000002" "2006" "A47"
"000002" "2006" "A47"
"000002" "2006" "E04"
"000002" "2006" "A01"
"000002" "2006" "D06"
"000002" "2006" "A47"
"000002" "2006" "A01"
"000002" "2006" "E04"
"000002" "2006" "A47"
"000002" "2006" "A47"
"000002" "2006" "A47"
"000002" "2006" "D06"
"000002" "2006" "A47"
"000002" "2006" "A47"
"000002" "2006" "A47"
"000002" "2006" "D06"
"000002" "2006" "A47"
"000002" "2006" "A47"
"000002" "2006" "D06"
"000002" "2006" "A47"
"000002" "2006" "A47"
"000002" "2006" "A47"
"000002" "2006" "D06"
"000002" "2006" "A47"
"000002" "2007" "E04"
"000002" "2008" "E04"
"000002" "2008" "E04"
"000002" "2008" "E04"
"000002" "2008" "E04"
"000002" "2008" "E04"
"000002" "2008" "E04"
"000002" "2008" "E04"
"000002" "2008" "E04"
"000002" "2008" "E04"
"000002" "2008" "B28"
"000002" "2008" "E04"
"000002" "2008" "B28"
"000002" "2008" "E04"
"000002" "2008" "E04"
"000002" "2008" "B28"
"000002" "2008" "E04"
"000002" "2008" "E04"
"000002" "2008" "E04"
"000002" "2008" "E04"
"000002" "2008" "E04"
"000002" "2009" "G10"
"000002" "2009" "H03"
"000002" "2009" "H05"
"000002" "2009" "A01"
"000002" "2009" "E04"
"000002" "2009" "E04"
"000002" "2009" "B26"
"000002" "2010" "E04"
"000002" "2010" "E04"
"000002" "2010" "E04"
"000002" "2010" "E04"
"000002" "2010" "E04"
"000002" "2010" "E04"
"000002" "2010" "E04"
"000002" "2010" "E04"
"000002" "2010" "B65"
"000002" "2010" "E04"
"000002" "2010" "E04"
end
二维码

扫码加我 拉你入群

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

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

黃河泉
2022-5-5 07:43:04
evamxn 发表于 2022-5-4 10:30
非常感谢黄老师的帮助
黄老师，想再请教您一个问题，如果我想统计过去5年新增的ipc数量，比如，20 ...
请 ssc install rang
复制代码
estat 并据以更改：
二维码

扫码加我 拉你入群

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

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

点击查看更多内容…
相关推荐
栏目导航
热门文章
推荐文章

说点什么

分享

微信QQ空间QQ微博
扫码加好友，拉您进群
各岗位、行业、专业交流群