Dated data tabel

[Lauw]

I make use of a panel data set. Whenever i use the dated data table, the values that come up are the medians per year. Is there any way to change this to average values. I also believe that the data that comes up is from an individual sample, and not the common sample.
Using Eviews 7.2.
Any help would be greatly appreciated!

[EViews Gareth]

Unfortunately dated data tables are not really panel friendly, and there is no way to change that behaviour.

[Lauw]

Would there be an easy way to divide the data per year. I'm using an excel file but some data has 7 years of entries, while others have only 2 or 3

[EViews Gareth]

Set the sample to be each year?

[EViews Glenn]

I may be missing something in the question, but it strikes me that

Code: Select all

series ymeans = @meansby(y, @year)

will give you the year means matched back to each observation. You could then use a sample filter to get a unique set of observations.

[Lauw]

First off thank you all very much for your time and help.

Secondly, I'm unable to set the sample to a single year only, I believe this is because it's panel data, but im unsure.

Lastly, I'm completely in the dark when it comes to coding. Would it take me long to figure it out and use Glenn's code?

[EViews Gareth]

You can set the sample to be a single year in a panel. Same way you would in a non-panel.

To use glenn's code, just copy and paste it into the EViews command window, and hit return.

[Lauw]

I still can't use glenn's code or set sample to one year only. It keeps telling me that y is not defined. Maybe I had to mentionthat I open the variables as group and then use view>dated data tabel

[EViews Gareth]

Replace "y" with the name of your variable.