Page 1 of 1
Convert quarterly data to monthly data
Posted: Sun Jan 31, 2010 8:12 pm
by buianhtuan2000
I have quartely data on GDP. Could anyone advise me how to change to monthly data?
Thank you very much
Re: Convert quarterly data to monthly data
Posted: Mon Feb 01, 2010 8:56 am
by TomDoan
Re: Convert quarterly data to monthly data
Posted: Mon Feb 01, 2010 11:41 am
by ivory4
Suppose I have 8month data for each year, I would like to estimate a model with monthly data.
And the timing of the data each year is different, e.g. 1,5,6,7,8,10,11,12for some years while 1,2,3,4,8,9,10,11 for some others.
Is that possible to disaggregate the data?
Re: Convert quarterly data to monthly data
Posted: Mon Feb 01, 2010 11:55 am
by TomDoan
Kalman smoothing with a state-space model. That's what DISAGGREGATE is doing. Since it appears that you want the simpler "interpolation" (as opposed to "distribution", where sums across periods need to match), you can pick a relatively simple state space model, like a RW-AR(1), and Kalman smooth. You just want to set your data up as monthly with NA's where you have skips.
Re: Convert quarterly data to monthly data
Posted: Mon Feb 01, 2010 2:56 pm
by ivory4
TomDoan wrote:Kalman smoothing with a state-space model. That's what DISAGGREGATE is doing. Since it appears that you want the simpler "interpolation" (as opposed to "distribution", where sums across periods need to match), you can pick a relatively simple state space model, like a RW-AR(1), and Kalman smooth. You just want to set your data up as monthly with NA's where you have skips.
What if I just want to fill in the missing data points without changing the current ones?
Re: Convert quarterly data to monthly data
Posted: Mon Feb 01, 2010 4:21 pm
by TomDoan
That's what will happen. You use a state space model with no measurement error, so if there's an actual observation at a time period, that's your smoothed value.
Re: Convert quarterly data to monthly data
Posted: Mon Feb 01, 2010 11:50 pm
by ivory4
TomDoan wrote:That's what will happen. You use a state space model with no measurement error, so if there's an actual observation at a time period, that's your smoothed value.
Great. Rats is really versatile.
Re: Convert quarterly data to monthly data
Posted: Tue Feb 02, 2010 7:32 am
by TomDoan
ivory4 wrote:Suppose I have 8month data for each year, I would like to estimate a model with monthly data.
And the timing of the data each year is different, e.g. 1,5,6,7,8,10,11,12for some years while 1,2,3,4,8,9,10,11 for some others.
Is that possible to disaggregate the data?
That's similar to
http://www.estima.com/forum/viewtopic.php?f=3&t=545. If you set up your data file with date fields like
1990:1 xxx
1990:5 yyy
1990:6 zzz
etc.
and read into a monthly calendar, DATA will insert NA's for the missing months. In that case, you don't even need to patch NA's into the Y series on DLM---just use the data as it's read in.