create date series?

[startz]

Okay, I'm missing something obvious. I have a file with numeric variables Year, Month (1-12), Day (1-31) and time (hrs:min:sec). I want to make a dated workfile. What's the function/proc? And is there an easy way to have an "hourly" workfile?

[EViews Gareth]

EViews 7 and 8 support intraday frequencies, including hourly.

Just use Proc->Structure/Resize Current Page, then choose Dated-Specified by Date Series, then enter the names of your series.

[startz]

EViews 7 and 8 support intraday frequencies, including hourly.

Just use Proc->Structure/Resize Current Page, then choose Dated-Specified by Date Series, then enter the names of your series.

Hmmm, if I enter Year Month Day Time I get told "unable to interpret date specification" I assume this is because Year is things like 2005 while Time is in hh:mm:ss format. Is there a way to make a "date series" from my four variables? Or another approach?

[EViews Gareth]

So when you said time was a numeric variable, you actually meant it is an Alpha?

Post your workfile

[startz]

No, time is numeric. But EViews autoChrismagically read it in, recognized it, and assigned it the display format hh:mm:ss.

So the first few entries are
20:22:40
20:26:40
20:30:40

or
0.8490740740740741
0.8518518518518519
0.8546296296296296

But they don't include the date. If I display as day time they look like 1/1/0001 20:22:40

[EViews Gareth]

Post your workfile

[startz]

I did

Code: Select all

series hour = @datepart(time,"hh") series minute = @datepart(time,"mm") series second = @datepart(time,"ss.s")

and then followed your previous suggestion.