EViews.com

Hi,

I'm using EViews 7.

I'm importing data from Excel 2010. The file contains two diffrent text reprensentations for missing values : x and ..

I'm using the command wfopen and the na=".."

However, how can I feed the wfopen command to take into account x as the other missing value reprensentation ?

Thanks!

We don't allow you to specify more than one NA representation. However if you're reading in a numerical series, both "X" and ".." will be transformed to NA (along with any other text values).

Gareth,

EViews creates an alphanumeric series instead of a numeric series.

Can I convert the alphaseries to a numeric series ?

If so, what is the command?

Thanks!

@val

Many thanks!