EViews.com

I want to know how many positive numbers are in a series. in Excel its a simple countif > o type formula. What would be the eviews equivalent?

Thanks!

@sum(x>0)

Thanks but I'm not getting that to work.

I get this message:

NA found in matrix in "SCALAR TEST= @SUM(x>0)".

The sereies has some Nas, but even when I fill them in I get this error message:

Scalar sent to function which operates on a matrix in "SCALAR TEST=@SUM(x>0)".

Any ideas?

Thanks

Not sure, but are you sure that X is a series as opposed to a vector or matrix?

You have to, unfortunately, do it in two steps.

Thanks Gareth!

Can I use this sample sample trick to replace outliers in a series with NAs? Say I want to remove the highest and lowest 5% of observations in a series can i put somehting in this blank space that would do that?

You certainly can, but look at the @replace function which might be easier.

Im not familiar with the replace function but I found the following code which worked well. Thanks

I meant @recode. So you're ahead of me.

ah, ok. Thanks.