sum by week and month

[stancemcgraw]

AP002 3 23OCT2013

AP002 4 01NOV2013

AP002 5 01NOV2013

AP002 6 14AUG2014

AP002 7 05SEP2014

I am trying to sum the number of dates by week and by month. This is the format for my dates and IDs.....

[ballardw]

What would you expect the output to look like given that input?

is the result to be a data set or a report?

[stancemcgraw]

So those dates are each time a person made a call. I want to total the number of dates per id every four weeks. (or analyze the change by every four weeks)

[Ksharp]

Add two format into two proc means :

data have;
input id $ n date date9.;
format date date9.;
cards;
AP002 3 23OCT2013
AP002 4 04NOV2013
AP002 5 07NOV2013
AP002 6 14AUG2014
AP002 7 05SEP2014
;
run;


proc summary data=have;
by id date;
var n;
format date monyy.;
output out=want1 sum=sum_n;
run;


proc summary data=have;
by id date;
var n;
format date weekv5.;
output out=want2 sum=sum_n;
run;