Help with command countmatch

Mabel Costa

Join Date: Oct 2017

Posts: 25
#1

Help with command countmatch

03 Jun 2025, 10:51

Dear Stata Users,

I am using the command countmatch and my variable is numeric. The command is as follows -

countmatch ANALYS1 ANALYS2, by(id) gen(count)

However, I would like to put double/two conditions/restrictions as follows -

countmatch ANALYS1 ANALYS2, by(id year) gen(varname)

Unfortunately, countmatch does not work with two restrictions. Someone please help/suggest an alternative command for this.

Thank you.
Tags: None
Nick Cox

Join Date: Mar 2014

Posts: 35681
#2

03 Jun 2025, 11:40

countmatch is from SSC and was last revised (by me) in 2006. I don't remember much about it at all, but I think you've unearthed a bug, so I will have a look.
Comment
Hemanshu Kumar

Join Date: Mar 2015

Posts: 1387
#3

03 Jun 2025, 15:35

I agree that OP seems to have found a bug in countmatch. Specifically, the problematic line in countmatch.ado is #56,

Code:

count if `var1'[`j'] == `var2' & `BY' == `BY'[`j']

which of course breaks if there is more than one by variable.

Until Nick finds time to fix the code, I thought I would suggest a simple workaround that OP can use. Just do something like:

Code:

egen by_group = group(id year) countmatch ANALYS1 ANALYS2, by(by_group) gen(varname)
2 likes
Comment
Mabel Costa

Join Date: Oct 2017

Posts: 25
#4

04 Jun 2025, 04:38

Hi Hemanshu Kumar, thank you for your suggestion. I will try your suggested code.

Nick Cox Thank you for getting back. Yes if you have time to fix the code, I am sure that would help all the users in the future.
Comment
Nick Cox

Join Date: Mar 2014

Posts: 35681
#5

05 Jun 2025, 11:53

I haven't forgotten this thread but while I've looked at countmatch again, I am having a hard time working out whether it's doing something worth doing and/or it needs to be rewritten anyway. .

All the original posts on Statalist before the 2006 version have long since disappeared.

Certainly, countmatch has a bug, which should be fixed, and the pessimistic take is that I may just remove code that doesn't do what is claimed.

Several threads here since 2014 point to rangestat (SSC) as an alternative.

So, Mabel Costa, a question back to you is also what do you want to do with it? Please give a simple but reproducible data example as well as example results you want to see. My optimistic take is that there are easier solutions for your problem.
1 like
Comment
Mabel Costa

Join Date: Oct 2017

Posts: 25
#6

06 Jun 2025, 08:16

Hi Nick Cox

Thank you for your response on this post.

Please find a sample dataset below. My main variable was up to ANALYS2. I used the following commands to generate the string version

tostring ANALYS1, generate(ana1)
tostring ANALYS2, generate(ana2)

Gvkey is the unique company ID. ANALYS1 & ANALYS2 are unique analyst code. fyear is year.
ANALYS1 (ana1) is the analysts who follow the company, while ANALYS2 (ana2) is analysts who follow the peer company. So I am trying to find the Analyst who follows both companies, so in other words, for each company-year (gvkey fyear) find the matches in ANALYS1 that also appear in ANALYS2.

using countmatch ana1 ana2, by(gvkey) gen(count) I found the count, but I need for gvkey fyear so I used the code/solution suggested by Hemanshu as follows.

egen by_group = group(gvkey fyear)
countmatch ana1 ana2, by(by_group) gen(count2)

This has provided a partial solution. But in Row 11 of the data has a value of 4 for the variable count2. But I would like it to be 1, so the overlap of an analyst in ANALYS1 is matched only once (or first time) it appears in ANALYS2 for a given gvkey-fyear restriction.

I hope it clarifies your queries and will help me to provide advice or solution.

