Hello all,

I need your help regarding rangestat command. I have a panel dataset with the panel dimensions as stores and weeks. I have the sales price of 11 products in each combination of stores and weeks.

I want to create an average price for each product across the other stores but within the same week. For instance, for product 1, I want the average price of product 1 sold at all the stores in a given week, etc.

I am using the command

rangestat (mean) average_price = price, interval(store 1 137) excludeself by (product week)

I am not sure if I am using the command correctly. I tried to compute the values of a couple of observations manually to validate te results and I think they are not the same. For instance, I filtered my data to only include product 1 and week 1. I then calculated the average price of product 1 sold in week 1 at all the stores. I got a different result.

Would you please help? Am I defining the command correctly? the interval should include the stores, am I right?