@rsum

[javiersan]

Is there a way of summing the row elements of a group of series carrying the NAs as zeros? i.e. not having a NA result in the @rsum when one or more of the series has a NA value.

Thanks

Javier

[startz]

Use @nan.

Code: Select all

group g @nan(x,0) @nan(y,0) @rsum(g)

[javiersan]

Thanks, clever solution. I have series names in a string and wrapping each of them in @nan(,0) becomes complicated (with @wcross), an off-the-shelf solution could be great. Gareth, could you please add a variation of @rsum that carries NAs as zeros?

Javier

[EViews Glenn]

I'm confused. @rsum should not propagate NAs unless all elements are NAs.

If the latter point is the issue, you could always recode the end result.

series y = @rsum(group01)
y = @nan(y, 0)

[startz]

The confusion is entire Glenn's fault. He keeps thinking I'll read the documentation...

[EViews Glenn]

I should point out that your suggestion does work...

[EViews Gareth]

Can't we just pretend that this morning @RSUM propagated NAs, so didn't do what Javiersan wanted, but then he asked me to make a variation that didn't propagate NAs (unless all are NA), which I then did and magically updated all copies of EViews 7? I think that way everyone comes out a winner.