Panel Data - Time Series Manipulation

[monstromart]

Dear All,

I have a workfile structured as a panel. I would like to do some manipulations in the time series dimension. For example, for the variable X, I want to take (X-X(-1))/mean(X). Is it possible? This should be done for every cross section.

I attached the workfile. I may want to do it with the series "sale"

I hope it makes sense.

Thanks in advance,
Fabio

[EViews Gareth]

Code: Select all

series mysales = (sale-sale(-1))/@meansby(sale, @crossid)