Page 1 of 1
create date series?
Posted: Mon Aug 26, 2013 1:02 pm
by 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?
Re: create date series?
Posted: Mon Aug 26, 2013 1:12 pm
by 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.
Re: create date series?
Posted: Mon Aug 26, 2013 2:14 pm
by 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?
Re: create date series?
Posted: Mon Aug 26, 2013 2:18 pm
by EViews Gareth
So when you said time was a numeric variable, you actually meant it is an Alpha?
Post your workfile
Re: create date series?
Posted: Mon Aug 26, 2013 2:23 pm
by 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
Re: create date series?
Posted: Mon Aug 26, 2013 2:34 pm
by EViews Gareth
Re: create date series?
Posted: Mon Aug 26, 2013 2:54 pm
by 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.