Hello,
My question might sound stupid but I just started working with Eviews and some things are not that obvious to me.
I have panel data and when I import data from excel file I get question about date series - and I type 'week' and that's obviously wrong since eviews doesn't let me continue with that. What should i type then? What i have is weekly sales and price promotion information for 5 products (for each product there are 261 weekly observations; total number of observations is 1305). Also I don't really understand what am I suppose to specify in cross section ID series: if I want to regress sales as a function of price and other variables, should I type sales or what?
Thanks in advance for any help!
Panel data import
Moderators: EViews Gareth, EViews Steve, EViews Moderator, EViews Jason
-
EViews Gareth
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13604
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Panel data import
Hard to tell you how to import the data without knowing how the data look in Excel.
Re: Panel data import
It looks like this (where D is number of the week, dummy variable). I can also attach excel file if needed.
Thank you!
Thank you!
- Attachments
-
- File.jpg (282.74 KiB) Viewed 7275 times
-
EViews Gareth
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13604
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Panel data import
Attach the Excel file.
Re: Panel data import
Here it is.
- Attachments
-
- scan pro WEEKLY one retailer adj.xls
- (956.5 KiB) Downloaded 311 times
-
EViews Gareth
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13604
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Panel data import
Just open the file in EViews, accepting the default settings, then hit Proc->Structure/Resize Current Page, change the type to dated panel, enter "week" as the date series, and "product" as the cross-section.
Re: Panel data import
Thanks a lot for your help, but Eviews still doesnt let me type 'Week' in dated panel
-
EViews Gareth
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13604
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Panel data import
Which version of EViews?
-
EViews Gareth
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13604
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Panel data import
Thanks a lot! And sorry for taking so much of your time.
Who is online
Users browsing this forum: No registered users and 2 guests
