Hi,
I have daily data in my work page as below:
3/15/1996 4004000
3/18/1996 6006000
3/19/1996 4052000
3/20/1996 6066000
3/21/1996 6132000
3/22/1996 6066000
3/25/1996 6066000
3/26/1996 6066000
3/27/1996 6120000
3/28/1996 6090000
3/29/1996 6066000
4/1/1996 6114000
When I convert this into weekly data, weeks are numbered with 1st day week and instead of last day.
Also, the starting date is a Friday and the series finishes on Monday. I like to have weekly series to always contain sum of observations from Monday to Friday. My desired output is:
3/15/1996 4004000
3/22/1996 28322000
3/29/1996 30408000
4/1/1996 6114000
Frequency Conversion
Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Frequency Conversion
When you create a weekly page, whatever day lies on the start date that you provided when creating the page is taken to be the first day of the week. If you want it to be a different day, you'll have to recreate the page.
Follow us on Twitter @IHSEViews
Re: Frequency Conversion
Thanks, Gareth.
I set it from 3/18/1996 to 3/29/1996 to get rid of unwanted observations on both end but I get following output when using sum_obs
3/18/1996 28322000
3/25/1996 30408000
the sum of data is as of end of the week and not beginning of the week so how can I make it organized it as below:
3/22/1996 28322000
3/29/1996 30408000
I set it from 3/18/1996 to 3/29/1996 to get rid of unwanted observations on both end but I get following output when using sum_obs
3/18/1996 28322000
3/25/1996 30408000
the sum of data is as of end of the week and not beginning of the week so how can I make it organized it as below:
3/22/1996 28322000
3/29/1996 30408000
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Frequency Conversion
Set the start date to be the 3/15/1996, then do the sum. That will get the days correct, but you'll be off by a week. You can then just take lags.
Follow us on Twitter @IHSEViews
Re: Frequency Conversion
setting start date to 3/15 takes first five observations as in first week instead of choosing Monday-Friday as weekly i.e. It sums 3/15/1996 to 3/21/1996 instead of adding 3/18/1996 to 3/22/1996 as first full week.
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Frequency Conversion
Ah, I see.
What you want to do isn't built in.
What you want to do isn't built in.
Follow us on Twitter @IHSEViews
Re: Frequency Conversion
Gareth, thanks for looking into it. appreciate it.
Who is online
Users browsing this forum: No registered users and 16 guests