Create mean (time series data) from panel data

[sarah_ec]

Hi all,

I have a panel data set and I would like to create a series with the mean of the cross-sectional data per year, so that I get time series data afterwards. However, I want to use only data from those id-series, where a specific condition is met. Can anyone help me out with the command?

So if I have a panel data series "A" I want to have the mean per period of all those data points where a condition "B" is met.

Thanks to everyone who reads this!

[EViews Gareth]

Code: Select all

series timemeans = @meansby(X, @date, "if condition")