Page 1 of 1
Force freq=q when pageload .xlsx
Posted: Mon Apr 08, 2013 8:13 am
by paues
Is there some way to force pageload to import data using a particular frequency? Inspired by
an old forum post, I have tried the command below. It gives me the observations I want but imports them as an undated panel.
Code: Select all
pageload myFile.xlsx range="Sheet1!B2" byrow names=(test1,test2,test3) @smpl 2010q1 2012q3 @freq q
Re: Force freq=q when pageload .xlsx
Posted: Mon Apr 08, 2013 8:28 am
by EViews Gareth
Try:
Code: Select all
pageload myFile.xlsx range="Sheet1!B2" byrow names=(test1,test2,test3) @freq q 2010
Re: Force freq=q when pageload .xlsx
Posted: Mon Apr 08, 2013 8:41 am
by paues
That works, but it does not allow me to restrict what observations should be read. It seems that adjusting the range to cover only the cells that I want works (below). That however leaves me with the hassle of having to figure out what would be the last column (similar to what I have mentioned in
this post).
Code: Select all
pageload myFile.xlsx range="Sheet1!B2:L4" byrow names=(test1,test2,test3) @freq q 2010q1
Re: Force freq=q when pageload .xlsx
Posted: Mon Apr 08, 2013 8:44 am
by EViews Gareth
Since you're doing a pageload, you could always do the pageload followed by a pagecontract to lop off the ones you don't want.
Re: Force freq=q when pageload .xlsx
Posted: Mon Apr 08, 2013 9:23 am
by paues
Thanks for the tip! The way I suggested now seems a bit idiotic :D Nevertheless, I think that it should be possible to combine the @freq argument with a @smpl argument.