Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: convert yearly data into monthly and interpolate
From
Nick Cox <[email protected]>
To
[email protected]
Subject
Re: st: convert yearly data into monthly and interpolate
Date
Tue, 19 Apr 2011 09:23:57 +0100
This is reminiscent of a question asked recently by Ben Ammar. See the
thread starting with
http://www.stata.com/statalist/archive/2011-04/msg00131.html
Perhaps terminology, or at least its use, varies between fields, but
your problem strikes me as one of imputation, not interpolation. Any
way, it appears that there are various different ways to fudge this.
Which do you want? How do you propose to re-insert any seasonality
that has been lost?
Nick
On Tue, Apr 19, 2011 at 8:55 AM, D-Ta <[email protected]> wrote:
> Dear List Users,
>
> I have the following yearly data.
>
> id Label alq2_2000 alq2_2001 alq2_2002
> 1 group1 19,3 19,8 18,2
> 2 group2 19,3 19,8 18,2
> 3 group3 30,1 24,5 22,9
>
>
> the alq2_year variables measure group specific unemployment in a given year.
> I would like to merge it with another data set which consists of monthly
> data. Before converting my yearly data into a monthly format, I would like
> to interpolate it such that i get monthly interpolated estimates of alq2. i
> would appreciate if someone could help.
>
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/