Date:         Wed, 31 Jan 2007 15:38:05 -0800
Reply-To:     David Fickbohm <davefickbohm@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         David Fickbohm <davefickbohm@YAHOO.COM>
Subject:      How to calculate average leads by day
Content-Type: text/plain; charset=ascii

People,
I have a datafile that includes create_dt monthdt and ctr
create_dt    monthdt   ctr
01/10/06     10          1
01/10/06     10          1
02/10/06     10          1
.
.
.
31/10/06   10          1
01/11/06    11         1
02/11/06    11         1
02/11/06    11          1
.
.
.
30/11/06  11          1
01/12/06  12          1
.
.
.
31/12/06  12          1

I want to sum the ctr and divide by the number of days in each month.
desired output
month  total    average leads per day 
10       62          2
11       90          3
12       81           2.6

Your suggestions would be appreciated.
Thanks
Dave 
    
Dave Fickbohm