changing from monthly to quarterly

[startz]

If you have an unbalanced monthly panel (cross-section id PERMNO, dates in DATE), how do you create a quarterly panel programmatically? I don't need to copy the data over, just to get the structure set up.

[EViews Gareth]

Do you want the new page to be balanced or unbalanced?

[startz]

unbalanced

[EViews Glenn]

Trying to stump us Startz? This one is from Chris...

Code: Select all

pagecreate(id, page=quarterly) PERMNO @date(@datefloor(DATE, "q"))

will create the page you want named QUARTERLY.

[startz]

It is well known that Chris is a smart chap :D