Hi,

I am looking for a solution to average the survey respones.
Below S007 is suvey respondent ID, loc is country name and fyear is the year. the variables B010 through B031 are the answers by each survey respondents, are labelled as string but there is a number behind varying from -4 to 4.

I need the respone consolidated for all respondents, like an average response for every loc and fyear.
Could someone help me achieve this please.

Much appreciated and many thanks in advance.

Array