filter the extreme values
Posted: Tue May 20, 2014 5:07 am
Hi, I usually can find my answers by checking the forum, but this time I have some difficulties in tackling this problem. As I'm new to this software, I thought it might be a good idea to ask help from the forum.
Here is my question:
I have a time series of stock returns over 20 years, and I'd like to create dummy variables for the returns in the top of 10% and below the 10% with a value "1", the returns fall out of this range will give a value "0". I know @recode can filter the data with a given value, however, I don't know how to manipulate the code to find a percentile.
I'm using Eviews 7.
Hope you can help here, thank you in advance!
Here is my question:
I have a time series of stock returns over 20 years, and I'd like to create dummy variables for the returns in the top of 10% and below the 10% with a value "1", the returns fall out of this range will give a value "0". I know @recode can filter the data with a given value, however, I don't know how to manipulate the code to find a percentile.
I'm using Eviews 7.
Hope you can help here, thank you in advance!