Hello, I am a beginner in SAS, I hope I can get some help from the community. I am trying to calculate the industry median R&D expense for each year excluding the focal firm, the industry is indicated by the 4-digit SIC code. For example, assume the data is from 2000-2005 for 10 firms: A, B, C, D, E have same SIC code, and F, G, H, I, J have the same SIC code, each firm has data covering those 6 years, how do I get the industry median RD expenses excluding each focal firm for each industry and year? Thanks so much! yzs0056
... View more