Hi guys,
I'm using Evies 7.2
I'm trying to import panel data from excel. I go to File, open, foreign data as work file. I select my excel file.
Everything looks good so far., I go to Step 1 and select the sheet. How cool, I see my data!
I go to step 2, and I toggle through, making sure everything is good. Data types look right. I see my data. Still good.
I click next. Now in Step 3, suddenly all my data is coming through as N/A!
What's the problem here?
Attaching the excel too that I am trying to import.
Panel Data Import problem
Moderators: EViews Gareth, EViews Steve, EViews Moderator, EViews Jason
Panel Data Import problem
- Attachments
-
- Brazil revised.xlsx
- (47.52 KiB) Downloaded 337 times
-
EViews Gareth
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13604
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Panel Data Import problem
Works for me. What's the build date of your copy of EViews? (Available from Help->About EViews).
Re: Panel Data Import problem
Thank you for replying, it seems to be working well when I tried importing again today I don't know what was the problem earlier...
Re: Panel Data Import problem
Hi everyone,
I am trying to import panel data from Excel into Eviews 8. I have attempted to follow the you tube tutorial on it but keep getting the message 'Bank is not defined'. This is my first time using Eviwews and have been blundering about in the dark with it.
I have attached my excel file. If anyone could give me any advice or nudge my in the right direction I would apprecaite it. The software is completely over my head.
Thanks in advance,
Siobhan
I am trying to import panel data from Excel into Eviews 8. I have attempted to follow the you tube tutorial on it but keep getting the message 'Bank is not defined'. This is my first time using Eviwews and have been blundering about in the dark with it.
I have attached my excel file. If anyone could give me any advice or nudge my in the right direction I would apprecaite it. The software is completely over my head.
Thanks in advance,
Siobhan
- Attachments
-
- Data 04 March CUT.xlsx
- (156.46 KiB) Downloaded 398 times
-
EViews Gareth
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13604
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Panel Data Import problem
First thing you should do is make your column and row headings in Excel into shorter codes without special characters. They're too long and unwieldy right now.
-
Agnese_Alise
- Posts: 1
- Joined: Wed Apr 02, 2014 2:29 am
Re: Panel Data Import problem
Hi!Thank you for replying, it seems to be working well when I tried importing again today I don't know what was the problem earlier...
i had the same problem till i found out it is because in the same time was opened both files/programs - eviews and excell. When i closed my excell file and imported it to eviews then everything somehow worked out and eviews recognized all data!
Who is online
Users browsing this forum: No registered users and 2 guests
