Bookmark and Share

Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: 1:1 match and identifying result

From   uniseminar uniseminar <>
Subject   st: 1:1 match and identifying result
Date   Thu, 26 Apr 2012 23:17:50 +0200

Hi all,

My - beginners - problem concerns the 1:1 matching of a treated group
of companies to an untreated by three variables. Two of the
variables need to be exact matches and one should be in a range of 25%
difference. All numeric: founding year, target year, sales.
my data looks similar to this:
Company1 target-year1 sales1 founding-year ID1 ...
Company1 target-year2 sales2 founding-year ID2 ...
Company2 target-year1 sales1 founding-year IDx+3...
Company2 target-year2 sales2 founding-year IDx+4...

I tried to work on several matching procedures with merge, vmatch,
psmatch2 nnmatch etc. Neither was suitable for me...
vmatch was matching the three variables, but does not give me the
unique identifier of the matched company next to the treated company.
Further question: If I would receive the ID of the matched comp in the
line of the treated comp(thats the goal), how can I make sure to
compare these two? Something like: if ID of matched is found under
another variable in another line of treated comps then subtract sales
treated from sales matched...

Hopefully this is understandable...!?

Thank you in advance!
*   For searches and help try:

© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index