How to enter data into a panel workfile.
Moderators: EViews Gareth, EViews Moderator
-
- Posts: 5
- Joined: Mon Mar 18, 2013 11:59 pm
Re: How to enter data into a panel workfile.
please help me! How to enter this data into a panel workfile??????
- Attachments
-
- sheetpanel.xls
- (108 KiB) Downloaded 458 times
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13307
- Joined: Tue Sep 16, 2008 5:38 pm
-
- Posts: 5
- Joined: Mon Mar 18, 2013 11:59 pm
Re: How to enter data into a panel workfile.
i want to estimate : payout c grownth de cash......
used to random effect model, fix effect model
many thanks!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
used to random effect model, fix effect model
many thanks!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13307
- Joined: Tue Sep 16, 2008 5:38 pm
Re: How to enter data into a panel workfile.
You'll have to use a program to bring that in as a panel.
In EViews 8:
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 _* *
Follow us on Twitter @IHSEViews
-
- Posts: 5
- Joined: Mon Mar 18, 2013 11:59 pm
Re: How to enter data into a panel workfile.
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!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
can you send to me eviews file of this data?
thanks!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13307
- Joined: Tue Sep 16, 2008 5:38 pm
Re: How to enter data into a panel workfile.
You're probably best off just re-arranging the data in Excel.
Follow us on Twitter @IHSEViews
-
- Posts: 5
- Joined: Mon Mar 18, 2013 11:59 pm
Re: How to enter data into a panel workfile.
because very large amounts of data . I re-encoded it takes a lot of time!
Can i do it in Eviews 7?
Can i do it in Eviews 7?
-
- Posts: 5
- Joined: Mon Mar 18, 2013 11:59 pm
Re: How to enter data into a panel workfile.
EViews Gareth wrote: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.
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
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
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13307
- Joined: Tue Sep 16, 2008 5:38 pm
Re: How to enter data into a panel workfile.
In EViews 7, ID01 is VAR01
Follow us on Twitter @IHSEViews
Re: How to enter data into a panel workfile.
EViews Gareth wrote: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?
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13307
- Joined: Tue Sep 16, 2008 5:38 pm
Re: How to enter data into a panel workfile.
EViews Gareth wrote: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
Last edited by Dxbugs on Thu Apr 18, 2013 3:43 pm, edited 1 time in total.
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13307
- Joined: Tue Sep 16, 2008 5:38 pm
Re: How to enter data into a panel workfile.
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.
Use "firms var" as the unstacking id, and "var01" as the obs id in the unstacking part.
Follow us on Twitter @IHSEViews
Re: How to enter data into a panel workfile.
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
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
Return to “General Information and Tips and Tricks”
Who is online
Users browsing this forum: Google [Bot] and 10 guests