topic Re: sum by week and month in SAS Procedures

sum by week and month

stancemcgraw — Tue, 05 Jul 2016 17:42:12 GMT

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.....

Re: sum by week and month

ballardw — Tue, 05 Jul 2016 17:54:07 GMT

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

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

Re: sum by week and month

stancemcgraw — Tue, 05 Jul 2016 17:58:57 GMT

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)

Re: sum by week and month

Ksharp — Wed, 06 Jul 2016 01:15:37 GMT

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;