Page 1 of 1

Creating Dummies

Posted: Thu May 03, 2012 1:01 am
by Sissy
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

Posted: Thu May 03, 2012 1:24 am
by EViews Gareth
Have you read through the dummy variable guide? http://forums.eviews.com/viewtopic.php?f=4&t=3840

Re: Creating Dummies

Posted: Thu May 03, 2012 3:19 am
by Sissy
Cool. Thanks for the link.

Re: Creating Dummies

Posted: Tue May 08, 2012 10:49 am
by lb85
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

Re: Creating Dummies

Posted: Tue May 08, 2012 10:53 am
by Sissy
I am new to Eviews and I've never worked on panel data. Sorry I can't help you on this point.