* Example generated by -dataex-. To install: ssc install dataex
clear
input long gvkey double(fyear ANALYS1 ANALYS2) str6(ana1 ana2) byte count float by_group byte count2
4066 2016 164392 . "164392" "." 5 1 0
4066 2016 125888 . "125888" "." 5 1 0
4066 2016 114980 . "114980" "." 4 1 0
4066 2016 47919 . "47919" "." 1 1 0
4066 2016 106603 . "106603" "." 7 1 0
4066 2016 164643 . "164643" "." 0 1 0
4066 2017 114980 40897 "114980" "40897" 4 2 1
4066 2017 119652 45722 "119652" "45722" 1 2 0
4066 2017 58895 47919 "58895" "47919" 5 2 1
4066 2017 83177 58895 "83177" "58895" 1 2 1
4066 2017 135522 80027 "135522" "80027" 7 2 4
4066 2017 106603 81118 "106603" "81118" 7 2 1
4066 2017 80027 82890 "80027" "82890" 3 2 1
4066 2017 128126 83177 "128126" "83177" 2 2 1
4066 2017 45722 106603 "45722" "106603" 1 2 1
4066 2017 133843 109283 "133843" "109283" 4 2 0
4066 2017 160058 114980 "160058" "114980" 0 2 0
4066 2017 47919 125888 "47919" "125888" 1 2 1
4066 2017 109283 126168 "109283" "126168" 5 2 1
4066 2017 186784 128126 "186784" "128126" 0 2 0
4066 2017 81118 135522 "81118" "135522" 5 2 1
4066 2017 170633 135522 "170633" "135522" 1 2 1
4066 2017 164392 135522 "164392" "135522" 5 2 1
4066 2017 82890 135522 "82890" "135522" 4 2 1
4066 2017 149618 149618 "149618" "149618" 2 2 1
4066 2017 125888 164392 "125888" "164392" 5 2 1
4066 2017 73590 170633 "73590" "170633" 2 2 0
4066 2018 106603 40897 "106603" "40897" 7 3 1
4066 2018 114980 49454 "114980" "49454" 4 3 1
4066 2018 191271 54310 "191271" "54310" 5 3 1
4066 2018 133843 58895 "133843" "58895" 4 3 1
4066 2018 125888 80027 "125888" "80027" 5 3 1
4066 2018 82890 81118 "82890" "81118" 4 3 1
4066 2018 58895 82890 "58895" "82890" 5 3 1
4066 2018 128126 106603 "128126" "106603" 2 3 1
4066 2018 119652 109283 "119652" "109283" 1 3 1
4066 2018 73590 114980 "73590" "114980" 2 3 0
4066 2018 49454 119652 "49454" "119652" 4 3 1
4066 2018 80027 125888 "80027" "125888" 3 3 1
4066 2018 135522 126168 "135522" "126168" 7 3 1
4066 2018 81118 128126 "81118" "128126" 5 3 1
4066 2018 54310 133843 "54310" "133843" 4 3 1
4066 2018 58895 135522 "58895" "135522" 5 3 1
4066 2018 109283 149618 "109283" "149618" 5 3 1
4066 2018 58895 164392 "58895" "164392" 5 3 1
4066 2018 164392 169920 "164392" "169920" 5 3 1
4066 2018 149618 191271 "149618" "191271" 2 3 1
4066 2019 191271 49454 "191271" "49454" 5 4 2
4066 2019 164392 54310 "164392" "54310" 5 4 1
4066 2019 82890 58895 "82890" "58895" 4 4 1
4066 2019 58895 80027 "58895" "80027" 5 4 1
4066 2019 133843 81118 "133843" "81118" 4 4 1
4066 2019 81118 82890 "81118" "82890" 5 4 1
4066 2019 49454 106603 "49454" "106603" 4 4 1
4066 2019 80027 109283 "80027" "109283" 3 4 1
4066 2019 73590 125888 "73590" "125888" 2 4 0
4066 2019 125888 133843 "125888" "133843" 5 4 1
4066 2019 109283 135522 "109283" "135522" 5 4 1
4066 2019 54310 164392 "54310" "164392" 4 4 1
4066 2019 106603 191271 "106603" "191271" 7 4 1
4066 2019 135522 191271 "135522" "191271" 7 4 1
4066 2020 49454 49454 "49454" "49454" 4 5 1
4066 2020 106603 54310 "106603" "54310" 7 5 1
4066 2020 58895 58895 "58895" "58895" 5 5 1
4066 2020 135522 73590 "135522" "73590" 7 5 1
4066 2020 81118 81118 "81118" "81118" 5 5 1
4066 2020 164392 82890 "164392" "82890" 5 5 1
4066 2020 54310 106603 "54310" "106603" 4 5 1
4066 2020 130988 109283 "130988" "109283" 1 5 1
4066 2020 109283 114980 "109283" "114980" 5 5 1
4066 2020 133843 125888 "133843" "125888" 4 5 1
4066 2020 125888 130988 "125888" "130988" 5 5 1
4066 2020 82890 133843 "82890" "133843" 4 5 1
4066 2020 191271 135522 "191271" "135522" 5 5 1
4066 2020 73590 164392 "73590" "164392" 2 5 1
4066 2020 169920 191271 "169920" "191271" 1 5 0
4066 2020 114980 191648 "114980" "191648" 4 5 1
4066 2021 133843 49454 "133843" "49454" 4 6 1
4066 2021 54310 54310 "54310" "54310" 4 6 1
4066 2021 194181 58895 "194181" "58895" 0 6 0
4066 2021 125888 73590 "125888" "73590" 5 6 1
4066 2021 81118 81118 "81118" "81118" 5 6 1
4066 2021 169920 106603 "169920" "106603" 1 6 0
4066 2021 109283 106603 "109283" "106603" 5 6 1
4066 2021 164392 106603 "164392" "106603" 5 6 1
4066 2021 114980 109283 "114980" "109283" 4 6 1
4066 2021 191271 114980 "191271" "114980" 5 6 1
4066 2021 130988 125888 "130988" "125888" 1 6 0
4066 2021 58895 133843 "58895" "133843" 5 6 1
4066 2021 106603 164392 "106603" "164392" 7 6 3
4066 2021 73590 191271 "73590" "191271" 2 6 1
4066 2021 49454 191648 "49454" "191648" 4 6 1
4094 2019 . 779 "." "779" 25 7 0
4094 2019 . 25262 "." "25262" 25 7 0
4094 2019 . 45396 "." "45396" 25 7 0
4094 2019 . 49454 "." "49454" 25 7 0
4094 2019 . 50004 "." "50004" 25 7 0
4094 2019 . 93125 "." "93125" 25 7 0
4094 2019 . 114289 "." "114289" 25 7 0
4094 2019 . 119652 "." "119652" 25 7 0
4094 2019 . 120964 "." "120964" 25 7 0
4094 2019 . 125271 "." "125271" 25 7 0
4094 2019 . 125558 "." "125558" 25 7 0
4094 2019 . 147210 "." "147210" 25 7 0
4094 2019 . 152918 "." "152918" 25 7 0
4094 2019 . 154817 "." "154817" 25 7 0
4094 2019 . 155160 "." "155160" 25 7 0
4094 2019 . 186094 "." "186094" 25 7 0
4094 2019 . 189214 "." "189214" 25 7 0
4094 2019 . 193672 "." "193672" 25 7 0
4094 2020 45396 . "45396" "." 1 8 0
4094 2020 125271 . "125271" "." 1 8 0
4094 2020 195226 . "195226" "." 0 8 0
4094 2020 122224 . "122224" "." 0 8 0
4094 2020 80903 . "80903" "." 0 8 0
4094 2020 185321 . "185321" "." 0 8 0
4094 2020 153502 . "153502" "." 0 8 0
4094 2020 86654 . "86654" "." 0 8 0
4094 2020 155160 . "155160" "." 1 8 0
4094 2020 43698 . "43698" "." 0 8 0
4094 2020 108389 . "108389" "." 0 8 0
4094 2021 155263 . "155263" "." 0 9 0
4094 2021 194592 . "194592" "." 0 9 0
4094 2021 45396 . "45396" "." 1 9 0
4094 2021 195226 . "195226" "." 0 9 0
4094 2021 125558 . "125558" "." 1 9 0
4094 2021 9913 . "9913" "." 0 9 0
4094 2021 122224 . "122224" "." 0 9 0
4094 2021 43698 . "43698" "." 0 9 0
4094 2021 80903 . "80903" "." 0 9 0
4094 2021 153502 . "153502" "." 0 9 0
4094 2021 86654 . "86654" "." 0 9 0
4094 2021 155160 . "155160" "." 1 9 0
4094 2021 185321 . "185321" "." 0 9 0
4094 2021 125271 . "125271" "." 1 9 0
4115 2014 50254 . "50254" "." 7 10 0
4115 2014 124719 . "124719" "." 9 10 0
4115 2014 130258 . "130258" "." 3 10 0
4115 2014 79979 . "79979" "." 0 10 0
4115 2014 75061 . "75061" "." 1 10 0
4115 2014 31893 . "31893" "." 1 10 0
4115 2014 121327 . "121327" "." 1 10 0
4115 2015 130258 31893 "130258" "31893" 3 11 1
4115 2015 50254 50254 "50254" "50254" 7 11 1
4115 2015 124719 82369 "124719" "82369" 9 11 1
4115 2015 75061 114113 "75061" "114113" 1 11 0
4115 2015 78363 121327 "78363" "121327" 0 11 0
4115 2015 121327 123211 "121327" "123211" 1 11 1
4115 2015 79979 124719 "79979" "124719" 0 11 0
4115 2015 31893 130258 "31893" "130258" 1 11 1
4115 2016 50254 . "50254" "." 7 12 0
4115 2016 31893 . "31893" "." 1 12 0
4115 2016 130258 . "130258" "." 3 12 0
4115 2016 82413 . "82413" "." 0 12 0
4115 2016 121327 . "121327" "." 1 12 0
4115 2016 75061 . "75061" "." 1 12 0
4115 2016 78363 . "78363" "." 0 12 0
4115 2016 79979 . "79979" "." 0 12 0
4115 2016 124719 . "124719" "." 9 12 0
4115 2016 80400 . "80400" "." 0 12 0
4115 2017 80400 . "80400" "." 0 13 0
4115 2017 82413 . "82413" "." 0 13 0
4115 2017 50254 . "50254" "." 7 13 0
4115 2017 75061 . "75061" "." 1 13 0
4115 2017 31893 . "31893" "." 1 13 0
4115 2017 130258 . "130258" "." 3 13 0
4115 2017 120240 . "120240" "." 1 13 0
4115 2017 124719 . "124719" "." 9 13 0
4115 2017 121327 . "121327" "." 1 13 0
4115 2017 78363 . "78363" "." 0 13 0
4115 2018 75061 . "75061" "." 1 14 0
4115 2018 124719 . "124719" "." 9 14 0
4115 2018 130258 . "130258" "." 3 14 0
4115 2018 121327 . "121327" "." 1 14 0
4115 2018 153273 . "153273" "." 2 14 0
4115 2018 50254 . "50254" "." 7 14 0
4115 2018 120240 . "120240" "." 1 14 0
4115 2018 82413 . "82413" "." 0 14 0
4115 2018 78363 . "78363" "." 0 14 0
4115 2018 80400 . "80400" "." 0 14 0
4115 2019 190605 50254 "190605" "50254" 1 15 1
4115 2019 82413 75061 "82413" "75061" 0 15 0
4115 2019 124719 82207 "124719" "82207" 9 15 1
4115 2019 50254 115741 "50254" "115741" 7 15 1
4115 2019 130258 120240 "130258" "120240" 3 15 1
4115 2019 80400 124719 "80400" "124719" 0 15 0
4115 2019 120240 130258 "120240" "130258" 1 15 1
4115 2019 121327 153273 "121327" "153273" 1 15 0
4115 2019 78363 160179 "78363" "160179" 0 15 0
4115 2019 75061 190605 "75061" "190605" 1 15 1
4115 2019 153273 191938 "153273" "191938" 2 15 1
4115 2020 115741 21008 "115741" "21008" 1 16 0
4115 2020 120240 50254 "120240" "50254" 1 16 0
4115 2020 130258 50254 "130258" "50254" 3 16 1
4115 2020 121327 50254 "121327" "50254" 1 16 0
4115 2020 75061 50254 "75061" "50254" 1 16 0
4115 2020 124719 50254 "124719" "50254" 9 16 0
4115 2020 191938 73734 "191938" "73734" 2 16 0
4115 2020 78363 82207 "78363" "82207" 0 16 0
4115 2020 190605 82369 "190605" "82369" 1 16 0
4115 2020 50254 130258 "50254" "130258" 7 16 5
4115 2020 153273 153273 "153273" "153273" 2 16 1
4115 2021 50254 82369 "50254" "82369" 7 17 0
4115 2021 130258 112249 "130258" "112249" 3 17 0
4115 2021 153273 124719 "153273" "124719" 2 17 0
4115 2021 185972 124719 "185972" "124719" 0 17 0
4115 2021 78363 124719 "78363" "124719" 0 17 0
4115 2021 124719 124719 "124719" "124719" 9 17 7
4115 2021 191938 124719 "191938" "124719" 2 17 1
4115 2021 75061 124719 "75061" "124719" 1 17 0
4115 2021 120240 124719 "120240" "124719" 1 17 0
4115 2021 190605 191938 "190605" "191938" 1 17 0
4115 2022 130258 . "130258" "." 3 18 0
4115 2022 50254 . "50254" "." 7 18 0
4115 2022 185972 . "185972" "." 0 18 0
4115 2022 75061 . "75061" "." 1 18 0
4115 2022 120240 . "120240" "." 1 18 0
4115 2022 124719 . "124719" "." 9 18 0
4115 2022 191938 . "191938" "." 2 18 0
4145 2003 73538 5546 "73538" "5546" 1 19 0
4145 2003 73538 7609 "73538" "7609" 1 19 0
4145 2003 73538 30330 "73538" "30330" 1 19 0
4145 2003 73538 58508 "73538" "58508" 1 19 0
4145 2003 20376 77577 "20376" "77577" 9 19 0
4145 2003 91719 78129 "91719" "78129" 0 19 0
4145 2003 73538 78346 "73538" "78346" 1 19 0
4145 2003 73538 79806 "73538" "79806" 1 19 0
4145 2003 52827 82988 "52827" "82988" 2 19 0
4145 2003 73538 83683 "73538" "83683" 1 19 0
4145 2003 73538 105782 "73538" "105782" 1 19 0
4145 2004 91719 5546 "91719" "5546" 0 20 0
4145 2004 73538 7609 "73538" "7609" 1 20 0
4145 2004 21145 8699 "21145" "8699" 0 20 0
4145 2004 20376 30330 "20376" "30330" 9 20 0
4145 2004 20376 77577 "20376" "77577" 9 20 0
4145 2004 20376 78129 "20376" "78129" 9 20 0
4145 2004 20376 78346 "20376" "78346" 9 20 0
4145 2004 20376 79806 "20376" "79806" 9 20 0
4145 2004 20376 80428 "20376" "80428" 9 20 0
4145 2004 20376 82988 "20376" "82988" 9 20 0
4145 2004 20376 83683 "20376" "83683" 9 20 0
4145 2004 52827 105782 "52827" "105782" 2 20 0
4145 2005 52827 5836 "52827" "5836" 2 21 0
4145 2005 20376 72765 "20376" "72765" 9 21 0
4145 2005 112085 73538 "112085" "73538" 12 21 0
4145 2005 73538 73595 "73538" "73595" 1 21 1
4145 2005 21145 73595 "21145" "73595" 0 21 0
4145 2005 91719 77577 "91719" "77577" 0 21 0
4145 2006 113984 20011 "113984" "20011" 0 22 0
4145 2006 20011 80730 "20011" "80730" 4 22 1
4145 2006 113834 113834 "113834" "113834" 7 22 7
4145 2006 52827 113834 "52827" "113834" 2 22 0
4145 2006 20376 113834 "20376" "113834" 9 22 0
4145 2006 110441 113834 "110441" "113834" 6 22 0
4145 2006 112085 113834 "112085" "113834" 12 22 0
4145 2006 91719 113834 "91719" "113834" 0 22 0
4145 2006 73538 113834 "73538" "113834" 1 22 0
4145 2007 20011 20011 "20011" "20011" 4 23 1
4145 2007 52827 20376 "52827" "20376" 2 23 1
4145 2007 110441 52827 "110441" "52827" 6 23 1
4145 2007 113984 107607 "113984" "107607" 0 23 0
4145 2007 73538 110441 "73538" "110441" 1 23 0
4145 2007 119484 112085 "119484" "112085" 7 23 0
4145 2007 20376 114669 "20376" "114669" 9 23 1
4145 2007 112085 118986 "112085" "118986" 12 23 1
4145 2008 112085 99673 "112085" "99673" 12 24 1
4145 2008 99673 110441 "99673" "110441" 10 24 1
4145 2008 119484 112085 "119484" "112085" 7 24 2
4145 2008 113984 114669 "113984" "114669" 0 24 0
4145 2008 110441 118986 "110441" "118986" 6 24 1
4145 2008 52827 119484 "52827" "119484" 2 24 0
4145 2008 20011 119484 "20011" "119484" 4 24 0
4145 2009 119484 107607 "119484" "107607" 7 25 1
4145 2009 130261 110441 "130261" "110441" 1 25 1
4145 2009 99673 112085 "99673" "112085" 10 25 0
4145 2009 112085 113956 "112085" "113956" 12 25 1
4145 2009 113956 119484 "113956" "119484" 2 25 1
4145 2009 110441 123423 "110441" "123423" 6 25 1
4145 2009 20011 130261 "20011" "130261" 4 25 0
4145 2010 99673 20376 "99673" "20376" 10 26 0
4145 2010 113956 52827 "113956" "52827" 2 26 1
4145 2010 112085 109728 "112085" "109728" 12 26 1
4145 2010 20376 110441 "20376" "110441" 9 26 1
4145 2010 135300 112085 "135300" "112085" 6 26 0
4145 2010 109728 113956 "109728" "113956" 8 26 1
4145 2010 20011 114669 "20011" "114669" 4 26 0
4145 2010 118986 114669 "118986" "114669" 5 26 0
4145 2010 52827 123423 "52827" "123423" 2 26 1
4145 2010 110441 136717 "110441" "136717" 6 26 1
4145 2010 119484 138194 "119484" "138194" 7 26 0
4145 2011 139505 80730 "139505" "80730" 9 27 0
4145 2011 112085 99673 "112085" "99673" 12 27 1
4145 2011 122986 99673 "122986" "99673" 14 27 0
4145 2011 110441 99673 "110441" "99673" 6 27 0
4145 2011 20011 99673 "20011" "99673" 4 27 0
4145 2011 119484 109728 "119484" "109728" 7 27 1
4145 2011 118986 112085 "118986" "112085" 5 27 1
4145 2011 135300 118986 "135300" "118986" 6 27 0
4145 2011 109728 119484 "109728" "119484" 8 27 1
4145 2011 99673 136717 "99673" "136717" 10 27 4
4145 2011 20376 149962 "20376" "149962" 9 27 0
4145 2012 135825 20011 "135825" "20011" 1 28 0
4145 2012 20376 86687 "20376" "86687" 9 28 0
4145 2012 107607 107607 "107607" "107607" 16 28 1
4145 2012 119484 114669 "119484" "114669" 7 28 0
4145 2012 112963 118986 "112963" "118986" 0 28 0
4145 2012 86687 122986 "86687" "122986" 9 28 1
4145 2012 135300 139505 "135300" "139505" 6 28 0
4145 2012 112085 139505 "112085" "139505" 12 28 0
4145 2012 118986 139505 "118986" "139505" 5 28 1
4145 2012 110441 139505 "110441" "139505" 6 28 0
4145 2012 139505 139505 "139505" "139505" 9 28 9
4145 2012 109728 139505 "109728" "139505" 8 28 0
4145 2012 127576 139505 "127576" "139505" 0 28 0
4145 2012 152345 139505 "152345" "139505" 2 28 0
4145 2012 99673 139505 "99673" "139505" 10 28 0
4145 2012 122986 148182 "122986" "148182" 14 28 1
4145 2013 135825 20011 "135825" "20011" 1 29 0
4145 2013 119484 20376 "119484" "20376" 7 29 1
4145 2013 152345 86687 "152345" "86687" 2 29 1
4145 2013 86484 99673 "86484" "99673" 0 29 0
4145 2013 127576 107607 "127576" "107607" 0 29 0
4145 2013 110441 109728 "110441" "109728" 6 29 1
4145 2013 138194 110441 "138194" "110441" 3 29 1
4145 2013 138700 112085 "138700" "112085" 6 29 1
4145 2013 122986 118986 "122986" "118986" 14 29 1
4145 2013 86687 119484 "86687" "119484" 9 29 1
4145 2013 112963 122986 "112963" "122986" 0 29 0
4145 2013 20376 135300 "20376" "135300" 9 29 1
4145 2013 99673 136717 "99673" "136717" 10 29 1
4145 2013 107607 137048 "107607" "137048" 16 29 1
4145 2013 135300 138194 "135300" "138194" 6 29 1
4145 2013 152345 138700 "152345" "138700" 2 29 1
4145 2013 152345 148182 "152345" "148182" 2 29 1
4145 2013 112085 149962 "112085" "149962" 12 29 1
4145 2013 109728 152345 "109728" "152345" 8 29 1
4145 2014 138194 20376 "138194" "20376" 3 30 1
4145 2014 135825 86687 "135825" "86687" 1 30 0
4145 2014 165893 99673 "165893" "99673" 4 30 1
4145 2014 20376 107607 "20376" "107607" 9 30 1
4145 2014 137579 109728 "137579" "109728" 3 30 1
4145 2014 107607 110441 "107607" "110441" 16 30 1
4145 2014 109728 112085 "109728" "112085" 8 30 1
4145 2014 152345 119484 "152345" "119484" 2 30 1
4145 2014 119484 122986 "119484" "122986" 7 30 1
4145 2014 137206 135300 "137206" "135300" 2 30 1
4145 2014 99673 136717 "99673" "136717" 10 30 1
4145 2014 110441 137206 "110441" "137206" 6 30 1
4145 2014 112963 137579 "112963" "137579" 0 30 0
4145 2014 138700 138194 "138700" "138194" 6 30 1
4145 2014 122986 138700 "122986" "138700" 14 30 1
4145 2014 86484 147830 "86484" "147830" 0 30 0
4145 2014 112085 148182 "112085" "148182" 12 30 1
4145 2014 147830 152345 "147830" "152345" 3 30 1
4145 2014 86687 165893 "86687" "165893" 9 30 1
4145 2014 135300 180911 "135300" "180911" 6 30 1
4145 2015 137206 31736 "137206" "31736" 2 31 0
4145 2015 119484 40897 "119484" "40897" 7 31 1
4145 2015 112963 86687 "112963" "86687" 0 31 0
4145 2015 165893 99673 "165893" "99673" 4 31 1
4145 2015 138700 107607 "138700" "107607" 6 31 1
4145 2015 86484 109728 "86484" "109728" 0 31 0
4145 2015 112085 112085 "112085" "112085" 12 31 4
4145 2015 135300 112085 "135300" "112085" 6 31 1
4145 2015 86687 112085 "86687" "112085" 9 31 1
4145 2015 122986 112085 "122986" "112085" 14 31 1
4145 2015 137579 119484 "137579" "119484" 3 31 1
4145 2015 137610 122986 "137610" "122986" 0 31 0
4145 2015 107607 135300 "107607" "135300" 16 31 1
4145 2015 135825 137579 "135825" "137579" 1 31 0
4145 2015 99673 138700 "99673" "138700" 10 31 1
4145 2015 147830 148182 "147830" "148182" 3 31 0
4145 2015 20376 165893 "20376" "165893" 9 31 0
4145 2015 109728 180911 "109728" "180911" 8 31 1
4145 2015 156290 184052 "156290" "184052" 1 31 0
4145 2016 86687 20376 "86687" "20376" 9 32 1
4145 2016 180911 40897 "180911" "40897" 5 32 1
4145 2016 184052 86687 "184052" "86687" 2 32 1
4145 2016 135825 99673 "135825" "99673" 1 32 0
4145 2016 165893 107607 "165893" "107607" 4 32 1
4145 2016 137610 109728 "137610" "109728" 0 32 0
4145 2016 107607 112085 "107607" "112085" 16 32 1
4145 2016 122986 122986 "122986" "122986" 14 32 1
4145 2016 109728 135300 "109728" "135300" 8 32 1
4145 2016 137206 136717 "137206" "136717" 2 32 1
4145 2016 137579 137206 "137579" "137206" 3 32 1
4145 2016 20376 137579 "20376" "137579" 9 32 1
4145 2016 112085 138700 "112085" "138700" 12 32 1
4145 2016 138700 147830 "138700" "147830" 6 32 1
4145 2016 86484 148182 "86484" "148182" 0 32 0
4145 2016 164317 156290 "164317" "156290" 2 32 1
4145 2016 156290 164317 "156290" "164317" 1 32 1
4145 2016 99673 165893 "99673" "165893" 10 32 1
4145 2016 180911 168860 "180911" "168860" 5 32 1
4145 2016 147830 180911 "147830" "180911" 3 32 1
4145 2016 180911 184052 "180911" "184052" 5 32 1
4145 2017 148182 20376 "148182" "20376" 6 33 1
4145 2017 109728 40897 "109728" "40897" 8 33 1
4145 2017 126755 86687 "126755" "86687" 6 33 5
4145 2017 147830 99673 "147830" "99673" 3 33 0
4145 2017 135825 107607 "135825" "107607" 1 33 1
4145 2017 122986 109728 "122986" "109728" 14 33 0
4145 2017 112085 126755 "112085" "126755" 12 33 0
4145 2017 20376 126755 "20376" "126755" 9 33 1
4145 2017 107607 126755 "107607" "126755" 16 33 1
4145 2017 180911 126755 "180911" "126755" 5 33 1
4145 2017 164317 126755 "164317" "126755" 2 33 1
4145 2017 86687 135300 "86687" "135300" 9 33 1
4145 2017 86484 135825 "86484" "135825" 0 33 0
4145 2017 138700 148182 "138700" "148182" 6 33 0
4145 2017 165893 164317 "165893" "164317" 4 33 1
4145 2017 99673 165893 "99673" "165893" 10 33 1
4145 2017 137610 180911 "137610" "180911" 0 33 0
4145 2018 86484 20376 "86484" "20376" 0 34 0
4145 2018 180911 80730 "180911" "80730" 5 34 0
4145 2018 148182 86687 "148182" "86687" 6 34 0
4145 2018 147830 107607 "147830" "107607" 3 34 0
4145 2018 86687 122986 "86687" "122986" 9 34 1
4145 2018 126755 122986 "126755" "122986" 6 34 1
4145 2018 122986 122986 "122986" "122986" 14 34 7
4145 2018 109728 122986 "109728" "122986" 8 34 0
4145 2018 80730 122986 "80730" "122986" 3 34 1
4145 2018 107607 122986 "107607" "122986" 16 34 1
4145 2018 20376 122986 "20376" "122986" 9 34 1
4145 2018 112085 126755 "112085" "126755" 12 34 0
4145 2018 137610 138700 "137610" "138700" 0 34 0
4145 2018 138700 168860 "138700" "168860" 6 34 1
4145 2019 109728 20376 "109728" "20376" 8 35 1
4145 2019 122986 40897 "122986" "40897" 14 35 1
4145 2019 126755 86687 "126755" "86687" 6 35 0
4145 2019 20376 107607 "20376" "107607" 9 35 1
4145 2019 180911 107607 "180911" "107607" 5 35 0
4145 2019 86687 107607 "86687" "107607" 9 35 1
4145 2019 112085 107607 "112085" "107607" 12 35 0
4145 2019 86484 107607 "86484" "107607" 0 35 0
4145 2019 143937 107607 "143937" "107607" 0 35 0
4145 2019 147830 107607 "147830" "107607" 3 35 1
4145 2019 137610 109728 "137610" "109728" 0 35 0
4145 2019 138700 122986 "138700" "122986" 6 35 1
4145 2019 107607 135300 "107607" "135300" 16 35 7
4145 2019 135308 138700 "135308" "138700" 0 35 0
4145 2019 150020 147830 "150020" "147830" 1 35 0
4145 2019 80730 155832 "80730" "155832" 3 35 0
4145 2020 86687 20376 "86687" "20376" 9 36 1
4145 2020 138700 40897 "138700" "40897" 6 36 0
4145 2020 147830 79185 "147830" "79185" 3 36 0
4145 2020 150020 86687 "150020" "86687" 1 36 1
4145 2020 86484 122986 "86484" "122986" 0 36 0
4145 2020 107607 136717 "107607" "136717" 16 36 0
4145 2020 80730 150020 "80730" "150020" 3 36 0
4145 2020 180911 155832 "180911" "155832" 5 36 1
4145 2020 195379 168860 "195379" "168860" 1 36 1
4145 2020 122986 180911 "122986" "180911" 14 36 1
4145 2020 109728 189813 "109728" "189813" 8 36 0
4145 2020 135308 189813 "135308" "189813" 0 36 0
4145 2020 20376 189813 "20376" "189813" 9 36 1
4145 2020 143937 195379 "143937" "195379" 0 36 0
4384 2019 . 70687 "." "70687" 6 37 0
4384 2020 . 105235 "." "105235" 6 38 0
4384 2021 79876 . "79876" "." 0 39 0
4384 2021 148882 . "148882" "." 0 39 0
4384 2021 115943 . "115943" "." 0 39 0
4384 2021 182857 . "182857" "." 0 39 0
4384 2021 70687 . "70687" "." 1 39 0
4384 2021 131583 . "131583" "." 0 39 0
4390 2016 81822 . "81822" "." 0 40 0
4390 2016 103386 . "103386" "." 0 40 0
4390 2017 81822 . "81822" "." 0 41 0
4390 2017 103386 . "103386" "." 0 41 0
4390 2018 103386 . "103386" "." 0 42 0
4390 2018 81822 . "81822" "." 0 42 0
4390 2019 81822 . "81822" "." 0 43 0
4390 2019 103386 . "103386" "." 0 43 0
4390 2020 81822 . "81822" "." 0 44 0
4390 2020 103386 . "103386" "." 0 44 0
4390 2021 103386 . "103386" "." 0 45 0
4390 2022 103386 . "103386" "." 0 46 0
4418 2015 157376 . "157376" "." 0 47 0
4418 2015 55896 . "55896" "." 0 47 0
4418 2016 55896 . "55896" "." 0 48 0
4418 2016 82492 . "82492" "." 0 48 0
4418 2017 114110 20376 "114110" "20376" 0 49 0
4418 2017 55896 107607 "55896" "107607" 0 49 0
4418 2017 55896 137206 "55896" "137206" 0 49 0
4418 2017 55896 147830 "55896" "147830" 0 49 0
4418 2018 73945 . "73945" "." 0 50 0
4418 2018 114110 . "114110" "." 0 50 0
4418 2019 73945 . "73945" "." 0 51 0
4418 2020 . . "." "." 8 52 1
4418 2021 . 110115 "." "110115" 8 53 0
4418 2021 . 155832 "." "155832" 8 53 0
4418 2021 . 185530 "." "185530" 8 53 0
4418 2021 . 192976 "." "192976" 8 53 0
4418 2021 . 194716 "." "194716" 8 53 0
4423 2001 71429 2084 "71429" "2084" 0 54 0
4423 2001 50004 9208 "50004" "9208" 0 54 0
4423 2001 45660 31483 "45660" "31483" 0 54 0
4423 2001 1797 31506 "1797" "31506" 0 54 0
4423 2001 30942 31798 "30942" "31798" 0 54 0
4423 2001 3875 46402 "3875" "46402" 0 54 0
4423 2001 71145 49461 "71145" "49461" 1 54 1
4423 2001 77084 52818 "77084" "52818" 0 54 0
4423 2001 51140 71145 "51140" "71145" 0 54 0
4423 2001 9913 71417 "9913" "71417" 0 54 0
4423 2001 52818 71417 "52818" "71417" 1 54 1
4423 2001 46402 71417 "46402" "71417" 1 54 1
4423 2001 9945 71417 "9945" "71417" 0 54 0
4423 2001 41830 77891 "41830" "77891" 0 54 0
4423 2001 2084 78771 "2084" "78771" 1 54 1
4423 2002 9945 . "9945" "." 0 55 0
4423 2002 50004 . "50004" "." 0 55 0
4423 2002 82419 . "82419" "." 0 55 0
4423 2002 10694 . "10694" "." 0 55 0
4423 2002 44628 . "44628" "." 0 55 0
4423 2002 49461 . "49461" "." 1 55 0
4423 2002 2084 . "2084" "." 1 55 0
4423 2002 9913 . "9913" "." 0 55 0
4423 2002 77084 . "77084" "." 0 55 0
4423 2002 51174 . "51174" "." 0 55 0
4423 2002 52818 . "52818" "." 1 55 0
4423 2002 71145 . "71145" "." 1 55 0
4423 2002 1797 . "1797" "." 0 55 0
end
Comment
Hemanshu Kumar

