Thanks for the help.   I didn't use the week format since there are lots of weeks that don't have counts so i used the specific dates instead.     Thanks again ... View more

Thanks, Astounding.   So, I was able to set the weeks from week1 to current week from the format you sent below, but I can't incorporate it with my table. My main table contains account (#s), dates from when they were extracted (daily), status (active, etc) and product name. I want to count the # of accounts per week based on the formatted weeks below.   Weeks                                              # of Accts (VOL) Week1: 02/28/2016 - 03/05/2016         10   and so on.. ... View more

  Yes, my table is a SAS dataset. My date variable is already in date format: date9. Yes, I have a query to get the counts that I want, it’s the grouping by week I’m struggling with. Basically, it will just contain weeks, e.g. Week                                                    Vol attrition             transfers to pbi             transfers out of pbi week1:  2016-02-28 to 2016-03-05    # of accts attrition   # of transfer to pbi         # of transfer out of pbi week2: 2016-03-06 to 2016-03-12     # of accts attrition   # of transfer to pbi         # of transfer out of pbi   and so on..   ... View more