How to enter data into a panel workfile.
Moderators: EViews Gareth, EViews Moderator
Re: How to enter data into a panel workfile.
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
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 472 times
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
Re: How to enter data into a panel workfile.
What are your cross-section identifiers?
Follow us on Twitter @IHSEViews
-
- Posts: 2
- Joined: Tue Jul 17, 2012 1:56 am
Re: How to enter data into a panel workfile.
How do i identify the cross section identifiers from a stacked data panel
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
How to enter data into a panel workfile.
I don't understand the question.
Follow us on Twitter @IHSEViews
-
- Posts: 1
- Joined: Mon Jul 23, 2012 7:32 am
Re: How to enter data into a panel workfile.
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
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 486 times
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
Re: How to enter data into a panel workfile.
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
-
- Posts: 1
- Joined: Tue Oct 23, 2012 12:09 am
Re: How to enter data into a panel workfile.
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
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 423 times
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
Re: How to enter data into a panel workfile.
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.
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
Re: How to enter data into a panel workfile.
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.
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 420 times
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
Re: How to enter data into a panel workfile.
EViews 6 doesn't read .XLSX files.
Follow us on Twitter @IHSEViews
Re: How to enter data into a panel workfile.
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 452 times
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
Re: How to enter data into a panel workfile.
There's not really a way to do it in EViews 6, unfortunately.
Follow us on Twitter @IHSEViews
Re: How to enter data into a panel workfile.
Thanks.
I guess I'll have to do it manually then
I guess I'll have to do it manually then
Re: How to enter data into a panel workfile.
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.
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 384 times
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
Re: How to enter data into a panel workfile.
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 28 guests