EViews.com

Hi

I am using eviews 6 and I am trying to perform the winsorization process where given a return series, I would like to replace all the values exceeding four times the value of the standard deviation of the series by the standard deviation times four.

series win = @recode(returns> (4 x @stdev(returns)), 4 x stdev(returns), @recode(returns < (-1 x 4 x @stdev(returns)), -1 x 4 x @stdev(returns), returns))

well i think this is what i am trying to do but i cant seem to be able to carry out scalar multiplication in eviews :(

please help me

thanks

"x" should be "*".

I would also recommend that you save the @stdev to a scalar prior to this operation as it will increase the efficiency of the recoding significantly. It also makes it easier to read.
Incidentally, there is an alternative expression that I believe is equivalent and avoids the double @recodes:

Thanks loads, it works perfectly, however the second code you provided does not produce the result i am expecting, anyways thats not a prob. thx agen. :D