sample issue

[mark]

Hi
I have a excel series with 22,000 observations using the following format 2006-04-20
I have imported the series into eviews using numeric display "Period" a date format of "YYYY:MM"
I want to sample by year (6 years of observations), however when I input the sample code, it get's rejected everytime.

Any advice would be appreciated.

thanks

[EViews Gareth]

Could you provide more details?

What sample code do you input, and how does it get rejected?

[mark]

Hi
series name is "date"
using the sample menu:

@all
date ="2006:01" "2009:04"

Error message reads "error in sample: 2006:04 is not defined"

[mark]

Using the sample window

@all
year= 2005:04 2008:01


error in sample: 2005:04 is not defined

here is an extract of the raw data:


2005:04
2005:04
2005:04

[EViews Gareth]

Assuming your workfile is dated, you probably just need to type "2006:01 2009:04" in the top box of the sample dialog, and leave the bottom part blank.


If you really want to use the date series, then you would fill this in the bottom box:

date >= @dateval("2006:01) and date <= @dateval("2009:04")

[mark]

Hi - tried your solution to no avail

I've attached the workfile in an unstructed format along with the sample declaration. Hope you can help

[EViews Gareth]

Sorry, try this:
date >= @dateval("2006:01", "yyyy:mm") and date <= @dateval("2009:04", "yyyy:mm")