Join Date: Mar 2015

Posts: 1387
#7

06 Jun 2025, 08:44

So just to confirm, if we ignore countmatch for a minute and focus on the problem you want to solve: you want a binary variable that tells you whether or not a person in ANALYS1 has any match (within gvkey and fyear) in ANALYS2?
Comment
Mabel Costa

Join Date: Oct 2017

Posts: 25
#8

06 Jun 2025, 08:48

Hi Hemanshu, yes.
Comment
Hemanshu Kumar

Join Date: Mar 2015

Posts: 1387
#9

06 Jun 2025, 09:23

There are of course ways of doing this without countmatch, but if you want to stick with that command instead of substituting it with a bunch of code, an easy way is to generate the variable:

Code:

gen byte wanted = cond(count2 > 0 & !missing(count2), 1, cond(!missing(count2), 0, .))
1 like
Comment
Nick Cox

Join Date: Mar 2014

Posts: 35681
#10

07 Jun 2025, 03:23

Thanks very much for the substantial data example. I focus here first on using rangestat from SSC to tackle your problem as I understand ir.

The string equivalents of ANALYS1 and ANALYS2 don't seem needed or helpful. If either analyst variable is missing, there is nothing to look for.

Here I drop such observations, but in your analyses you should just omit them from rangestat calculations with an if qualifier.

