Proc Expand sum daily volumes to weekly volumes using dates

deleted_user — Fri, 19 Jun 2009 08:55:33 GMT

Hi there,

I have a dataset with two variables - Date and daily volumes for 2 years. I have missing volumes for every Sunday as the data is based on a 6 day working week and I am are trying to sum up these to weekly volumes. I understand Proc Expand should be able to do this hence I used the following code:

proc expand data=data out=newdata from=day to=week;
id date;
run;

This however seems to total up on Sunday with incorrect totals and negative figures.

Please can anyone help.

Cheers

Re: Proc Expand sum daily volumes to weekly volumes using dates

ChrisNZ — Sun, 21 Jun 2009 23:45:44 GMT

You will find more competences in the SAS Forecasting forum.

topic Proc Expand sum daily volumes to weekly volumes using dates in SAS Procedures

Proc Expand sum daily volumes to weekly volumes using dates

Re: Proc Expand sum daily volumes to weekly volumes using dates