Page 1 of 1

"Alpha Series in Specification" Error (EViews 9)

Posted: Sat Jun 17, 2017 11:12 pm
by Bleaux
Dear all,

I am having trouble converting a variable (date/time) into a numerical variable. I know one of the problems of this error is that there are any spaces or something like that. This is what I've done so far:
I) @val() function;
II) alpha var2=@replace(variable," ",".")
show var2
d variable
And all the other steps in viewtopic.php?t=74
III) Replaced all spaces with (" ",".") in Excel.

I've attached the unprocessed .csv file so I hope one of you can take a look at it.

Regards,

Re: "Alpha Series in Specification" Error (EViews 9)

Posted: Sun Jun 18, 2017 9:12 am
by EViews Gareth

Code: Select all

series datetime = @dateval(local_time, "DD.MM.YYYY HH:MI:SS.000")

Re: "Alpha Series in Specification" Error (EViews 9)

Posted: Mon Jun 19, 2017 9:47 am
by Bleaux
Works!