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
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