Dear all,
I am working with firm level data where I want to generate a variable at the firm level which is average of sales of the firm for state-industry combination level. But while generating this new variable I want the average in such a way that it calculates the average for all firm excluding that ith firm.
Please suggest