How to enter data into a panel workfile.

For requesting general information about EViews, sharing your own tips and tricks, and information on EViews training or guides.

Moderators: EViews Gareth, EViews Moderator

duynguyen88vn
Posts: 5
Joined: Mon Mar 18, 2013 11:59 pm

Re: How to enter data into a panel workfile.

Postby duynguyen88vn » Sat Apr 13, 2013 6:36 pm

please help me! How to enter this data into a panel workfile??????
Attachments
sheetpanel.xls
(108 KiB) Downloaded 458 times

EViews Gareth
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.

Postby EViews Gareth » Sat Apr 13, 2013 9:51 pm

Could you describe it?
Follow us on Twitter @IHSEViews

duynguyen88vn
Posts: 5
Joined: Mon Mar 18, 2013 11:59 pm

Re: How to enter data into a panel workfile.

Postby duynguyen88vn » Mon Apr 15, 2013 1:25 am

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

EViews Gareth
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.

Postby EViews Gareth » Mon Apr 15, 2013 8:10 am

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 _* *
Follow us on Twitter @IHSEViews

duynguyen88vn
Posts: 5
Joined: Mon Mar 18, 2013 11:59 pm

Re: How to enter data into a panel workfile.

Postby duynguyen88vn » Mon Apr 15, 2013 5:47 pm

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
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.

Postby EViews Gareth » Mon Apr 15, 2013 6:04 pm

You're probably best off just re-arranging the data in Excel.
Follow us on Twitter @IHSEViews

duynguyen88vn
Posts: 5
Joined: Mon Mar 18, 2013 11:59 pm

Re: How to enter data into a panel workfile.

Postby duynguyen88vn » Mon Apr 15, 2013 6:23 pm

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

duynguyen88vn
Posts: 5
Joined: Mon Mar 18, 2013 11:59 pm

Re: How to enter data into a panel workfile.

Postby duynguyen88vn » Mon Apr 15, 2013 7:16 pm

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!!!!!!!!!!!

Dxbugs
Posts: 3
Joined: Wed Apr 17, 2013 2:39 pm

Re: How to enter data into a panel workfile.

Postby Dxbugs » Wed Apr 17, 2013 2:46 pm

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
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.

Postby EViews Gareth » Wed Apr 17, 2013 3:24 pm

In EViews 7, ID01 is VAR01
Follow us on Twitter @IHSEViews

Dxbugs
Posts: 3
Joined: Wed Apr 17, 2013 2:39 pm

Re: How to enter data into a panel workfile.

Postby Dxbugs » Wed Apr 17, 2013 3:54 pm

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?

EViews Gareth
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.

Postby EViews Gareth » Wed Apr 17, 2013 5:26 pm

Use VAR01
Follow us on Twitter @IHSEViews

Dxbugs
Posts: 3
Joined: Wed Apr 17, 2013 2:39 pm

Re: How to enter data into a panel workfile.

Postby Dxbugs » Wed Apr 17, 2013 5:49 pm

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.

EViews Gareth
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.

Postby EViews Gareth » Wed Apr 17, 2013 7:06 pm

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.
Follow us on Twitter @IHSEViews

Qmars
Posts: 21
Joined: Thu Dec 04, 2008 10:30 pm

Re: How to enter data into a panel workfile.

Postby Qmars » Wed Apr 24, 2013 6:03 am

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


Return to “General Information and Tips and Tricks”

Who is online

Users browsing this forum: Google [Bot] and 10 guests