Page 1 of 1

Panel Data - Time Series Manipulation

Posted: Thu Feb 09, 2023 7:27 am
by 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

Re: Panel Data - Time Series Manipulation

Posted: Thu Feb 09, 2023 7:49 am
by EViews Gareth

Code: Select all

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