How to enter data into a panel workfile.

[duynguyen88vn]

please help me! How to enter this data into a panel workfile??????

[EViews Gareth]

Could you describe it?

[duynguyen88vn]

i want to estimate : payout c grownth de cash......
used to random effect model, fix effect model
many thanks!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

[EViews Gareth]

You'll have to use a program to bring that in as a panel.

In EViews 8:

Code: Select all

wfopen c:\temp\sheetpanel.xls byrow range="TANGIBILITY!a1:e101" @rename * *_tang import c:\temp\sheetpanel.xls byrow range="PAYOUT!a1:e101" @rename * *_payout import c:\temp\sheetpanel.xls byrow range="GROWTH!a1:e101" @rename * *_growth import c:\temp\sheetpanel.xls byrow range="SIZE!a1:e101" @rename * *_size import c:\temp\sheetpanel.xls byrow range="EPS!a1:e101" @rename * *_eps import c:\temp\sheetpanel.xls byrow range="TAX!a1:e101" @rename * *_tax import c:\temp\sheetpanel.xls byrow range="DE!a1:e101" @rename * *_de import c:\temp\sheetpanel.xls byrow range="CASH!a1:e101" @rename * *_cash pagestack(page=panel) ?_cash @ ?* rename _* *

[duynguyen88vn]

hic. i used to run Eviews 6. can i run your wf by eviews 6?
can you send to me eviews file of this data?
thanks!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

[EViews Gareth]

You're probably best off just re-arranging the data in Excel.

[duynguyen88vn]

because very large amounts of data . I re-encoded it takes a lot of time!
Can i do it in Eviews 7?

[duynguyen88vn]

You're probably best off just re-arranging the data in Excel.

Can you send to me eviews of this sheetpanel!!!!!!!!!!!!!! thanks you very much!!!!!!!!!!!

[Dxbugs]

Hi Gareth,

I was trying to do the exercise by using the second data. I downloaded it and tried in version 7.1.

After doing the stacking in new page, I didn't get the id01 and id02! so I can't continue to the next step: unstacking..variable etc.

What seems to be the problem?

Thanks.

Dx

[EViews Gareth]

In EViews 7, ID01 is VAR01

[Dxbugs]

In EViews 7, ID01 is VAR01

Thanks.

I think it is different.

If you look at you posted workfile is says:

c
id01
id02
resid
state
variable
yr

What I got after new stacking:

c
resid
state
var01
variable
yr

there is no id01 and id02?

[EViews Gareth]

Use VAR01

[Dxbugs]

Use VAR01

Hi Gareth,

attached is my data, formatted the same as your second example. I am new to eviews that is why I am trying to learn the basics..

I really want to know how to convert this excel format to eviews panel data..If possible, can you kindly give me step by step procedure to convert this to panel data? I may actually add some more variables on this later on.

I am using version 7.1

Thanks in advance.

Best.

Dx

[EViews Gareth]

Use "num?" as the stacking id in the page stacking part.

Use "firms var" as the unstacking id, and "var01" as the obs id in the unstacking part.

[Qmars]

Hello Gareth,

I am using the second type of format on "Re: How to entre data into a panel workfile.". On Panel_STK workfile page, I type alpha var2..... in the command pane to create a new alpha series containing valid names. Once i stroke enter, a messages appears asking if I want to delete "variable" series. By tapping on "yes"tab, the "variable" series disappears but var2 series does not create. Any idea what I am doing wrongly? Thanks