Hi again. Here's the problem I am facing now. I have two data sets. One that looks like #1 and has all the information about firms and directors. And the other that looks like the example below based on your code in #14. I can calculate whether the director has served in the same size tercile or not based on #2 but that gives me the information relative to that specific firm. Suppose I want to know the information for the following example data set, what do I do then? In the data set below, all the seats a director holds in the previous year are not listed, therefore, if I want to know if the director has served in the same size tercile, I can't determine that.
This data set is large since I have 1,000 random (unpicked) directors for every director picked.
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input str6 firmid double(fyear directorid) byte selection "001004" 2005 1147 0 "001004" 2005 2455 0 "001004" 2005 2615 0 "001004" 2005 3162 0 "001004" 2005 3162 0 "001004" 2005 3335 0 "001004" 2005 4669 0 "001004" 2005 5769 0 "001004" 2005 6098 0 "001004" 2005 6098 0 "001004" 2005 6897 0 "001004" 2005 7209 0 "001004" 2005 7683 0 "001004" 2005 7801 0 "001004" 2005 8036 0 "001004" 2005 8658 0 "001004" 2005 8803 0 "001004" 2005 9960 0 "001004" 2005 10122 0 "001004" 2005 10122 0 "001004" 2005 10339 0 "001004" 2005 13187 0 "001004" 2005 14651 0 "001004" 2005 15482 0 "001004" 2005 16567 0 "001004" 2005 16672 0 "001004" 2005 17103 0 "001004" 2005 17103 0 end
Comment