Below is a simplified version of what I am working with. The date field is a date9. format. I then took that date field and used it to make the week field by changing the format to yyweek07. I am using SAS Enterprise Guide for this and just changed the format in the query builder using 'Date' as my source column. I am now trying to sum the revenue across the week field to get something like the second table I shared below. When I got to sum though, it isn't summing to the week level. The output of this is just a dataset that I will then be working with further.    Date Week Revenue 01JAN2020 2020W01 500 02JAN2020 2020W01 200 01FEB2020 2020W04 300 02FEB2020 2020W04 200     Week Revenue 2020W01 700 2020W04 500 ... View more