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

nadirah
Posts: 1
Joined: Sat May 26, 2012 7:56 am

Re: How to enter data into a panel workfile.

Postby nadirah » Sat May 26, 2012 8:10 am

Hi,

I a very confius...I have the following data..i dunt know how enter those data in a panel workfile...my bos ask me to complete this task within 3 days...i seriously don't know...some one pls help me...




Month Rating Sector Sales
Jan-09 02 07 682.46
Jan-09 02 07 1,006.22
Jan-09 02 07 9,298.17
Jan-09 02 07 10,495.60
Jan-09 02 07 10,847.24
Jan-09 02 07 7,955.98
Jan-09 02 07 1,961.67
Jan-09 02 07 2,011.58
Jan-09 02 07 267.13
Jan-09 02 07 10,417.74
Jan-09 02 07 8,682.53
Jan-09 02 07 3,587.00
Jan-09 02 07 2,840.25
Jan-09 02 07 2,044.02
Jan-09 02 07 339.61
Jan-09 02 07 182.53
Jan-09 02 07 8,641.51
Jan-09 02 07 1,804.01
Jan-09 02 07 9,137.96
Jan-09 02 07 1,006.22
Feb-09 02 07 9,308.95
Feb-09 02 07 835.63
Feb-09 02 07 594.37
Feb-09 02 07 4,961.57
Feb-09 02 07 572.29
Feb-09 02 07 10,513.50
Feb-09 02 07 3,707.80
Feb-09 02 07 201.24
Feb-09 02 07 372.70
Feb-09 02 07 4,167.48
Feb-09 02 07 491.46
Feb-09 02 07 2,979.32
Feb-09 02 07 398.10
Feb-09 02 07 4,553.59
Feb-09 02 07 4,306.34
Feb-09 02 07 11,117.87
Feb-09 02 07 551.50
Feb-09 02 07 974.17
Feb-09 02 07 7,145.18
Feb-09 02 07 1,201.52
Mar-09 02 07 987.73
Mar-09 02 07 4,402.60
Mar-09 02 07 1,005.82
Mar-09 02 07 1,683.70
Mar-09 02 07 3,556.58
Mar-09 02 07 10,911.80
Mar-09 02 07 496.18
Mar-09 02 07 5,983.73
Mar-09 02 07 3,243.59
Mar-09 02 07 9,125.44
Mar-09 02 07 14,124.30
Mar-09 02 07 477,689.54
Mar-09 02 07 8,069.50
Mar-09 02 07 547,330.44
Mar-09 02 07 4,723.05
Mar-09 02 07 1,473.20
Mar-09 02 07 20,950.14
Mar-09 02 07 163,325.21
Mar-09 02 07 12,170.37
Mar-09 02 07 484.64
Apr-09 02 07 369.68
Apr-09 02 07 5,363.50
Apr-09 02 07 379.09
Apr-09 02 07 288.27
Apr-09 02 07 5,776.39
Apr-09 02 07 43,330.68
Apr-09 02 07 109.49
Apr-09 02 07 17,750.95
Apr-09 02 07 7,225.09
Apr-09 02 07 21,653.17
Apr-09 02 07 28,796.26
Apr-09 02 07 5,604.84
Apr-09 02 07 26,819.92
Apr-09 02 07 7,134.14
Apr-09 02 07 139.11
Apr-09 02 07 64,605.53
Apr-09 02 07 11,932.86
Apr-09 02 07 5,777.42
Apr-09 02 07 43,330.68
Apr-09 02 07 95,591.55
May-09 02 07 10,715.30
May-09 02 07 5,241.00
May-09 02 07 3,173.29
May-09 02 07 4,209.83
May-09 02 07 10,609.82
May-09 02 07 2,166.53
May-09 02 07 2,888.71
May-09 02 07 4,333.07
May-09 02 07 14,732.43
May-09 02 07 2,594.44
May-09 02 07 11,094.31
May-09 02 07 39,482.35
May-09 02 07 43,330.68
May-09 02 07 19,174.79
May-09 02 07 36,404.08
May-09 02 07 86,813.31
May-09 02 07 173,434.15
May-09 02 07 78,876.64
May-09 02 07 749.51
May-09 02 07 302,422.00
Jun-09 02 07 3,974.16
Jun-09 02 07 35,879.94
Jun-09 02 07 7,221.78
Jun-09 02 07 10,110.49
Jun-09 02 07 430,463.28
Jun-09 02 07 340,053.13
Jun-09 02 07 15,024.28
Jun-09 02 07 2,968.96
Jun-09 02 07 339.40
Jun-09 02 07 43,330.68
Jun-09 02 07 28,887.12
Jun-09 02 07 15,771.08
Jun-09 02 07 235,893.88
Jun-09 02 07 375,677.02
Jun-09 02 07 155.12
Jun-09 02 07 68,449.09
Jun-09 02 07 2,738.58
Jun-09 02 07 193,169.78
Jun-09 02 07 7,366.22
Jun-09 02 07 2,253.59
Jul-09 02 07 43,403.41
Attachments
panel data.xlsx
(682.76 KiB) Downloaded 185 times

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 12172
Joined: Tue Sep 16, 2008 5:38 pm

Re: How to enter data into a panel workfile.

Postby EViews Gareth » Tue May 29, 2012 7:40 am

What are your cross-section identifiers?
Follow us on Twitter @IHSEViews

YogurtBreaks
Posts: 2
Joined: Tue Jul 17, 2012 1:56 am

Re: How to enter data into a panel workfile.

Postby YogurtBreaks » Tue Jul 17, 2012 1:58 am

