Combine @sumsby with sample command

[chris_cl]

Is it possible to combine the @sumsby command with the sample command? I wish to sum over a subgroups in one period in a panel-data set.

[EViews Gareth]

Yes, the third argument of the command takes a sample.
http://www.eviews.com/help/helpintro.ht ... stics.html

[chris_cl]

That is not exactly what I need.

I have a state-skill combination as the cross-sectional dimension. Now I wish to sum up the values of a series for some of the skills in one state at one point in time.

[EViews Gareth]

Not entirely sure I follow, but don't you just want the @sum rather than @sumsby?

Code: Select all

scalar mysum = @sum(myseries, "1990m1 1990m1 if state-skill="CA fishing")


[chris_cl]

I need to create a new series that sums up several observations at every point in time. In your example, that would be something like:
series SUM = CA_fishing + CA_hunting but other skills in CA (e.g. CA_farming) must not be included in the summation.

The series SUM then contains the same value for every skill in California.

This summations needs to be computed for each period, i.e. something like @obsid

[EViews Gareth]

Code: Select all

series mysum = @sumsby(myseries, @obsid, if skill="fishing")


Perhaps providing a concrete example would help?

[chris_cl]

The problem with your suggestion is that it sums up the values if skill=fishing over all states. What I need is that fishing and hunting are summed up in one state.

I solved the issue with a loop. However, it would be interesting to know if it was necessary.