Representation of panel-structure in worksheet

[dagfinnrime]

Hi,

I have a panel with large T and small N. It's an unbalanced panel. I would like to have the dated panel structured so that when I open a series I first see t1 and all cross-sections for that date, then t2 and all cross sections for that date etc. I.e, I want a T-N view of the data. Now it is a N-T view when I open a series.

To be concrete: I have auction data, with dates, bidders, and bids (3 dimensions). In order to estimate I create 2-dim by ...

Code: Select all

pageunstack(page="db2",namepat="*_?") bid_id auc_date bidder_id @ bid_*

This gives me exactly what I want (I guess since I list auc_date before bidder_id).

In order to make it recognize that it's a (unregular) dated panel, I do ...

Code: Select all

pagestruct @date(auc_date) bidder_id

Either way I write the sequence in the pagestruct-command, it comes out with cross-section first and date next. How can I get it the other way, first date, then cross-section?

I notice that it doesn't handle irregularly spaced data. Is this the problem?

For some I guess the interesting part to follow is each cross-section through time (N-T), but for me the interesting part is the event an auction, so I need T-N.

I use Eviews 8, august build.

Thanks in advance,

Dagfinn

[EViews Gareth]

If hitting the wide +/- button on a series doesn't quite do it for you (it shows the unstacked view in either dimension, but not the stacked), you'll have to create a group containing the series you want, plus the date series and cross-section series, then sort by date then cross-section. Which is clunky.