stata中merge问题，求帮助

994

收藏 2023-06-22

主表
证券代码 ID year lnTurnover Digital
......
000004 000004 2019 3.332205
000004 000004 2020 2.646882 4.29046
000004 000004 2021 1.818192 4.304065
000004 000004 2022 4.506869 4.094345
000006 000006 2017 -1.210655 1.098612
000006 000006 2018 -1.431853 0
000006 000006 2019 -1.359232 0
000006 000006 2020 -1.60449 0
000006 000006 2021 -2.221872 0
000006 000006 2022 -2.00397 0
000007 000007 2010 .4820601 0
000007 000007 2011 .5842364 0
000007 000007 2012 2.224566 0
000007 000007 2013 1.399116 0
000007 000007 2014 1.700301 1.94591
000007 000007 2015 .3382186 2.772589
000007 000007 2016 -.1276811 2.639057
000007 000007 2017 4.635789 2.302585
000007 000007 2018 4.818841 1.386294
000007 000007 2019 4.579547 .6931472
000007 000007 2020 2.176139 1.098612
000007 000007 2021 1.638148 .6931472
000007 000007 2022 1.690602 1.098612
........

(部分表格)

using表
证券代码 year 统计截止日期
000004 2021 2021-12-31
000008 2016 2016-12-31
000008 2017 2017-12-31
000008 2017 2017-12-31
000008 2018 2018-12-31
000008 2018 2018-12-31
000008 2019 2019-12-31
000008 2019 2019-12-31

出现问题：
·use "C:\Users\肖琪\Desktop\期末\3-数据处理\merge1.0.dta", clear
. merge 1:1 year 证券代码 using "C:\Users\肖琪\Desktop\期末\2-清洗后原始数据\lnTECH.dta"
variables year 证券代码 do not uniquely identify observations in the using data r(459);

请问怎么解决？