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!
average number of days
Moderators: EViews Gareth, EViews Moderator, EViews Jason, EViews Matt
-
EViews Gareth
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13604
- Joined: Tue Sep 16, 2008 5:38 pm
Re: average number of days
What's the frequency of the workfile?
-
miorinnovo
- Posts: 199
- Joined: Sun Mar 01, 2015 5:01 pm
Re: average number of days
Monthly. The data series is monthly, I'd just prefer average per day in that month.
-
EViews Gareth
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13604
- Joined: Tue Sep 16, 2008 5:38 pm
Re: average number of days
Code: Select all
series av_x = x/@daycount
-
miorinnovo
- Posts: 199
- Joined: Sun Mar 01, 2015 5:01 pm
Re: average number of days
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
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
Who is online
Users browsing this forum: No registered users and 2 guests