I use rangestat to count instances and then reduce the count to an indicator variable.

Results follow in the next post.

What to do about countmatch remains on my agenda. My bias is that whatever it can do, rangestat can do that fine (and much, much more).

[CODE]
* fewer variables, same observations
* Example generated by -dataex-. For more info, type help dataex
clear
input long gvkey double(fyear ANALYS1 ANALYS2)
4066 2016 164392 .
4066 2016 125888 .
4066 2016 114980 .
4066 2016 47919 .
4066 2016 106603 .
4066 2016 164643 .
4066 2017 114980 40897
4066 2017 119652 45722
4066 2017 58895 47919
4066 2017 83177 58895
4066 2017 135522 80027
4066 2017 106603 81118
4066 2017 80027 82890
4066 2017 128126 83177
4066 2017 45722 106603
4066 2017 133843 109283
4066 2017 160058 114980
4066 2017 47919 125888
4066 2017 109283 126168
4066 2017 186784 128126
4066 2017 81118 135522
4066 2017 170633 135522
4066 2017 164392 135522
4066 2017 82890 135522
4066 2017 149618 149618
4066 2017 125888 164392
4066 2017 73590 170633
4066 2018 106603 40897
4066 2018 114980 49454
4066 2018 191271 54310
4066 2018 133843 58895
4066 2018 125888 80027
4066 2018 82890 81118
4066 2018 58895 82890
4066 2018 128126 106603
4066 2018 119652 109283
4066 2018 73590 114980
4066 2018 49454 119652
4066 2018 80027 125888
4066 2018 135522 126168
4066 2018 81118 128126
4066 2018 54310 133843
4066 2018 58895 135522
4066 2018 109283 149618
4066 2018 58895 164392
4066 2018 164392 169920
4066 2018 149618 191271
4066 2019 191271 49454
4066 2019 164392 54310
4066 2019 82890 58895
4066 2019 58895 80027
4066 2019 133843 81118
4066 2019 81118 82890
4066 2019 49454 106603
4066 2019 80027 109283
4066 2019 73590 125888
4066 2019 125888 133843
4066 2019 109283 135522
4066 2019 54310 164392
4066 2019 106603 191271
4066 2019 135522 191271
4066 2020 49454 49454
4066 2020 106603 54310
4066 2020 58895 58895
4066 2020 135522 73590
4066 2020 81118 81118
4066 2020 164392 82890
4066 2020 54310 106603
4066 2020 130988 109283
4066 2020 109283 114980
4066 2020 133843 125888
4066 2020 125888 130988
4066 2020 82890 133843
4066 2020 191271 135522
4066 2020 73590 164392
4066 2020 169920 191271
4066 2020 114980 191648
4066 2021 133843 49454
4066 2021 54310 54310
4066 2021 194181 58895
4066 2021 125888 73590
4066 2021 81118 81118
4066 2021 169920 106603
4066 2021 109283 106603
4066 2021 164392 106603
4066 2021 114980 109283
4066 2021 191271 114980
4066 2021 130988 125888
4066 2021 58895 133843
4066 2021 106603 164392
4066 2021 73590 191271
4066 2021 49454 191648
4094 2019 . 779
4094 2019 . 25262
4094 2019 . 45396
4094 2019 . 49454
4094 2019 . 50004
4094 2019 . 93125
4094 2019 . 114289
4094 2019 . 119652
4094 2019 . 120964
4094 2019 . 125271
4094 2019 . 125558
4094 2019 . 147210
4094 2019 . 152918
4094 2019 . 154817
4094 2019 . 155160
4094 2019 . 186094
4094 2019 . 189214
4094 2019 . 193672
4094 2020 45396 .
4094 2020 125271 .
4094 2020 195226 .
4094 2020 122224 .
4094 2020 80903 .
4094 2020 185321 .
4094 2020 153502 .
4094 2020 86654 .
4094 2020 155160 .
4094 2020 43698 .
4094 2020 108389 .
4094 2021 155263 .
4094 2021 194592 .
4094 2021 45396 .
4094 2021 195226 .
4094 2021 125558 .
4094 2021 9913 .
4094 2021 122224 .
4094 2021 43698 .
4094 2021 80903 .
4094 2021 153502 .
4094 2021 86654 .
4094 2021 155160 .
4094 2021 185321 .
4094 2021 125271 .
4115 2014 50254 .
4115 2014 124719 .
4115 2014 130258 .
4115 2014 79979 .
4115 2014 75061 .
4115 2014 31893 .
4115 2014 121327 .
4115 2015 130258 31893
4115 2015 50254 50254
4115 2015 124719 82369
4115 2015 75061 114113
4115 2015 78363 121327
4115 2015 121327 123211
4115 2015 79979 124719
4115 2015 31893 130258
4115 2016 50254 .
4115 2016 31893 .
4115 2016 130258 .
4115 2016 82413 .
4115 2016 121327 .
4115 2016 75061 .
4115 2016 78363 .
4115 2016 79979 .
4115 2016 124719 .
4115 2016 80400 .
4115 2017 80400 .
4115 2017 82413 .
4115 2017 50254 .
4115 2017 75061 .
4115 2017 31893 .
4115 2017 130258 .
4115 2017 120240 .
4115 2017 124719 .
4115 2017 121327 .
4115 2017 78363 .
4115 2018 75061 .
4115 2018 124719 .
4115 2018 130258 .
4115 2018 121327 .
4115 2018 153273 .
4115 2018 50254 .
4115 2018 120240 .
4115 2018 82413 .
4115 2018 78363 .
4115 2018 80400 .
4115 2019 190605 50254
4115 2019 82413 75061
4115 2019 124719 82207
4115 2019 50254 115741
4115 2019 130258 120240
4115 2019 80400 124719
4115 2019 120240 130258
4115 2019 121327 153273
4115 2019 78363 160179
4115 2019 75061 190605
4115 2019 153273 191938
4115 2020 115741 21008
4115 2020 120240 50254
4115 2020 130258 50254
4115 2020 121327 50254
4115 2020 75061 50254
4115 2020 124719 50254
4115 2020 191938 73734
4115 2020 78363 82207
4115 2020 190605 82369
4115 2020 50254 130258
4115 2020 153273 153273
4115 2021 50254 82369
4115 2021 130258 112249
4115 2021 153273 124719
4115 2021 185972 124719
4115 2021 78363 124719
4115 2021 124719 124719
4115 2021 191938 124719
4115 2021 75061 124719
4115 2021 120240 124719
4115 2021 190605 191938
4115 2022 130258 .
4115 2022 50254 .
4115 2022 185972 .
4115 2022 75061 .
4115 2022 120240 .
4115 2022 124719 .
4115 2022 191938 .
4145 2003 73538 5546
4145 2003 73538 7609
4145 2003 73538 30330
4145 2003 73538 58508
4145 2003 20376 77577
4145 2003 91719 78129
4145 2003 73538 78346
4145 2003 73538 79806
4145 2003 52827 82988
4145 2003 73538 83683
4145 2003 73538 105782
4145 2004 91719 5546
4145 2004 73538 7609
4145 2004 21145 8699
4145 2004 20376 30330
4145 2004 20376 77577
4145 2004 20376 78129
4145 2004 20376 78346
4145 2004 20376 79806
4145 2004 20376 80428
4145 2004 20376 82988
4145 2004 20376 83683
4145 2004 52827 105782
4145 2005 52827 5836
4145 2005 20376 72765
4145 2005 112085 73538
4145 2005 73538 73595
4145 2005 21145 73595
4145 2005 91719 77577
4145 2006 113984 20011
4145 2006 20011 80730
4145 2006 113834 113834
4145 2006 52827 113834
4145 2006 20376 113834
4145 2006 110441 113834
4145 2006 112085 113834
4145 2006 91719 113834
4145 2006 73538 113834
4145 2007 20011 20011
4145 2007 52827 20376
4145 2007 110441 52827
4145 2007 113984 107607
4145 2007 73538 110441
4145 2007 119484 112085
4145 2007 20376 114669
4145 2007 112085 118986
4145 2008 112085 99673
4145 2008 99673 110441
4145 2008 119484 112085
4145 2008 113984 114669
4145 2008 110441 118986
4145 2008 52827 119484
4145 2008 20011 119484
4145 2009 119484 107607
4145 2009 130261 110441
4145 2009 99673 112085
4145 2009 112085 113956
4145 2009 113956 119484
4145 2009 110441 123423
4145 2009 20011 130261
4145 2010 99673 20376
4145 2010 113956 52827
4145 2010 112085 109728
4145 2010 20376 110441
4145 2010 135300 112085
4145 2010 109728 113956
4145 2010 20011 114669
4145 2010 118986 114669
4145 2010 52827 123423
4145 2010 110441 136717
4145 2010 119484 138194
4145 2011 139505 80730
4145 2011 112085 99673
4145 2011 122986 99673
4145 2011 110441 99673
4145 2011 20011 99673
4145 2011 119484 109728
4145 2011 118986 112085
4145 2011 135300 118986
4145 2011 109728 119484
4145 2011 99673 136717
4145 2011 20376 149962
4145 2012 135825 20011
4145 2012 20376 86687
4145 2012 107607 107607
4145 2012 119484 114669
4145 2012 112963 118986
4145 2012 86687 122986
4145 2012 135300 139505
4145 2012 112085 139505
4145 2012 118986 139505
4145 2012 110441 139505
4145 2012 139505 139505
4145 2012 109728 139505
4145 2012 127576 139505
4145 2012 152345 139505
4145 2012 99673 139505
4145 2012 122986 148182
4145 2013 135825 20011
4145 2013 119484 20376
4145 2013 152345 86687
4145 2013 86484 99673
4145 2013 127576 107607
4145 2013 110441 109728
4145 2013 138194 110441
4145 2013 138700 112085
4145 2013 122986 118986
4145 2013 86687 119484
4145 2013 112963 122986
4145 2013 20376 135300
4145 2013 99673 136717
4145 2013 107607 137048
4145 2013 135300 138194
4145 2013 152345 138700
4145 2013 152345 148182
4145 2013 112085 149962
4145 2013 109728 152345
4145 2014 138194 20376
4145 2014 135825 86687
4145 2014 165893 99673
4145 2014 20376 107607
4145 2014 137579 109728
4145 2014 107607 110441
4145 2014 109728 112085
4145 2014 152345 119484
4145 2014 119484 122986
4145 2014 137206 135300
4145 2014 99673 136717
4145 2014 110441 137206
4145 2014 112963 137579
4145 2014 138700 138194
4145 2014 122986 138700
4145 2014 86484 147830
4145 2014 112085 148182
4145 2014 147830 152345
4145 2014 86687 165893
4145 2014 135300 180911
4145 2015 137206 31736
4145 2015 119484 40897
4145 2015 112963 86687
4145 2015 165893 99673
4145 2015 138700 107607
4145 2015 86484 109728
4145 2015 112085 112085
4145 2015 135300 112085
4145 2015 86687 112085
4145 2015 122986 112085
4145 2015 137579 119484
4145 2015 137610 122986
4145 2015 107607 135300
4145 2015 135825 137579
4145 2015 99673 138700
4145 2015 147830 148182
4145 2015 20376 165893
4145 2015 109728 180911
4145 2015 156290 184052
4145 2016 86687 20376
4145 2016 180911 40897
4145 2016 184052 86687
4145 2016 135825 99673
4145 2016 165893 107607
4145 2016 137610 109728
4145 2016 107607 112085
4145 2016 122986 122986
4145 2016 109728 135300
4145 2016 137206 136717
4145 2016 137579 137206
4145 2016 20376 137579
4145 2016 112085 138700
4145 2016 138700 147830
4145 2016 86484 148182
4145 2016 164317 156290
4145 2016 156290 164317
4145 2016 99673 165893
4145 2016 180911 168860
4145 2016 147830 180911
4145 2016 180911 184052
4145 2017 148182 20376
4145 2017 109728 40897
4145 2017 126755 86687
4145 2017 147830 99673
4145 2017 135825 107607
4145 2017 122986 109728
4145 2017 112085 126755
4145 2017 20376 126755
4145 2017 107607 126755
4145 2017 180911 126755
4145 2017 164317 126755
4145 2017 86687 135300
4145 2017 86484 135825
4145 2017 138700 148182
4145 2017 165893 164317
4145 2017 99673 165893
4145 2017 137610 180911
4145 2018 86484 20376
4145 2018 180911 80730
4145 2018 148182 86687
4145 2018 147830 107607
4145 2018 86687 122986
4145 2018 126755 122986
4145 2018 122986 122986
4145 2018 109728 122986
4145 2018 80730 122986
4145 2018 107607 122986
4145 2018 20376 122986
4145 2018 112085 126755
4145 2018 137610 138700
4145 2018 138700 168860
4145 2019 109728 20376
4145 2019 122986 40897
4145 2019 126755 86687
4145 2019 20376 107607
4145 2019 180911 107607
4145 2019 86687 107607
4145 2019 112085 107607
4145 2019 86484 107607
4145 2019 143937 107607
4145 2019 147830 107607
4145 2019 137610 109728
4145 2019 138700 122986
4145 2019 107607 135300
4145 2019 135308 138700
4145 2019 150020 147830
4145 2019 80730 155832
4145 2020 86687 20376
4145 2020 138700 40897
4145 2020 147830 79185
4145 2020 150020 86687
4145 2020 86484 122986
4145 2020 107607 136717
4145 2020 80730 150020
4145 2020 180911 155832
4145 2020 195379 168860
4145 2020 122986 180911
4145 2020 109728 189813
4145 2020 135308 189813
4145 2020 20376 189813
4145 2020 143937 195379
4384 2019 . 70687
4384 2020 . 105235
4384 2021 79876 .
4384 2021 148882 .
4384 2021 115943 .
4384 2021 182857 .
4384 2021 70687 .
4384 2021 131583 .
4390 2016 81822 .
4390 2016 103386 .
4390 2017 81822 .
4390 2017 103386 .
4390 2018 103386 .
4390 2018 81822 .
4390 2019 81822 .
4390 2019 103386 .
4390 2020 81822 .
4390 2020 103386 .
4390 2021 103386 .
4390 2022 103386 .
4418 2015 157376 .
4418 2015 55896 .
4418 2016 55896 .
4418 2016 82492 .
4418 2017 114110 20376
4418 2017 55896 107607
4418 2017 55896 137206
4418 2017 55896 147830
4418 2018 73945 .
4418 2018 114110 .
4418 2019 73945 .
4418 2020 . .
4418 2021 . 110115
4418 2021 . 155832
4418 2021 . 185530
4418 2021 . 192976
4418 2021 . 194716
4423 2001 71429 2084
4423 2001 50004 9208
4423 2001 45660 31483
4423 2001 1797 31506
4423 2001 30942 31798
4423 2001 3875 46402
4423 2001 71145 49461
4423 2001 77084 52818
4423 2001 51140 71145
4423 2001 9913 71417
4423 2001 52818 71417
4423 2001 46402 71417
4423 2001 9945 71417
4423 2001 41830 77891
4423 2001 2084 78771
4423 2002 9945 .
4423 2002 50004 .
4423 2002 82419 .
4423 2002 10694 .
4423 2002 44628 .
4423 2002 49461 .
4423 2002 2084 .
4423 2002 9913 .
4423 2002 77084 .
4423 2002 51174 .
4423 2002 52818 .
4423 2002 71145 .
4423 2002 1797 .
end

