dissertation project

[Luke Driscoll]

Hi there. I have a very large data file with numeric energy ratings for houses by postcode, by the year they were inspected, and by tenure type. I would like to generate the average energy rating by postcode taking into account the year of inspection. So for example I would like the energy rating for houses in NW1 but the average to be calculated by the year. Does anyone have any advice?

[Nick Cox]

egen wanted = mean(rating), by(postcode year)

[Luke Driscoll]

Thanks, worked perfectly.