To this post I have attached two databases. Database1: Contains the event firm information, involving the headings: Permno1, Dclrdt, marketcap1, Year1 and industry1. There are approximately 10869 event firm observations in database 1. Database2: Contains the NON-Event firm information, involving the headings: Permno2, Marketcap2, year2 and industry2. For each of the event firm observations in database1 (DB1) I need to match with a non-event firm observation in database2 (DB2) to create a database 3 (DB3) I would like to match the observations on the basis of: -Industry (must be the same number, between 1-7) -Year (must be the same year) -Size (no limits, just the closet match available for the given industry and year) Ultimately my objective to achieve: Database 3: Matched database. This contains 10869 event firms and its counterpart, the matched non event firm. DB3 holds the following headings: Permno1, Dclrdt, marketcap1, Year1 , industry1, Permno2, Marketcap2, year2 and industry2. I seek help on this highly complex command, data is attached below.
... View more