drop if missing(ANALYS1, ANALYS2)

rangestat (count) freq=gvkey, int(ANALYS2 ANALYS1 ANALYS1) by(gvkey fyear)

* note the peculiar definition: -inrange()- excludes system missing here.
gen present = inrange(freq, 1, .)

list , sepby(gvkey fyear)

list if ANALYS1 == ANALYS2
l/CODE]

Last edited by Nick Cox; 07 Jun 2025, 03:26.
Comment

Nick Cox

Join Date: Mar 2014
Posts: 35681

#11

07 Jun 2025, 03:24

Code:

. list , sepby(gvkey fyear) noobs 

  +----------------------------------------------------+
  | gvkey   fyear   ANALYS1   ANALYS2   freq   present |
  |----------------------------------------------------|
  |  4066    2017    114980     40897      1         1 |
  |  4066    2017    119652     45722      .         0 |
  |  4066    2017     58895     47919      1         1 |
  |  4066    2017     83177     58895      1         1 |
  |  4066    2017    135522     80027      4         1 |
  |  4066    2017    106603     81118      1         1 |
  |  4066    2017     80027     82890      1         1 |
  |  4066    2017    128126     83177      1         1 |
  |  4066    2017     45722    106603      1         1 |
  |  4066    2017    133843    109283      .         0 |
  |  4066    2017    160058    114980      .         0 |
  |  4066    2017     47919    125888      1         1 |
  |  4066    2017    109283    126168      1         1 |
  |  4066    2017    186784    128126      .         0 |
  |  4066    2017     81118    135522      1         1 |
  |  4066    2017    170633    135522      1         1 |
  |  4066    2017    164392    135522      1         1 |
  |  4066    2017     82890    135522      1         1 |
  |  4066    2017    149618    149618      1         1 |
  |  4066    2017    125888    164392      1         1 |
  |  4066    2017     73590    170633      .         0 |
  |----------------------------------------------------|
  |  4066    2018    106603     40897      1         1 |
  |  4066    2018    114980     49454      1         1 |
  |  4066    2018    191271     54310      1         1 |
  |  4066    2018    133843     58895      1         1 |
  |  4066    2018    125888     80027      1         1 |
  |  4066    2018     82890     81118      1         1 |
  |  4066    2018     58895     82890      1         1 |
  |  4066    2018    128126    106603      1         1 |
  |  4066    2018    119652    109283      1         1 |
  |  4066    2018     73590    114980      .         0 |
  |  4066    2018     49454    119652      1         1 |
  |  4066    2018     80027    125888      1         1 |
  |  4066    2018    135522    126168      1         1 |
  |  4066    2018     81118    128126      1         1 |
  |  4066    2018     54310    133843      1         1 |
  |  4066    2018     58895    135522      1         1 |
  |  4066    2018    109283    149618      1         1 |
  |  4066    2018     58895    164392      1         1 |
  |  4066    2018    164392    169920      1         1 |
  |  4066    2018    149618    191271      1         1 |
  |----------------------------------------------------|
  |  4066    2019    191271     49454      2         1 |
  |  4066    2019    164392     54310      1         1 |
  |  4066    2019     82890     58895      1         1 |
  |  4066    2019     58895     80027      1         1 |
  |  4066    2019    133843     81118      1         1 |
  |  4066    2019     81118     82890      1         1 |
  |  4066    2019     49454    106603      1         1 |
  |  4066    2019     80027    109283      1         1 |
  |  4066    2019     73590    125888      .         0 |
  |  4066    2019    125888    133843      1         1 |
  |  4066    2019    109283    135522      1         1 |
  |  4066    2019     54310    164392      1         1 |
  |  4066    2019    106603    191271      1         1 |
  |  4066    2019    135522    191271      1         1 |
  |----------------------------------------------------|
  |  4066    2020     49454     49454      1         1 |
  |  4066    2020    106603     54310      1         1 |
  |  4066    2020     58895     58895      1         1 |
  |  4066    2020    135522     73590      1         1 |
  |  4066    2020     81118     81118      1         1 |
  |  4066    2020    164392     82890      1         1 |
  |  4066    2020     54310    106603      1         1 |
  |  4066    2020    130988    109283      1         1 |
  |  4066    2020    109283    114980      1         1 |
  |  4066    2020    133843    125888      1         1 |
  |  4066    2020    125888    130988      1         1 |
  |  4066    2020     82890    133843      1         1 |
  |  4066    2020    191271    135522      1         1 |
  |  4066    2020     73590    164392      1         1 |
  |  4066    2020    169920    191271      .         0 |
  |  4066    2020    114980    191648      1         1 |
  |----------------------------------------------------|
  |  4066    2021    133843     49454      1         1 |
  |  4066    2021     54310     54310      1         1 |
  |  4066    2021    194181     58895      .         0 |
  |  4066    2021    125888     73590      1         1 |
  |  4066    2021     81118     81118      1         1 |
  |  4066    2021    169920    106603      .         0 |
  |  4066    2021    109283    106603      1         1 |
  |  4066    2021    164392    106603      1         1 |
  |  4066    2021    114980    109283      1         1 |
  |  4066    2021    191271    114980      1         1 |
  |  4066    2021    130988    125888      .         0 |
  |  4066    2021     58895    133843      1         1 |
  |  4066    2021    106603    164392      3         1 |
  |  4066    2021     73590    191271      1         1 |
  |  4066    2021     49454    191648      1         1 |
  |----------------------------------------------------|
  |  4115    2015    130258     31893      1         1 |
  |  4115    2015     50254     50254      1         1 |
  |  4115    2015    124719     82369      1         1 |
  |  4115    2015     75061    114113      .         0 |
  |  4115    2015     78363    121327      .         0 |
  |  4115    2015    121327    123211      1         1 |
  |  4115    2015     79979    124719      .         0 |
  |  4115    2015     31893    130258      1         1 |
  |----------------------------------------------------|
  |  4115    2019    190605     50254      1         1 |
  |  4115    2019     82413     75061      .         0 |
  |  4115    2019    124719     82207      1         1 |
  |  4115    2019     50254    115741      1         1 |
  |  4115    2019    130258    120240      1         1 |
  |  4115    2019     80400    124719      .         0 |
  |  4115    2019    120240    130258      1         1 |
  |  4115    2019    121327    153273      .         0 |
  |  4115    2019     78363    160179      .         0 |
  |  4115    2019     75061    190605      1         1 |
  |  4115    2019    153273    191938      1         1 |
  |----------------------------------------------------|
  |  4115    2020    115741     21008      .         0 |
  |  4115    2020    120240     50254      .         0 |
  |  4115    2020    130258     50254      1         1 |
  |  4115    2020    121327     50254      .         0 |
  |  4115    2020     75061     50254      .         0 |
  |  4115    2020    124719     50254      .         0 |
  |  4115    2020    191938     73734      .         0 |
  |  4115    2020     78363     82207      .         0 |
  |  4115    2020    190605     82369      .         0 |
  |  4115    2020     50254    130258      5         1 |
  |  4115    2020    153273    153273      1         1 |
  |----------------------------------------------------|
  |  4115    2021     50254     82369      .         0 |
  |  4115    2021    130258    112249      .         0 |
  |  4115    2021    153273    124719      .         0 |
  |  4115    2021    185972    124719      .         0 |
  |  4115    2021     78363    124719      .         0 |
  |  4115    2021    124719    124719      7         1 |
  |  4115    2021    191938    124719      1         1 |
  |  4115    2021     75061    124719      .         0 |
  |  4115    2021    120240    124719      .         0 |
  |  4115    2021    190605    191938      .         0 |
  |----------------------------------------------------|
  |  4145    2003     73538      5546      .         0 |
  |  4145    2003     73538      7609      .         0 |
  |  4145    2003     73538     30330      .         0 |
  |  4145    2003     73538     58508      .         0 |
  |  4145    2003     20376     77577      .         0 |
  |  4145    2003     91719     78129      .         0 |
  |  4145    2003     73538     78346      .         0 |
  |  4145    2003     73538     79806      .         0 |
  |  4145    2003     52827     82988      .         0 |
  |  4145    2003     73538     83683      .         0 |
  |  4145    2003     73538    105782      .         0 |
  |----------------------------------------------------|
  |  4145    2004     91719      5546      .         0 |
  |  4145    2004     73538      7609      .         0 |
  |  4145    2004     21145      8699      .         0 |
  |  4145    2004     20376     30330      .         0 |
  |  4145    2004     20376     77577      .         0 |
  |  4145    2004     20376     78129      .         0 |
  |  4145    2004     20376     78346      .         0 |
  |  4145    2004     20376     79806      .         0 |
  |  4145    2004     20376     80428      .         0 |
  |  4145    2004     20376     82988      .         0 |
  |  4145    2004     20376     83683      .         0 |
  |  4145    2004     52827    105782      .         0 |
  |----------------------------------------------------|
  |  4145    2005     52827      5836      .         0 |
  |  4145    2005     20376     72765      .         0 |
  |  4145    2005    112085     73538      .         0 |
  |  4145    2005     73538     73595      1         1 |
  |  4145    2005     21145     73595      .         0 |
  |  4145    2005     91719     77577      .         0 |
  |----------------------------------------------------|
  |  4145    2006    113984     20011      .         0 |
  |  4145    2006     20011     80730      1         1 |
  |  4145    2006    113834    113834      7         1 |
  |  4145    2006     52827    113834      .         0 |
  |  4145    2006     20376    113834      .         0 |
  |  4145    2006    110441    113834      .         0 |
  |  4145    2006    112085    113834      .         0 |
  |  4145    2006     91719    113834      .         0 |
  |  4145    2006     73538    113834      .         0 |
  |----------------------------------------------------|
  |  4145    2007     20011     20011      1         1 |
  |  4145    2007     52827     20376      1         1 |
  |  4145    2007    110441     52827      1         1 |
  |  4145    2007    113984    107607      .         0 |
  |  4145    2007     73538    110441      .         0 |
  |  4145    2007    119484    112085      .         0 |
  |  4145    2007     20376    114669      1         1 |
  |  4145    2007    112085    118986      1         1 |
  |----------------------------------------------------|
  |  4145    2008    112085     99673      1         1 |
  |  4145    2008     99673    110441      1         1 |
  |  4145    2008    119484    112085      2         1 |
  |  4145    2008    113984    114669      .         0 |
  |  4145    2008    110441    118986      1         1 |
  |  4145    2008     52827    119484      .         0 |
  |  4145    2008     20011    119484      .         0 |
  |----------------------------------------------------|
  |  4145    2009    119484    107607      1         1 |
  |  4145    2009    130261    110441      1         1 |
  |  4145    2009     99673    112085      .         0 |
  |  4145    2009    112085    113956      1         1 |
  |  4145    2009    113956    119484      1         1 |
  |  4145    2009    110441    123423      1         1 |
  |  4145    2009     20011    130261      .         0 |
  |----------------------------------------------------|
  |  4145    2010     99673     20376      .         0 |
  |  4145    2010    113956     52827      1         1 |
  |  4145    2010    112085    109728      1         1 |
  |  4145    2010     20376    110441      1         1 |
  |  4145    2010    135300    112085      .         0 |
  |  4145    2010    109728    113956      1         1 |
  |  4145    2010     20011    114669      .         0 |
  |  4145    2010    118986    114669      .         0 |
  |  4145    2010     52827    123423      1         1 |
  |  4145    2010    110441    136717      1         1 |
  |  4145    2010    119484    138194      .         0 |
  |----------------------------------------------------|
  |  4145    2011    139505     80730      .         0 |
  |  4145    2011    112085     99673      1         1 |
  |  4145    2011    122986     99673      .         0 |
  |  4145    2011    110441     99673      .         0 |
  |  4145    2011     20011     99673      .         0 |
  |  4145    2011    119484    109728      1         1 |
  |  4145    2011    118986    112085      1         1 |
  |  4145    2011    135300    118986      .         0 |
  |  4145    2011    109728    119484      1         1 |
  |  4145    2011     99673    136717      4         1 |
  |  4145    2011     20376    149962      .         0 |
  |----------------------------------------------------|
  |  4145    2012    135825     20011      .         0 |
  |  4145    2012     20376     86687      .         0 |
  |  4145    2012    107607    107607      1         1 |
  |  4145    2012    119484    114669      .         0 |
  |  4145    2012    112963    118986      .         0 |
  |  4145    2012     86687    122986      1         1 |
  |  4145    2012    135300    139505      .         0 |
  |  4145    2012    112085    139505      .         0 |
  |  4145    2012    118986    139505      1         1 |
  |  4145    2012    110441    139505      .         0 |
  |  4145    2012    139505    139505      9         1 |
  |  4145    2012    109728    139505      .         0 |
  |  4145    2012    127576    139505      .         0 |
  |  4145    2012    152345    139505      .         0 |
  |  4145    2012     99673    139505      .         0 |
  |  4145    2012    122986    148182      1         1 |
  |----------------------------------------------------|
  |  4145    2013    135825     20011      .         0 |
  |  4145    2013    119484     20376      1         1 |
  |  4145    2013    152345     86687      1         1 |
  |  4145    2013     86484     99673      .         0 |
  |  4145    2013    127576    107607      .         0 |
  |  4145    2013    110441    109728      1         1 |
  |  4145    2013    138194    110441      1         1 |
  |  4145    2013    138700    112085      1         1 |
  |  4145    2013    122986    118986      1         1 |
  |  4145    2013     86687    119484      1         1 |
  |  4145    2013    112963    122986      .         0 |
  |  4145    2013     20376    135300      1         1 |
  |  4145    2013     99673    136717      1         1 |
  |  4145    2013    107607    137048      1         1 |
  |  4145    2013    135300    138194      1         1 |
  |  4145    2013    152345    138700      1         1 |
  |  4145    2013    152345    148182      1         1 |
  |  4145    2013    112085    149962      1         1 |
  |  4145    2013    109728    152345      1         1 |
  |----------------------------------------------------|
  |  4145    2014    138194     20376      1         1 |
  |  4145    2014    135825     86687      .         0 |
  |  4145    2014    165893     99673      1         1 |
  |  4145    2014     20376    107607      1         1 |
  |  4145    2014    137579    109728      1         1 |
  |  4145    2014    107607    110441      1         1 |
  |  4145    2014    109728    112085      1         1 |
  |  4145    2014    152345    119484      1         1 |
  |  4145    2014    119484    122986      1         1 |
  |  4145    2014    137206    135300      1         1 |
  |  4145    2014     99673    136717      1         1 |
  |  4145    2014    110441    137206      1         1 |
  |  4145    2014    112963    137579      .         0 |
  |  4145    2014    138700    138194      1         1 |
  |  4145    2014    122986    138700      1         1 |
  |  4145    2014     86484    147830      .         0 |
  |  4145    2014    112085    148182      1         1 |
  |  4145    2014    147830    152345      1         1 |
  |  4145    2014     86687    165893      1         1 |
  |  4145    2014    135300    180911      1         1 |
  |----------------------------------------------------|
  |  4145    2015    137206     31736      .         0 |
  |  4145    2015    119484     40897      1         1 |
  |  4145    2015    112963     86687      .         0 |
  |  4145    2015    165893     99673      1         1 |
  |  4145    2015    138700    107607      1         1 |
  |  4145    2015     86484    109728      .         0 |
  |  4145    2015    112085    112085      4         1 |
  |  4145    2015    135300    112085      1         1 |
  |  4145    2015     86687    112085      1         1 |
  |  4145    2015    122986    112085      1         1 |
  |  4145    2015    137579    119484      1         1 |
  |  4145    2015    137610    122986      .         0 |
  |  4145    2015    107607    135300      1         1 |
  |  4145    2015    135825    137579      .         0 |
  |  4145    2015     99673    138700      1         1 |
  |  4145    2015    147830    148182      .         0 |
  |  4145    2015     20376    165893      .         0 |
  |  4145    2015    109728    180911      1         1 |
  |  4145    2015    156290    184052      .         0 |
  |----------------------------------------------------|
  |  4145    2016     86687     20376      1         1 |
  |  4145    2016    180911     40897      1         1 |
  |  4145    2016    184052     86687      1         1 |
  |  4145    2016    135825     99673      .         0 |
  |  4145    2016    165893    107607      1         1 |
  |  4145    2016    137610    109728      .         0 |
  |  4145    2016    107607    112085      1         1 |
  |  4145    2016    122986    122986      1         1 |
  |  4145    2016    109728    135300      1         1 |
  |  4145    2016    137206    136717      1         1 |
  |  4145    2016    137579    137206      1         1 |
  |  4145    2016     20376    137579      1         1 |
  |  4145    2016    112085    138700      1         1 |
  |  4145    2016    138700    147830      1         1 |
  |  4145    2016     86484    148182      .         0 |
  |  4145    2016    164317    156290      1         1 |
  |  4145    2016    156290    164317      1         1 |
  |  4145    2016     99673    165893      1         1 |
  |  4145    2016    180911    168860      1         1 |
  |  4145    2016    147830    180911      1         1 |
  |  4145    2016    180911    184052      1         1 |
  |----------------------------------------------------|
  |  4145    2017    148182     20376      1         1 |
  |  4145    2017    109728     40897      1         1 |
  |  4145    2017    126755     86687      5         1 |
  |  4145    2017    147830     99673      .         0 |
  |  4145    2017    135825    107607      1         1 |
  |  4145    2017    122986    109728      .         0 |
  |  4145    2017    112085    126755      .         0 |
  |  4145    2017     20376    126755      1         1 |
  |  4145    2017    107607    126755      1         1 |
  |  4145    2017    180911    126755      1         1 |
  |  4145    2017    164317    126755      1         1 |
  |  4145    2017     86687    135300      1         1 |
  |  4145    2017     86484    135825      .         0 |
  |  4145    2017    138700    148182      .         0 |
  |  4145    2017    165893    164317      1         1 |
  |  4145    2017     99673    165893      1         1 |
  |  4145    2017    137610    180911      .         0 |
  |----------------------------------------------------|
  |  4145    2018     86484     20376      .         0 |
  |  4145    2018    180911     80730      .         0 |
  |  4145    2018    148182     86687      .         0 |
  |  4145    2018    147830    107607      .         0 |
  |  4145    2018     86687    122986      1         1 |
  |  4145    2018    126755    122986      1         1 |
  |  4145    2018    122986    122986      7         1 |
  |  4145    2018    109728    122986      .         0 |
  |  4145    2018     80730    122986      1         1 |
  |  4145    2018    107607    122986      1         1 |
  |  4145    2018     20376    122986      1         1 |
  |  4145    2018    112085    126755      .         0 |
  |  4145    2018    137610    138700      .         0 |
  |  4145    2018    138700    168860      1         1 |
  |----------------------------------------------------|
  |  4145    2019    109728     20376      1         1 |
  |  4145    2019    122986     40897      1         1 |
  |  4145    2019    126755     86687      .         0 |
  |  4145    2019     20376    107607      1         1 |
  |  4145    2019    180911    107607      .         0 |
  |  4145    2019     86687    107607      1         1 |
  |  4145    2019    112085    107607      .         0 |
  |  4145    2019     86484    107607      .         0 |
  |  4145    2019    143937    107607      .         0 |
  |  4145    2019    147830    107607      1         1 |
  |  4145    2019    137610    109728      .         0 |
  |  4145    2019    138700    122986      1         1 |
  |  4145    2019    107607    135300      7         1 |
  |  4145    2019    135308    138700      .         0 |
  |  4145    2019    150020    147830      .         0 |
  |  4145    2019     80730    155832      .         0 |
  |----------------------------------------------------|
  |  4145    2020     86687     20376      1         1 |
  |  4145    2020    138700     40897      .         0 |
  |  4145    2020    147830     79185      .         0 |
  |  4145    2020    150020     86687      1         1 |
  |  4145    2020     86484    122986      .         0 |
  |  4145    2020    107607    136717      .         0 |
  |  4145    2020     80730    150020      .         0 |
  |  4145    2020    180911    155832      1         1 |
  |  4145    2020    195379    168860      1         1 |
  |  4145    2020    122986    180911      1         1 |
  |  4145    2020    109728    189813      .         0 |
  |  4145    2020    135308    189813      .         0 |
  |  4145    2020     20376    189813      1         1 |
  |  4145    2020    143937    195379      .         0 |
  |----------------------------------------------------|
  |  4418    2017    114110     20376      .         0 |
  |  4418    2017     55896    107607      .         0 |
  |  4418    2017     55896    137206      .         0 |
  |  4418    2017     55896    147830      .         0 |
  |----------------------------------------------------|
  |  4423    2001     71429      2084      .         0 |
  |  4423    2001     50004      9208      .         0 |
  |  4423    2001     45660     31483      .         0 |
  |  4423    2001      1797     31506      .         0 |
  |  4423    2001     30942     31798      .         0 |
  |  4423    2001      3875     46402      .         0 |
  |  4423    2001     71145     49461      1         1 |
  |  4423    2001     77084     52818      .         0 |
  |  4423    2001     51140     71145      .         0 |
  |  4423    2001      9913     71417      .         0 |
  |  4423    2001     52818     71417      1         1 |
  |  4423    2001     46402     71417      1         1 |
  |  4423    2001      9945     71417      .         0 |
  |  4423    2001     41830     77891      .         0 |
  |  4423    2001      2084     78771      1         1 |
  +----------------------------------------------------+

