Hi,
I have a panel data (firm-year level). Anyone knows how to construct Peer firm average, which is the average of all firms within an industry-year combination, excluding the ith observation (excluding the focal firm and only include all the other firms in the industry)? Industries are defined by 3-digit SIC codes.
I only know how to calculate the average of all the firms in the industry. bys sic3 year: egen PeerAverage=mean(Variable).
Thanks in advance!
Related Posts with Peer firm average
New version of xtdcce2 and xtcd2. New package xtcse2- cox regression with shared frailty or vce cluster
- Generating a new variable as a result of comparing the mean of a variable (t-test) in two different times
- generate variable: birth order of children (ages 0 to 17) in household
- Create mean variables of a subgroup for the whole group
Subscribe to:
Post Comments (Atom)
0 Response to Peer firm average
Post a Comment