How do i identify the cross section identifiers from a stacked data panel

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 12172
Joined: Tue Sep 16, 2008 5:38 pm

How to enter data into a panel workfile.

Postby EViews Gareth » Tue Jul 17, 2012 6:10 am

I don't understand the question.
Follow us on Twitter @IHSEViews

Pythagoras
Posts: 1
Joined: Mon Jul 23, 2012 7:32 am

Re: How to enter data into a panel workfile.

Postby Pythagoras » Wed Jul 25, 2012 7:26 am

Hi Gareth,

I have a question relating to panel data. I want to model store level sales data (the dependent), advertising and prices (the expanatories). The advertising is at the regional level and I want to allocate the same value for every store in the region (but still model at the store level). See the attached for the data and an indication of the issue.

Is there a way of setting identifiers in EV7 so that this could be done automatically (for example see your first post in this thread)? Note that my cross section is stores.

Thank you in advance.

Sotiris
Attachments
Test Store Data.xls
(17.5 KiB) Downloaded 214 times

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 12172
Joined: Tue Sep 16, 2008 5:38 pm

Re: How to enter data into a panel workfile.

Postby EViews Gareth » Wed Jul 25, 2012 8:35 am

Not sure what you're asking here - are you asking how to get that Excel file into an EViews workfile? (In which case, to be honest, I would just do a quick manipulation in Excel to make it more EViews friendly), or are you asking whether such data is possible to use in a panel equation (in which case, yes, but you won't be able to use any fixed effects).
Follow us on Twitter @IHSEViews

FinanceBoy15
Posts: 1
Joined: Tue Oct 23, 2012 12:09 am

Re: How to enter data into a panel workfile.

Postby FinanceBoy15 » Tue Oct 23, 2012 12:20 am

Hi Gareth,

I have an Excel file (attached) with date in the first column and stock prices for 100 firms in the subsequent columns for 1999-2011. I need the data in panel form where I have 3 columns essentially: firm name; date; price in a series where I'd have stock prices for firm A 1998-2011 and right below that firm B 1998-2011 and etc. I'd preferably want this output in Excel form.

I tried the technique on page 1 of this thread where I have the label 'price' for every firm in the first row then I just Reshape Current page -> Stack in new page. However, when I copy and paste this series in excel and I split the first column into name and date the date portion doesn't actually format in date format.

Thanks
Attachments
EquityPrices.xlsx
(1.76 MiB) Downloaded 162 times

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 12172
Joined: Tue Sep 16, 2008 5:38 pm

Re: How to enter data into a panel workfile.

Postby EViews Gareth » Tue Oct 23, 2012 7:53 am

I did the following.
Opened the Excel file in EViews (default options).
Hit Proc->Reshape->Stack in New Page.
Entered "price?" in the first box, and hit enter.
Then, on the new page, did File->Save As, then changed the type to Excel, typed in a name and hit ok.

Seemed to work fine.
Follow us on Twitter @IHSEViews

runawayyy
Posts: 11
Joined: Mon Jan 21, 2013 9:19 pm

Re: How to enter data into a panel workfile.

Postby runawayyy » Wed Feb 06, 2013 6:27 pm

Hi Gareth,

I have an Excel file (attached) with various variables: NPL, GDP, CPI, Interest rate and Exchange rate, each in a separate Excel tab.

I'm using Eviews 6. How can I enter the data into a panel workfile?

Thank you.
Attachments
Panel.xlsx
(49.62 KiB) Downloaded 153 times

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 12172
Joined: Tue Sep 16, 2008 5:38 pm

Re: How to enter data into a panel workfile.

Postby EViews Gareth » Wed Feb 06, 2013 7:43 pm

EViews 6 doesn't read .XLSX files.
Follow us on Twitter @IHSEViews

runawayyy
Posts: 11
Joined: Mon Jan 21, 2013 9:19 pm

Re: How to enter data into a panel workfile.

Postby runawayyy » Wed Feb 06, 2013 10:47 pm

Now suppose that I convert the file into .xls format like below, what should I do to import the data into Eviews 6?
Attachments
Panel.xls
(84.5 KiB) Downloaded 178 times

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 12172
Joined: Tue Sep 16, 2008 5:38 pm

Re: How to enter data into a panel workfile.

Postby EViews Gareth » Wed Feb 06, 2013 10:54 pm

There's not really a way to do it in EViews 6, unfortunately.
Follow us on Twitter @IHSEViews

runawayyy
Posts: 11
Joined: Mon Jan 21, 2013 9:19 pm

Re: How to enter data into a panel workfile.

Postby runawayyy » Wed Feb 06, 2013 11:01 pm

Thanks.
I guess I'll have to do it manually then :cry:

mtimanti
Posts: 2
Joined: Mon Feb 11, 2013 11:51 am

Re: How to enter data into a panel workfile.

Postby mtimanti » Mon Feb 11, 2013 11:54 am

Hi Gareth,
My data set is similar to your second example however when I try and unstack the data into a new page I get an error message saying "ID series do not uniquely identify workfile observations". Any ideas what the problem may be? I've attached my data set.
Attachments
Book1.xlsx
(66.56 KiB) Downloaded 169 times

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 12172
Joined: Tue Sep 16, 2008 5:38 pm

Re: How to enter data into a panel workfile.

Postby EViews Gareth » Mon Feb 11, 2013 12:47 pm

Ukraine has two values for GDP.
Follow us on Twitter @IHSEViews


Return to “General Information and Tips and Tricks”

Who is online

Users browsing this forum: No registered users and 3 guests