Inserting Data from Excel

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

Giorgos
Posts: 3
Joined: Thu Aug 18, 2011 11:15 am
Location: Greece

Inserting Data from Excel

Postby Giorgos » Thu Aug 18, 2011 11:36 am

Hi!! i am new here and i am also new user of Eviews
I 've faced recently a problem and i would like some help !!
I want to insert data from excel to eviews
I cite briefly how i have sorted the data in excel .... I have usa uk jp aus ..... and some variables like GDP CPI etc for the years 2005 2006 2007 etc
i sorted data as follows
year id GDP CPI
2005 usa x1 y1
2005 uk x2 y2
2005 jp . .
.
.
2006 usa x3 y3
2006 uk x4 y4
2006 jp . .
.
.
2007
and so on .....
I want to insert the data in eviews and i don't know how ( I want balanced panel ) I saw many different ways of inserting data in eviews but i haven't seen this way yet .
I would be very happy if anybody could help me !!
With kind regards Giorgos

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

Re: Inserting Data from Excel

Postby EViews Gareth » Thu Aug 18, 2011 11:56 am


Giorgos
Posts: 3
Joined: Thu Aug 18, 2011 11:15 am
Location: Greece

Re: Inserting Data from Excel

Postby Giorgos » Thu Aug 18, 2011 2:48 pm

Thanks for the help !
I saw the link but none of the ways described there follows the pattern that i need .
The only solution until now is to resort the data in excel to follow one of the default eviews patterns ...
Tanks anyway!!

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

Re: Inserting Data from Excel

Postby EViews Gareth » Thu Aug 18, 2011 2:52 pm

Yours is the same as the first example given, with the exception that yours runs YEAR/Country, rather than Country/YEAR. However EViews doesn't care about that, so just follow the same instructions as the first example and it will just work.

Giorgos
Posts: 3
Joined: Thu Aug 18, 2011 11:15 am
Location: Greece

Re: Inserting Data from Excel

Postby Giorgos » Fri Aug 19, 2011 1:52 pm

thaks a lot!!


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests