correlation with different sample range

[vytama]

Hello,
I am new to Eviews. (using 7). I have two series (x and y) with sample range 1990m1 to 1991m12. I want to find the highest correlation between two series by keeping y fixed with range of 1991m1 to 1991m12 and moving series x 1 month back: range 1990m12 to 1991m11, and so on untill 12 months back. My question is how can set these separate ranges for each series? thanks

[EViews Gareth]

Rather than changing the sample, just lag X.

So first do the correlation between Y and X(-1). Next do the correlation between Y and X(-2), and so on...

[vytama]

Thank you for quick response. I tried using lags, however I get different result in excel. Just to confirm, my sample range is1990m1 to 1991m12. For lag(-1), in excel I have x(1990m12 to 1991m11) and y stays fixed at (1991m1 to 1991m12). for lag (-2) x is (1990m11 to 1991m10) and y stays fixed at (1991m1 to 1991m12). Is eviews using the same logic?

[EViews Gareth]

Yes.