Summing observations per month

[student07]

Hi,

I have a daily dataset, but the number of observations per month differs.

I want to calculate the sum of all observations that belong to a certain month (the result should be that I have one number per month). Is there an easy way to do this in EViews?

Thanks in advance!

[EViews Gareth]

Code: Select all

series monthsums = @sumsby(y, @datefloor(@date, "mm"))

[student07]

Code: Select all

series monthsums = @sumsby(y, @datefloor(@date, "mm"))

Fantastic, just what I needed, thanks a lot! :)