. 
. list if ANALYS1 == ANALYS2 , noobs 

  +----------------------------------------------------+
  | gvkey   fyear   ANALYS1   ANALYS2   freq   present |
  |----------------------------------------------------|
  |  4066    2017    149618    149618      1         1 |
  |  4066    2020     49454     49454      1         1 |
  |  4066    2020     58895     58895      1         1 |
  |  4066    2020     81118     81118      1         1 |
  |  4066    2021     54310     54310      1         1 |
  |----------------------------------------------------|
  |  4066    2021     81118     81118      1         1 |
  |  4115    2015     50254     50254      1         1 |
  |  4115    2020    153273    153273      1         1 |
  |  4115    2021    124719    124719      7         1 |
  |  4145    2006    113834    113834      7         1 |
  |----------------------------------------------------|
  |  4145    2007     20011     20011      1         1 |
  |  4145    2012    107607    107607      1         1 |
  |  4145    2012    139505    139505      9         1 |
  |  4145    2015    112085    112085      4         1 |
  |  4145    2016    122986    122986      1         1 |
  |----------------------------------------------------|
  |  4145    2018    122986    122986      7         1 |
  +----------------------------------------------------+

Comment

Nick Cox

Join Date: Mar 2014

Posts: 35681
#12

07 Jun 2025, 03:33

