sample range dependent on the time series
Posted: Wed Mar 24, 2010 10:32 am
Hi,
I am wondering whether there is any way to make the sample range dependent on the observations within a series.
To be more precise let's assume the following situation.
I have a sheet with annual frequency and 1990 - 2010 sample. There is also a time series in this sheet with numerical values for 1995-2005 and NA values for the remaining time references.
How can I set up a sample range so that it is only as of the first non-missing observation in the series/ second non-missing observation/ the last non missing observation?
I would appreciate the help very much.
Best, k
I am wondering whether there is any way to make the sample range dependent on the observations within a series.
To be more precise let's assume the following situation.
I have a sheet with annual frequency and 1990 - 2010 sample. There is also a time series in this sheet with numerical values for 1995-2005 and NA values for the remaining time references.
How can I set up a sample range so that it is only as of the first non-missing observation in the series/ second non-missing observation/ the last non missing observation?
I would appreciate the help very much.
Best, k