Hi, everyone. I'm using Compustat to attempt to compute an auditor industry specialist variable with the following method of calculation: Industry Specialization = Sum of square root of total assets of auditor clients (by gvkey) in a particular industry (sic code )divided by the sum of the square root of total assets of all clients of the auditor. Auditors with fewer than 10 clients per year are coded as =0. I plan to pull the auditor, fiscal year, gvkey, sic code, and total assets for each firm on a firm-year basis. I was thinking it might be possible to use some form of nested if first. statement using a table with that data, but I'm stuck and don't really know where to start with the coding, as I'm a SAS beginner. Any ideas? Thanks!
... View more