PANEL DATA IMPORTING

[lnp3]

Dear forum,

I really need your help!! I am trying to make sure that I have imported panel data into Eviews 7 correctly.

Can you please check my file? I am attaching both Excel and Eviews 7 files. This time, my unit of observation is "countries" rather than "banks".

however, It is strange that there are 644 observations. It should be more than that. There are 86 variables, 7 countries, 22 years. Where is 28 coming from?

I followed Eviews Gareth's suggestions:

After importing, he told me to do this. I have replaced "banks" with "countries"

Proc->Reshape->Unstack

Then enter "countries" in the first box, enter "Years" in the second box, and then change the third box so that it is "?*" rather than "*?".

This will create a new page where each series starts with either "equity.." or "netinc...".

From that new page do this:
Proc->Reshape->Stack

Then enter "gdp?" in the first box and hit ok.

That will create the page you want. The only thing left to do is to structure it as a panel.
Click on Proc->Structure/Resize.
Change the structure type to dated panel
Set the Cross section ID as "VAR01"
Set the date id as "YEAR"

thanks a lot.

[EViews Gareth]

Don't have EV7 on me, but the following seems to work ok in EV8:

Code: Select all

open test.xlsx pagestack arg bra chl col mex per ven pageunstack countries var01 years delete countries var02 rename var02con con_ rename var02* * pagestruct @date(years) var01

[lnp3]

Sorry, Eviews Gareth. I meant to say Eviews 8. I have Eviews 8, not Eviews 7.

So I will use your command from below.

Your "interactive" guidelines worked with "banks" before, I don't know why they seem different with "countries" this time..

Can you show me like this again?

http://www.eviews.com/Forum_support/pan ... ucture.htm

I really appreciate your help.

[lnp3]

Sorry Eviews Gareth, I could not do it..

1) where you say: pagestack arg bra chl col mex per ven (in this page, do I have to change "*?" to "?*" )
2) there is nothing like var02con con_

I am confused. Can you show me like this interactive again? Like you did before. I am attaching the file again.

http://www.eviews.com/Forum_support/pan ... ucture.htm

Always grateful for your help.

best,

[lnp3]

sorry for posting again. I meant if you could show like this.. the link was wrong in my previous post.

http://www.eviews.com/Forum_support/pan ... ucture.htm

thanks a lot.
lnp3

[EViews Gareth]

Just run the commands I gave one at a time in the EViews command line.

[lnp3]

yes, it works. thank you!

[lnp3]

hello Eviews Gareth, just double checking..

I opened test.xlsx as usual ("open foreign data as workfile" from the menu) and ran your commands one at a time..
I did not write "open test xlsx" in the command line.

I ran the rest one at a time..

open test.xlsx
pagestack arg bra chl col mex per ven
pageunstack countries var01 years
delete countries var02
rename var02con con_
rename var02* *
pagestruct @date(years) var01

please correct me if I am wrong.

thanks!
lnp3

[EViews Gareth]

Yes.

[lnp3]

thanks
:)