Index with KLD data

[Viktoria Maier]

Dear fellow Stata users,

I want to compute an index in Stata from KLD data (CSR ratings) for companies.

In my dataset, I have a list of strenghts and a list of concerns from which I want to build the sum. Each strength should add 1 and each concern should substract 1.

Then I need to find the maximum net value for each year (is there an automatic way to do this?) and take the net sum of each company and divide it by the maximum value.

Does anyone know how to do this best?

[wbuchanan]

I'm not sure what the ratings are, but that would impose a significant assumption on the data with regard to the value of each strength/concern. Without knowing your data there isn't much that anyone can suggest other than coding concerns with a value of -1 and strengths with a value of 1. From there you can use one of several egen functions to compute the sum.

[Viktoria Maier]

But how do I code concerns and strengths like that?