Taking average

[PGStats]

Variable WEEK is a SAS date. It is the date of the first day of the week which is set to start on a Monday. That's what function INTNX returns. By associating variable WEEK to format WEEKV5., the date is formatted as a week number. You can group on variable WEEK since all days belonging to the same week (starting on Monday) will have the same value for WEEK.

PG

[Steelers_In_DC]

The date is the same no matter what the format, I didn't catch that your date is in a date format before.  The date is always the same to SAS, so any difference in days won't be displayed in your format but it's still a different date.  I would recommend adding an extra variable that has date as a character.  You can use this column to group by but keep your date column as a date for any other purposes.

[m1986MM]

Thank you.