Dear All,

I am a new user to STATA and I was requested to make a regression model for using the average of some variables over 4 years, so when I calculated the average for each company I got the average 4 times corresponding to each year of the company's data which led to the multiplication of my observations by 4 and hence it's affecting the results of my regression model.

How I can avoid that and have only 1 average for each company instead of 4?

Your help will be so appreciated.

Regards,

Mohammed Khaled