Page 1 of 1

Force conversion of alpha to numeric series

Posted: Wed Aug 17, 2022 7:09 am
by denolo
Hello,

I am using Eviews 12. My dataset includes several series that contain a number followed by a character (for example "3.46 d"). When importing, Eviews recognizes these series as alpha series.

I could manually adjust the data type for each series when importing the dataset, but the dataset is quite large and I would need to repeat this for every update.

Is there an easy way to force a conversion from alpha to numeric series (ignoring all no numeric characters) ideally while importing?

Many thanks.

Re: Force conversion of alpha to numeric series

Posted: Wed Aug 17, 2022 9:54 am
by EViews Gareth
Unfortunately not. Best bet is to write an EViews program that loops through all the alpha series (you can use @wlookup to list them) and do the conversion in a loop.