Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.

[no subject]

```So my question is the following: After importing this dataset into
Stata how do I handle the problem with the dates that I described
above. I
am asking this because I want to run a regression of interest rates
I_{it} on some other variables. Where I_{it} is the interest rate of
country i at time t. But for each i I have different start and end
date for the time series of interest rates.

thank you
Joales

On 6/5/12, joales salbdralor <joalessakafiora@googlemail.com> wrote:
> I have data on 4  types of interest rates. These rates evolve over
> time and across regions of countries . So for each type  of interest
> rates I want to run a regression of rates  on some other variables.
> So my regression for one type of  interest rate will be I_{ij}_t= a
> +regressors +error term.
> where I_{ij}_t is the absolute difference in rates between two
> locations i and j at time t. Note that i and j can be locations in
> the same country or locations at different countries.
> What I need  is construct a vector with all the pairs of locations for
> a specific t. Put differently, I want to see how the interest rate
> differential evolves over time for each pair of region. But the
> monthly time series data I have available are heterogeneous across
> countries
>
> Take a look at the following table
>
>    Country A                country B                  country C
>      country D     country E   country F
>
>     '2-11-2002 '                07-12-2002'       '23-11-2002'
> '26-10-2002'    '27-12-2002'
> .
> .
> .
> 09-10-2004'               '06-11-2004'              02-10-2004'
>      09-10-2004'
>
>
> From the above table, In  country A the time starts at  "2/11/02 , in
> country B the time starts at "07/12/02 and so forth.
> Furthermore,  in  country A the time ends at  "9/10/04 , in country B
> the time ends  at "06/11/02 and so forth.
> As a result of this anomaly in the beginning of time, the  period for
> each country differs
>
> So I cannot construct these pairs because for a particular time, t,
> the rate exists in one location, but the rate in another location
> starts after t or ends before t.
>
> So the main thing I need to define is what I want done when data has
> not yet started or is already finished in another country. I do not
> know actually what the best solution is. This is my main question.
> I found something about extrapolation (if this is to be the solution)
> but I learn that extrapolation usually has quite a wide margin of
> error!! Apart from that, I have no idea how to implement it in Stata.
>
> Do you think that it would be better to try and create a more
> symmetric sample so as the start and end dates across countries to be
> very similar?
> It is a data analysis problem. I need some help....
>
> Joales
> *
> *   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/
>
*
*   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/
```