Sorry, but I can't get the CODE mark-up to work here in #10. I think the data example is too long.
Comment
Hemanshu Kumar

Join Date: Mar 2015

Posts: 1387
#13

07 Jun 2025, 08:13

Yikes, I didn't realize inrange() excludes missing values if the third argument is specified as missing. Thanks to #10, my suggestion in #9 stands simplified to:

Code:

gen byte wanted = inrange(count2, 1, .)
Comment
Nick Cox

Join Date: Mar 2014

Posts: 35681
#14

07 Jun 2025, 09:22

Indeed; it is a documented exception to a general pattern that

Code:

inrange(x, a, b)

means

a <= x <= b

where that expression is to be construed mathematically, not as Stata syntax.
Comment

Nick Cox

Join Date: Mar 2014
Posts: 35681

#15

07 Jun 2025, 15:05

Here is an improved countmatch. The ado and help will appear on SSC in due course, with acknowledgments to Mabel Costa and Hemanshu Kumar

The code for applying rangestat and countmatch may each seem backward from the point of view of the other command.

A nuance which I won't disturb is that countmatch returns 0 when it can't find a match while rangestat returns missing.

I hope it's enough to show results for a reduced dataset example. As in #10 and #11 blocks of observations in which one or both variables are missing can safely be ignored.

Code:

