Error: Alpha series in specification

[moederpaard]

Hello,

I am trying to run two data sets an equation, both containing dates in the same order and some values. Unfortunately I get the following error message:

Alpha series in specification - SERIES02

@EXPAND can convert to catagorical dummies.

What am I doing wrong?

Thanks in advance

[EViews Gareth]

You're trying to use character data in a regression. You can't do that. Your series SERIES02 contains characters, not numbers.

[moederpaard]

Thanks for the reply.

However, after checking I did not find any characters except for the second row saying: "Last updated....." There are blank cells, could that be the reason?

For the full information, the cells contain the following:
left lightblue column contains dates,
the first white column contains the same dates,
the second white column contains numerical data. This second column contains differently formatted data from excel.


Last updated: 07/30/13 - 17:58
Imported from '------.xlsx'

1/02/1998      1.6417 
1/05/1998      1.6330 
1/06/1998      1.6335 
1/07/1998      1.6253 
1/08/1998      1.6114 
1/09/1998      1.6165 
1/12/1998      1.6221 
1/13/1998      1.6345 
1/14/1998      1.6301 
1/15/1998      1.6300 
1/16/1998      1.6337 

[EViews Gareth]

Post the workfile.

[moederpaard]

See attachment

[EViews Gareth]

Yep, that's character data, not numerical data.

Probably the easiest thing to do is clean it up in Excel before moving it into EViews. In all likelihood, it was character data in Excel too.

[moederpaard]

Thanks for the help, the problem is solved.

[rcan]

I want to run a VAR model in Eviews 7. However, after inserting the data an error pops up "alpha series in specification".
How can I solve this error?

See attachment for workfile. There are two variables.

[startz]

Convert sp500 to numbers. Try the @val function.

[Fran17]

Hola! A mi me sale error Alpha series in specifications-PNB
@EXPAND can convert to catagorical dummies.

Ayuda por favor, ya revise los datos del PNB y solo tengo datos numéricos