Page 1 of 1

average number of days

Posted: Tue Jun 16, 2015 10:43 am
by miorinnovo
Is there a way to program an automatic adjustment in a series so that a series gets divided by the number of days in a month? I would want the raw data to be automatically divided by 31 for all Januaries, 28 pr 29 for Februaries, etc.

Thanks!

Re: average number of days

Posted: Tue Jun 16, 2015 10:48 am
by EViews Gareth
What's the frequency of the workfile?

Re: average number of days

Posted: Tue Jun 16, 2015 10:50 am
by miorinnovo
Monthly. The data series is monthly, I'd just prefer average per day in that month.

Re: average number of days

Posted: Tue Jun 16, 2015 10:51 am
by EViews Gareth

Code: Select all

series av_x = x/@daycount

Re: average number of days

Posted: Tue Jun 16, 2015 12:37 pm
by miorinnovo
I replaced the x in your example with my series name and I get the message:

Numeric operator applied to string data.

Any idea why?

Edit: Actually nevermind, I got it to work by doing 2 steps, creating a series called days using @daycount then dividing by that series.

Thanks Gareth