Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Matching sample based on multiple variables

    Hi,
    I have two samples. Sample 1 (main sample) includes 200 companies from Sweden. Sample 2 includes 5000 companies from the US. Using sample 2, I want to find one match company for each company includes in sample 1. I want to find my match sample based on sic code (company industry identity), assets (company's assets value), ROA and audit fees.
    All the companies are identified by a specific identity number, ISIN number. Both samples show the variables: sic code, year, assets, ROA and audit fees.

    I would be grateful if one could help me that how can I find the match based on the several variables or criteria.

    Note:
    I am using mac and Stata 15.

    Best regards,
    Mahmoud

  • #2
    presumably you want to match some of the variables exactly and others within a caliper of some size (not shown in your question); if you want to match without matching to more than one member of the other file, I recommend the user-written "calipmatch"; if you want to match but allowing each observation to match more than once, I recommend the user-written "vmatch"; use -search- to find and download

    added in edit: to be clearer (maybe), -calipmatch- is for matching without replacement and -vmatch- for matching with replacement
    Last edited by Rich Goldstein; 18 Jul 2019, 05:42.

    Comment


    • #3
      Thank you for the guide Rich.
      I tried with the code below and faced with the r(122). Unfortunately, I have no understanding of caliperwidth and do not know how to fix it. Could you please tell me how can I determine a proper caliperwidth?

      . calipmatch, generate(newvar) casevar(case) maxmatches(1) calipermatch(Size Lev
      > erage ROA) caliperwidth(5)
      must specify the same number of caliper widths as caliper matching variables.
      r(122);

      Kind regards,
      Mahmoud

      Comment


      • #4
        sorry but the "proper" caliper width depends on subject matter knowledge; I don't know anything about your study and cannot comment on that

        as for the error message, you must have one caliper width for each variable listed in your caliper match earliest; you list 3 variables but only 1 width (I generally do not use this program as I generally want "with replacement" and thus, this is my understanding of the help file - someone else who actually uses this program may be able to clarify better)

        edited to fix some typos automatically inserted

        Comment


        • #5
          Thank you Rich!

          Comment

          Working...
          X