Page 1 of 1
changing from monthly to quarterly
Posted: Tue Mar 16, 2010 3:14 pm
by 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.
Re: changing from monthly to quarterly
Posted: Tue Mar 16, 2010 4:14 pm
by EViews Gareth
Do you want the new page to be balanced or unbalanced?
Re: changing from monthly to quarterly
Posted: Tue Mar 16, 2010 4:20 pm
by startz
unbalanced
Re: changing from monthly to quarterly
Posted: Tue Mar 16, 2010 5:00 pm
by 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.
Re: changing from monthly to quarterly
Posted: Tue Mar 16, 2010 6:36 pm
by startz
It is well known that Chris is a smart chap :D