hello,
I'm a new user of eviews: I have some problems importing data from an excel file. I don't undertstand why when I use the function "open-foreign data as a workfile" and I select an excel file, filled with numeric data, eviews creates series of alphanumeric data, then when I open the series I see numbers in the columns. but since eviews thinks that they are alphanumeric data, when I try to create a regression with another numeric serie it doesn't work. How can I change in numeric data these series of alphanumeric data? I have Eviews 6 student version. I read that someone else had the same problem, I tried to follow what you suggest to do, but I wasn't be able to solve the problem. What's more, when I import data from another excel file it works properly, and I'm able to create series of numeric data without any problem. Could you help me?
Thanks in advance.
Marta
from alphanumeric to numeric data
Moderators: EViews Gareth, EViews Steve, EViews Moderator, EViews Jason
from alphanumeric to numeric data
- Attachments
-
- DISTRIBUZIONE REDDITI.xls
- this file works
- (18 KiB) Downloaded 260 times
-
- DATI INDUSTRIA.xls
- this file doesn't work
- (22 KiB) Downloaded 275 times
-
EViews Gareth
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13604
- Joined: Tue Sep 16, 2008 5:38 pm
Re: from alphanumeric to numeric data
It is because EViews 6 doesn't recognise the commas as decimals. If you change your commas to points, it should work.
Who is online
Users browsing this forum: No registered users and 2 guests