*! 3.0.0 NJC 7 June 2025
*! 2.0.0 NJC 4 November 2006
* 1.5.0 NJC 14 November 2000
* 1.4.0 NJC 29 February 2000
program countmatch, sortpreserve
    version 8
    syntax varlist(min=2 max=2) [if] [in] [, Generate(string) ///
        by(varlist) MISSing SUBVARname ABbreviate(int 12) * ]
    
    local g `generate'
    local list = "`g'" == ""
    if "`g'" != "" {
        confirm new variable `g'
    }
    else tempvar g                    
    
    tokenize `varlist'
    args var1 var2

    marksample touse, novarlist    
    if "`missing'" == "" markout `touse' `var1', strok
    qui count if `touse'
    if r(N) == 0 error 2000

    capture confirm string variable `var1'
    local var1num = _rc != 0
    capture confirm string variable `var2'
    local var2num = _rc != 0
    if `var1num' != `var2num' {
        local var1is = cond(`var1num',"numeric","string")
        local var2is = cond(`var2num',"numeric","string")
        di as err "`var1' is `var1is', `var2' is `var2is'"
        exit 198
    }    

    tempvar BY group origorder workorder  

    quietly {
        gen byte `g' = cond(`touse',0,.)
        gen long `origorder' = _n
        
        if "`by'" != "" {
            egen long `BY' = group(`by'), label  
            char `BY'[varname] "`by'"
            local byshow `BY'
        }
        else gen byte `BY' = 1
            
        bysort `touse' `BY' `var1': ///
            gen byte `group' = _n == 1 & `touse'
        replace `group' = sum(`group')
        local ngrp = `group'[_N]
        
        gen long `workorder' = _n

        forval i = 1/`ngrp' {
            su `workorder' if `group' == `i', meanonly
            local j = r(min)
            count if `var1'[`j'] == `var2' & `BY' == `BY'[`j']
            replace `g' = r(N) if `var1' == `var1'[`j'] & `BY' == `BY'[`j']
        }
    }    

    if `list' {
        char `origorder'[varname] "obs no"
        char `g'[varname] "# of matches"
        list `origorder' `byshow' `varlist' `g' if `touse', subvarname ///
            ab(`abbreviate') `options'
    }    

end

Code:

* Example generated by -dataex-. For more info, type help dataex
clear
input long gvkey double(fyear ANALYS1 ANALYS2)
4066 2017 114980 40897
4066 2017 119652 45722
4066 2017 58895 47919
4066 2017 83177 58895
4066 2017 135522 80027
4066 2017 106603 81118
4066 2017 80027 82890
4066 2017 128126 83177
4066 2017 45722 106603
4066 2017 133843 109283
4066 2017 160058 114980
4066 2017 47919 125888
4066 2017 109283 126168
4066 2017 186784 128126
4066 2017 81118 135522
4066 2017 170633 135522
4066 2017 164392 135522
4066 2017 82890 135522
4066 2017 149618 149618
4066 2017 125888 164392
4066 2017 73590 170633
4066 2018 106603 40897
4066 2018 114980 49454
4066 2018 191271 54310
4066 2018 133843 58895
4066 2018 125888 80027
4066 2018 82890 81118
4066 2018 58895 82890
4066 2018 128126 106603
4066 2018 119652 109283
4066 2018 73590 114980
4066 2018 49454 119652
4066 2018 80027 125888
4066 2018 135522 126168
4066 2018 81118 128126
4066 2018 54310 133843
4066 2018 58895 135522
4066 2018 109283 149618
4066 2018 58895 164392
4066 2018 164392 169920
4066 2018 149618 191271
4066 2019 191271 49454
4066 2019 164392 54310
4066 2019 82890 58895
4066 2019 58895 80027
4066 2019 133843 81118
4066 2019 81118 82890
4066 2019 49454 106603
4066 2019 80027 109283
4066 2019 73590 125888
4066 2019 125888 133843
4066 2019 109283 135522
4066 2019 54310 164392
4066 2019 106603 191271
4066 2019 135522 191271
4066 2020 49454 49454
4066 2020 106603 54310
4066 2020 58895 58895
4066 2020 135522 73590
4066 2020 81118 81118
4066 2020 164392 82890
4066 2020 54310 106603
4066 2020 130988 109283
4066 2020 109283 114980
4066 2020 133843 125888
4066 2020 125888 130988
4066 2020 82890 133843
4066 2020 191271 135522
4066 2020 73590 164392
4066 2020 169920 191271
4066 2020 114980 191648
4066 2021 133843 49454
4066 2021 54310 54310
4066 2021 194181 58895
4066 2021 125888 73590
4066 2021 81118 81118
4066 2021 169920 106603
4066 2021 109283 106603
4066 2021 164392 106603
4066 2021 114980 109283
4066 2021 191271 114980
4066 2021 130988 125888
4066 2021 58895 133843
4066 2021 106603 164392
4066 2021 73590 191271
4066 2021 49454 191648
end

rangestat (count) freq=gvkey, int(ANALYS2 ANALYS1 ANALYS1) by(gvkey fyear)

* note the peculiar definition: -inrange()- excludes system missing here.
gen present = inrange(freq, 1, .)

countmatch ANALYS1 ANALYS2, by(gvkey fyear) gen(freq_cm)

gen present_cm = inrange(freq_cm, 1, .)

list, sepby(gvkey fyear)

list if freq != freq_cm, sepby(gvkey fyear)

list if present != present_cm, sepby(gvkey fyear)

Code:

. list, sepby(gvkey fyear)

     +-------------------------------------------------------------------------+
     | gvkey   fyear   ANALYS1   ANALYS2   freq   present   freq_cm   presen~m |
     |-------------------------------------------------------------------------|
  1. |  4066    2017    114980     40897      1         1         1          1 |
  2. |  4066    2017    119652     45722      .         0         0          0 |
  3. |  4066    2017     58895     47919      1         1         1          1 |
  4. |  4066    2017     83177     58895      1         1         1          1 |
  5. |  4066    2017    135522     80027      4         1         4          1 |
  6. |  4066    2017    106603     81118      1         1         1          1 |
  7. |  4066    2017     80027     82890      1         1         1          1 |
  8. |  4066    2017    128126     83177      1         1         1          1 |
  9. |  4066    2017     45722    106603      1         1         1          1 |
 10. |  4066    2017    133843    109283      .         0         0          0 |
 11. |  4066    2017    160058    114980      .         0         0          0 |
 12. |  4066    2017     47919    125888      1         1         1          1 |
 13. |  4066    2017    109283    126168      1         1         1          1 |
 14. |  4066    2017    186784    128126      .         0         0          0 |
 15. |  4066    2017     81118    135522      1         1         1          1 |
 16. |  4066    2017    170633    135522      1         1         1          1 |
 17. |  4066    2017    164392    135522      1         1         1          1 |
 18. |  4066    2017     82890    135522      1         1         1          1 |
 19. |  4066    2017    149618    149618      1         1         1          1 |
 20. |  4066    2017    125888    164392      1         1         1          1 |
 21. |  4066    2017     73590    170633      .         0         0          0 |
     |-------------------------------------------------------------------------|
 22. |  4066    2018    106603     40897      1         1         1          1 |
 23. |  4066    2018    114980     49454      1         1         1          1 |
 24. |  4066    2018    191271     54310      1         1         1          1 |
 25. |  4066    2018    133843     58895      1         1         1          1 |
 26. |  4066    2018    125888     80027      1         1         1          1 |
 27. |  4066    2018     82890     81118      1         1         1          1 |
 28. |  4066    2018     58895     82890      1         1         1          1 |
 29. |  4066    2018    128126    106603      1         1         1          1 |
 30. |  4066    2018    119652    109283      1         1         1          1 |
 31. |  4066    2018     73590    114980      .         0         0          0 |
 32. |  4066    2018     49454    119652      1         1         1          1 |
 33. |  4066    2018     80027    125888      1         1         1          1 |
 34. |  4066    2018    135522    126168      1         1         1          1 |
 35. |  4066    2018     81118    128126      1         1         1          1 |
 36. |  4066    2018     54310    133843      1         1         1          1 |
 37. |  4066    2018     58895    135522      1         1         1          1 |
 38. |  4066    2018    109283    149618      1         1         1          1 |
 39. |  4066    2018     58895    164392      1         1         1          1 |
 40. |  4066    2018    164392    169920      1         1         1          1 |
 41. |  4066    2018    149618    191271      1         1         1          1 |
     |-------------------------------------------------------------------------|
 42. |  4066    2019    191271     49454      2         1         2          1 |
 43. |  4066    2019    164392     54310      1         1         1          1 |
 44. |  4066    2019     82890     58895      1         1         1          1 |
 45. |  4066    2019     58895     80027      1         1         1          1 |
 46. |  4066    2019    133843     81118      1         1         1          1 |
 47. |  4066    2019     81118     82890      1         1         1          1 |
 48. |  4066    2019     49454    106603      1         1         1          1 |
 49. |  4066    2019     80027    109283      1         1         1          1 |
 50. |  4066    2019     73590    125888      .         0         0          0 |
 51. |  4066    2019    125888    133843      1         1         1          1 |
 52. |  4066    2019    109283    135522      1         1         1          1 |
 53. |  4066    2019     54310    164392      1         1         1          1 |
 54. |  4066    2019    106603    191271      1         1         1          1 |
 55. |  4066    2019    135522    191271      1         1         1          1 |
     |-------------------------------------------------------------------------|
 56. |  4066    2020     49454     49454      1         1         1          1 |
 57. |  4066    2020    106603     54310      1         1         1          1 |
 58. |  4066    2020     58895     58895      1         1         1          1 |
 59. |  4066    2020    135522     73590      1         1         1          1 |
 60. |  4066    2020     81118     81118      1         1         1          1 |
 61. |  4066    2020    164392     82890      1         1         1          1 |
 62. |  4066    2020     54310    106603      1         1         1          1 |
 63. |  4066    2020    130988    109283      1         1         1          1 |
 64. |  4066    2020    109283    114980      1         1         1          1 |
 65. |  4066    2020    133843    125888      1         1         1          1 |
 66. |  4066    2020    125888    130988      1         1         1          1 |
 67. |  4066    2020     82890    133843      1         1         1          1 |
 68. |  4066    2020    191271    135522      1         1         1          1 |
 69. |  4066    2020     73590    164392      1         1         1          1 |
 70. |  4066    2020    169920    191271      .         0         0          0 |
 71. |  4066    2020    114980    191648      1         1         1          1 |
     |-------------------------------------------------------------------------|
 72. |  4066    2021    133843     49454      1         1         1          1 |
 73. |  4066    2021     54310     54310      1         1         1          1 |
 74. |  4066    2021    194181     58895      .         0         0          0 |
 75. |  4066    2021    125888     73590      1         1         1          1 |
 76. |  4066    2021     81118     81118      1         1         1          1 |
 77. |  4066    2021    169920    106603      .         0         0          0 |
 78. |  4066    2021    109283    106603      1         1         1          1 |
 79. |  4066    2021    164392    106603      1         1         1          1 |
 80. |  4066    2021    114980    109283      1         1         1          1 |
 81. |  4066    2021    191271    114980      1         1         1          1 |
 82. |  4066    2021    130988    125888      .         0         0          0 |
 83. |  4066    2021     58895    133843      1         1         1          1 |
 84. |  4066    2021    106603    164392      3         1         3          1 |
 85. |  4066    2021     73590    191271      1         1         1          1 |
 86. |  4066    2021     49454    191648      1         1         1          1 |
     +-------------------------------------------------------------------------+

.
. list if freq != freq_cm, sepby(gvkey fyear)

     +-------------------------------------------------------------------------+
     | gvkey   fyear   ANALYS1   ANALYS2   freq   present   freq_cm   presen~m |
     |-------------------------------------------------------------------------|
  2. |  4066    2017    119652     45722      .         0         0          0 |
 10. |  4066    2017    133843    109283      .         0         0          0 |
 11. |  4066    2017    160058    114980      .         0         0          0 |
 14. |  4066    2017    186784    128126      .         0         0          0 |
 21. |  4066    2017     73590    170633      .         0         0          0 |
     |-------------------------------------------------------------------------|
 31. |  4066    2018     73590    114980      .         0         0          0 |
     |-------------------------------------------------------------------------|
 50. |  4066    2019     73590    125888      .         0         0          0 |
     |-------------------------------------------------------------------------|
 70. |  4066    2020    169920    191271      .         0         0          0 |
     |-------------------------------------------------------------------------|
 74. |  4066    2021    194181     58895      .         0         0          0 |
 77. |  4066    2021    169920    106603      .         0         0          0 |
 82. |  4066    2021    130988    125888      .         0         0          0 |
     +-------------------------------------------------------------------------+

.
. list if present != present_cm, sepby(gvkey fyear)

The last listing is empty; there aren't any observations in which the two methods give different results for indicator variables.

Last edited by Nick Cox; 07 Jun 2025, 15:32.

Announcement