One comment about the specific question. Intermediate series can be deleted when done and you can sometimes avoid creating them at all. There are many ways to do things in EViews, some better than others in certain circumstances. Suppose, for example, that you have the series Y in your workfile and wish to compute the sum, at each period of
Y, log(Y) and Y^2.
You could create the intermediate series and then the sum
Code: Select all
series logy = log(y)
series y2 = y^2
series ysum = y + logy + y2
delete y2
delete ysum
but you could just as easily compute the sum in one expression
avoiding the temps altogether.
Note that this does the within period summing that you want. One possible problem is this sum is not robust to missing values so that a missing in one series will propagate to the sum. This may be what you want, but if you wish to compute the sum ignoring the missings, you could do
Code: Select all
group temp y log(y) y^2
series ysum = @rsum(temp)
delete temp
as Gareth suggested, or you could do a variant of our initial method
Code: Select all
ysum = @recode(y<>na, y, 0) + @recode(log(y)<>na, log(y), 0) + @recode(y^2<>na, y^2, 0)
This latter method avoids the temporary group but is less efficient.