Page 6 of 16
Re: How to enter data into a panel workfile.
Posted: Sat Apr 13, 2013 6:36 pm
by duynguyen88vn
please help me! How to enter this data into a panel workfile??????
Re: How to enter data into a panel workfile.
Posted: Sat Apr 13, 2013 9:51 pm
by EViews Gareth
Could you describe it?
Re: How to enter data into a panel workfile.
Posted: Mon Apr 15, 2013 1:25 am
by duynguyen88vn
i want to estimate : payout c grownth de cash......
used to random effect model, fix effect model
many thanks!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Re: How to enter data into a panel workfile.
Posted: Mon Apr 15, 2013 8:10 am
by 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 _* *
Re: How to enter data into a panel workfile.
Posted: Mon Apr 15, 2013 5:47 pm
by 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!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Re: How to enter data into a panel workfile.
Posted: Mon Apr 15, 2013 6:04 pm
by EViews Gareth
You're probably best off just re-arranging the data in Excel.
Re: How to enter data into a panel workfile.
Posted: Mon Apr 15, 2013 6:23 pm
by duynguyen88vn
because very large amounts of data . I re-encoded it takes a lot of time!
Can i do it in Eviews 7?
Re: How to enter data into a panel workfile.
Posted: Mon Apr 15, 2013 7:16 pm
by 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!!!!!!!!!!!
Re: How to enter data into a panel workfile.
Posted: Wed Apr 17, 2013 2:46 pm
by 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
Re: How to enter data into a panel workfile.
Posted: Wed Apr 17, 2013 3:24 pm
by EViews Gareth
In EViews 7, ID01 is VAR01
Re: How to enter data into a panel workfile.
Posted: Wed Apr 17, 2013 3:54 pm
by 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?
Re: How to enter data into a panel workfile.
Posted: Wed Apr 17, 2013 5:26 pm
by EViews Gareth
Use VAR01
Re: How to enter data into a panel workfile.
Posted: Wed Apr 17, 2013 5:49 pm
by 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
Re: How to enter data into a panel workfile.
Posted: Wed Apr 17, 2013 7:06 pm
by 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.
Re: How to enter data into a panel workfile.
Posted: Wed Apr 24, 2013 6:03 am
by 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