Hello,
I am working on a daily (7 weekdays) database. I would like to create a dummy variable taken the value of one from September to earlier October. How can I do that in Eviews 7 sv, please ?
Note: I can't use loop program in the Student version.
Thanks in advance
Creating Dummies
Moderators: EViews Gareth, EViews Steve, EViews Moderator, EViews Jason
-
EViews Gareth
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13586
- Joined: Tue Sep 16, 2008 5:38 pm
Creating Dummies
Have you read through the dummy variable guide? http://forums.eviews.com/viewtopic.php?f=4&t=3840
Re: Creating Dummies
Cool. Thanks for the link.
Re: Creating Dummies
Hello,
I have an unbalanced panel data set of 1381 funds over 145 months and I'll run a regression with monthly net flows as dependent variable and lagged monthly returns as independent variable (plus some control variables). I have two (related) questions regarding dummy creation (in Eviews 6 student version):
1) For the descriptive statistics part I'd like to do a univariate analysis of e.g. the independent variable ln_return and check whether the mean of returns below the median is significantly different from those above the median. I know that you can do this by "Equality Tests by Classification" and insert a dummy but I wonder how to create this dummy.
If I use something like "series dummy_median=@recode(ln_return<median(ln_return),0,1)" does it take all monthly returns (no matter in which month or for which fund), calculate the median and then assign the dummy as to whether the return is below or above this median?
2) This leads me to the second question: As I'd like to use a piecewise regression later on with the ln_return split into quartiles, I need to create a dummy variable for each quartile with for instance dummy Q1 taking the value 1 if the fund's return in a specific month is above the 75th of all funds in the cross-section in existence in this month and 0 otherwise. How can I create such a dummy that is varying over cross-section and over time-series?
Many thanks for your help and please let me know if you need additional information.
Cheers, LB
I have an unbalanced panel data set of 1381 funds over 145 months and I'll run a regression with monthly net flows as dependent variable and lagged monthly returns as independent variable (plus some control variables). I have two (related) questions regarding dummy creation (in Eviews 6 student version):
1) For the descriptive statistics part I'd like to do a univariate analysis of e.g. the independent variable ln_return and check whether the mean of returns below the median is significantly different from those above the median. I know that you can do this by "Equality Tests by Classification" and insert a dummy but I wonder how to create this dummy.
If I use something like "series dummy_median=@recode(ln_return<median(ln_return),0,1)" does it take all monthly returns (no matter in which month or for which fund), calculate the median and then assign the dummy as to whether the return is below or above this median?
2) This leads me to the second question: As I'd like to use a piecewise regression later on with the ln_return split into quartiles, I need to create a dummy variable for each quartile with for instance dummy Q1 taking the value 1 if the fund's return in a specific month is above the 75th of all funds in the cross-section in existence in this month and 0 otherwise. How can I create such a dummy that is varying over cross-section and over time-series?
Many thanks for your help and please let me know if you need additional information.
Cheers, LB
Re: Creating Dummies
I am new to Eviews and I've never worked on panel data. Sorry I can't help you on this point.
Who is online
Users browsing this forum: No registered users and 2 guests