EViews.com

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

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.

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

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.

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.

Ah, I see.

What you want to do isn't built in.

Gareth, thanks for looking into it. appreciate it.