eviews 7: import data in panel format

[lnp3]

dear group,

I have the following panel data in excel (attached). How can I import into E-views?

The data is not in typical panel format. It is not picking the cross-section identifiers (banks names)?

can you show me the steps of importing it?

[EViews Gareth]

http://forums.eviews.com/viewtopic.php?f=7&t=74

[lnp3]

thanks!

[lnp3]

Dear Eviews,

I have purchased Eviews 7 recently and I am trying to get technical support. I downloaded panel data, which is not in panel format technically. I have followed the guidelines you posted: viewtopic.php?f=7&t=74

I still can't import this format because I can't figure out the details. How can I import this worksheet into Eviews? (see attachment)

Can you show me the exact steps of importing by posting a reply to this forum?
step1:
step 2:

The cross-sectional data (banks) are supposed to be columns rather than rows. In the attachment, there are two formats. Sheet 1 is my data. Sheet 2 is classic panel format. I want Sheet 1 look like Sheet 2 (classic panel format). I tried to transpose but it is not working. Whatever I do, Eviews does not recognize Sheet 1 as panel data.

thank you.

[EViews Gareth]

With the format you currently have, the problem is going to be that your series names (the names of the banks) are too long and unwieldy. If you can shorten them, that's a good way to start.

Also, if you can change "Net Income" to be something shorter and without a space, that will help you.


Once you've done that, you can open that file in EViews, which will open it as a 1992-2011 x 2 panel (where there are two cross-sections, one for Equity and one for Net Income). You can then unstack it (Proc->Reshape->Unstack) and use "banks" as the unstacking ID and "years" as the obs id. Then you can restack the resulting page as a panel.

[lnp3]

e-views Gareth,
thanks, I followed your instructions. after shortening the names, I opened the file in eviews.

That is how data appear. I could not re-stack it as a panel (please see the attachments)

There are two worksheets in e-views. 1) before unstacking 2) after unstacking.

Can you please tell me where the problem is? Am I missing something in the first step? (open file>foreign data as work file)

Thanks for your help.

[EViews Gareth]

You're in good shape.

From the first page of the workfile (you can delete the second page). Do this:
Proc->Reshape->Unstack

Then enter "Banks" 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 "equity?" 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"

And you're done.

[EViews Gareth]

Just played with some new tools...
http://www.youtube.com/watch?v=4XHTOITN ... tube_gdata


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

[lnp3]

dear eviews gareth,

it is working this time! thanks a lot for your help.

happy holidays, :D

[lnp3]

beautiful you tube demonstration!!

you guys were so helpful. great technical support!!

[lnp3]

I have purchased Eviews 7 recently and asked a question to the forum about how to restructure time series*cross sectional data as panel data in Eviews.

Eviews Gareth posted this information, which I fully understood! now I know how to convert data into panel format.

simple question:

Is the procedure that E-views Gareth posted below pooled or panel? My Excel data were not classic panel and Gareth showed how to restructure it as panel data in Eviews.

Is this restructuring procedure called pooling or panel? I just want to make sure that I am using panel data. IS THE END RESULT OF RESTRUCTURING PROCESS PANEL DATA? I am asking because dummy variable interpretation differs between pool and panel. To put simply, does RESTRUCTURING make any difference in terms of interpretation of dummy variable in panel data?

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

I greatly appreciate your help, as always.

[EViews Gareth]

The result at the end of my demonstration was a panel workfile.

[lnp3]

thanks a lot!

[lnp3]

Dear Technical Supporters,

I have recently purchased Eviews 7 and am seeking technical support.

I have got this warning after importing panel data into E-views (attached excel file). As you see, I entered the data in classic panel format.

I don't know why I am receiving this warning? I have had no problems importing this format before. What should I do to fix it? Please help.

Here is the warning that I get after I importing. It appears when I try to restructure as panel data:

-Indices do not uniquely identify observations
-12 duplicated dates found..
-Create Cellid Series to identify observations?
If I say Yes, it warns: Adding Cellid ID as the inner index will create 3 dimension unbalanced undated panel. Are you sure you wish to continue? Yes.. (If I say, no.. it goes back to original)

How can I reorganize "unbalanced undated panel" after adding Cellid ID?

Thank you so much for your attention. I can't do panel analysis without fixing this problem. Please help.

[lnp3]

dear forum,

I have found problem. I gave two banks the same name.. duplication was causing error..

don't bother...

thanks.