Yet another excel-panel data question!

[ecotrixguy]

I have been using Eviews for years, but have only recently started working with large panel datasets. I am having a hard time figuring out a simple way to arrange an excel worksheet into the correct format for importing into Eviews for a panel data analysis. Any help would be greatly appreciated. The data looks like this:

Code: Select all

Company ’01 ‘01 ‘01 ‘02 ‘02 ‘02 _______ Ls Bgs Gfa Ls Bgs Gfa Acrow 12 1.07 11.3 1.42 12.01 1.29 Bcrox 15 2.3 26 3 22 5

i.e., data on Liabilities(Ls), Borrowings(Bgs), assets(Gfa), for 2 Companies (Corporations!) for 2001('01) & 2002('02) .

Please excuse me if this qs. has been asked/answered earlier- I am new to this forum. But I think others might also have encountered this problem, and this is the usual format for a database I will need to use a lot. (There is very probably a way with Pool objects etc, but I am not familiar with that at all :))

[EViews Gareth]

That particular format is incredibly difficult to work with. You'll need to write quite a complex EViews program to get that in nicely. You might be better off manipulating it in Excel to a more exportable-friendly structure.

[ecotrixguy]

Thanks, Gareth! Well, I managed to get the data into this format below, which looks better:

Code: Select all

Co __ Acrow Bcrox ’01 Ls 12 15 ‘01 Bgs 1.07 2.3 ‘01 Gfa 11.3 26 ‘02 Ls 1.42 3 ‘02 Bgs 12.01 22 ‘02 Gfa 1.29 5

This should be manageable from here, but I am stuck for now!

[EViews Gareth]

Have you read the guide:
http://forums.eviews.com/viewtopic.php?f=7&t=74
?

[ecotrixguy]

Perfect- got it! Thanks a lot. :D Btw, this highlights how it would be great if Eviews had an online help facility- say linking to topics on this forum.