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!
Summing observations per month
Moderators: EViews Gareth, EViews Jason, EViews Moderator, EViews Matt
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Summing observations per month
Code: Select all
series monthsums = @sumsby(y, @datefloor(@date, "mm"))
Follow us on Twitter @IHSEViews
Re: Summing observations per month
EViews Gareth wrote:Code: Select all
series monthsums = @sumsby(y, @datefloor(@date, "mm"))
Fantastic, just what I needed, thanks a lot!
Who is online
Users browsing this forum: Google [Bot] and 51 guests