## Using monthly series to forecast quarterly data

For technical questions regarding estimation of single equations, systems, VARs, Factor analysis and State Space Models in EViews. General econometric questions and advice should go in the Econometric Discussions forum.

Moderators: EViews Gareth, EViews Moderator

miorinnovo
Posts: 137
Joined: Sun Mar 01, 2015 5:01 pm

### Using monthly series to forecast quarterly data

Hi all,

I'd like to try to forecast a quarterly series using a monthly data set. Essentially I'd like to have one explanatory variable being the monthly series with one month left in the quarter, another being the same series but with two months left in the quarter, etc. Can anyone tell me how I can set this up?

thanks

miorinnovo
Posts: 137
Joined: Sun Mar 01, 2015 5:01 pm

### Re: Using monthly series to forecast quarterly data

I could do this by automatically deleting the third month in every quarter and replacing them with the fourth month, and another series deleting months 2 and 3 and replacing them with the first month. Does anyone know how to do that?

Did you use forum search?
Posts: 1518
Joined: Thu Nov 20, 2008 12:04 pm

### Re: Using monthly series to forecast quarterly data

I am really not sure if I understand it correctly. But, I'll give it a try:
Suppose, the quarterly and monthly variables are called y_q and x_m, respectively. And let's assume that they are both stored in the same workfile with page names "quarterly" and "monthly". Since the forecasting exercise will take place in the quarterly frequency, you should import the monthly variable:

Code: Select all

`pageselect quarterly 'select the quarterly pagecopy(c=f) monthly\x_m x_q 'copy and paste the first values of the monthly variable and renameequation eq.ls y_q c x_q x_q(-1) 'you do not have to generate the second variable`

### Who is online

Users browsing this forum: Google [Bot] and 11 guests