Problem with importing, panel data

For questions regarding programming in the EViews programming language.

Moderators: EViews Gareth, EViews Moderator, EViews Jason, EViews Matt

innadel
Posts: 2
Joined: Sun Jun 20, 2010 8:54 am

Problem with importing, panel data

Postby innadel » Sun Jun 20, 2010 9:09 am

Hi, I have a problem, stupid one

I want to have a panel data workfile page with all countries together and another one with each variable for each country.

I am first just importing this file (i made it smaller bcs it was too big) and it already does not read the time and the country . Cannot understand why. It reads the rest

Then with this command (pagestack argentina australia brazil canada chile china euro_area germany india indonesia japan korea new_zealand russia south_africa saudi_arabia turkey uk usa @ XRvsD CPI IR IP M1 XRvsE URATE) i stack the data in new page. And that works fine

Then I want to have the data unstacked in another page and i use this command : pageunstack(namepat="?_*") id01 id02 @ XRvsD CPI IR IP M1 XRvsE URATE
But what happens is only that i have each variable only for one country and there is a pool with the country identifiers. (which is not what i want)

I tried to do it also by creating balanced panel, but bcs it does not read the country or the time, i cannot do it this way.
Attachments
test.xls
(1.91 MiB) Downloaded 424 times

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

Re: Problem with importing, panel data

Postby EViews Gareth » Mon Jun 21, 2010 8:07 am

Could you tell us exactly what you've done so far, and exactly why that isn't working?

innadel
Posts: 2
Joined: Sun Jun 20, 2010 8:54 am

Re: Problem with importing, panel data

Postby innadel » Tue Jun 22, 2010 10:15 am

i found a way, i tried all possible ways...it could never read time and date....in the end i rearranged my excel file, to have all variables in columns with an extension _for each country....

now i have another question...related to panel data....how can i have regression output as a summary but also as each country specific regression?

thanks

fmgoto
Posts: 76
Joined: Thu Jan 15, 2009 5:01 am
Location: Brasilia, Brazil

Re: Problem with importing, panel data

Postby fmgoto » Tue Jun 29, 2010 7:00 am

Concerning importing, you can import everything as an unstructured workfile and then set the panel parameters within that workfile. Worked for me.

As for the regression, just run a loop!

ran_v3000
Posts: 2
Joined: Sun Sep 19, 2010 9:50 am

please help me

Postby ran_v3000 » Sun Sep 19, 2010 10:25 am

i have data of 22443 person and 15 variables that are related to these person for 3 years(1380,1381,1382).but i dont know how to insert these data in to eviews as stack.
these data are now in excel and look like this:

person/ age.80 /age.81/ age.82 /li.1380/ li.1381 /li.1382 ....
1 / 20 / 21 / 22 / 1000 / 1140 /1200
2 / 34 / 35 / 36 / 2347 / 2432 / 3211
.
.
.

please help me i don't know how to work with eviews.


Return to “Programming”

Who is online

Users browsing this forum: No registered users and 2 guests