Force conversion of alpha to numeric series

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator

denolo
Posts: 3
Joined: Tue Dec 20, 2016 7:20 am

Force conversion of alpha to numeric series

Postby denolo » Wed Aug 17, 2022 7:09 am

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.

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13294
Joined: Tue Sep 16, 2008 5:38 pm

Re: Force conversion of alpha to numeric series

Postby EViews Gareth » Wed Aug 17, 2022 9:54 am

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.
Follow us on Twitter @IHSEViews


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 13 guests