Panel Data Import problem

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

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

jags
Posts: 4
Joined: Sun Aug 11, 2013 3:59 pm

Panel Data Import problem

Postby jags » Sun Aug 11, 2013 4:16 pm

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.
Attachments
Brazil revised.xlsx
(47.52 KiB) Downloaded 338 times

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

Re: Panel Data Import problem

Postby EViews Gareth » Mon Aug 12, 2013 7:58 am

Works for me. What's the build date of your copy of EViews? (Available from Help->About EViews).

jags
Posts: 4
Joined: Sun Aug 11, 2013 3:59 pm

Re: Panel Data Import problem

Postby jags » Mon Aug 12, 2013 11:15 am

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...

Siobhan91
Posts: 1
Joined: Tue Mar 04, 2014 11:26 am

Re: Panel Data Import problem

Postby Siobhan91 » Tue Mar 04, 2014 11:37 am

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. :cry:

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. :shock:

Thanks in advance,

Siobhan
Attachments
Data 04 March CUT.xlsx
(156.46 KiB) Downloaded 400 times

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

Re: Panel Data Import problem

Postby EViews Gareth » Tue Mar 04, 2014 11:45 am

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

Postby Agnese_Alise » Wed Apr 02, 2014 2:38 am

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...
Hi!
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!


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests