Looks like you sorted the data  (And hopefully you have moved it out of a Spreadsheet and into an actual dataset) so a simple data step with BY group processing should work. data want; set have; by item_id price; if first.item_id; run; If some of the prices are missing then also add a WHERE statement to ignore those observations since missing values are smaller than any actual value. where not missing(price); ... View more

proc sql; create table final_sum as select put(date_year_qtr,yyq.) as date_year_qtr, sum(sales) as sales from table_2 group by calculated date_year_qtr ; quit; ... View more

Thank you! ... View more

It is a date/time value, not just a date value.   I tried both methodologies and timed the return time.  They both worked and returned the same results but the first methodology returned in half the time.   1 - where DATE between '05JAN2023 00:00:00'dt and '05MAY2023 23:59:59'dt 2 - where datepart(DATE) between '05JAN2023'd and '05MAY2023'd   I appreciate all of the help everyone has provided!  As I'm still very new to SAS (and obviously using more SQL rather than SAS), anyone have a recommendation on a good learning course for beginners to build up my skillset? ... View more

Thank you, Tom!  I really appreciate you walking me through I'm sure what was simple to you as I build up my knowledge.  I didn't recognize those as variables but makes perfect sense now.  I got it working after that.  I appreciate your guidance. ... View more

Bingo!  I appreciate you jumping in and taking it down to my level.  Using the double quotes allowed it to follow the format Paige laid out before but using the prompt.  Thanks so much! ... View more

Here is a much better way of doing what you want: Proc sql; create table DATE_TEST as Select input(adjudication_dt_id, yymmdd8.) as adjudication_dt format = yyq6. From SummaryLookup; quit; ... View more

data want; set have; by category; output; if first.category then do; count_2021_sum = count_2021; count_2022_sum= count_2022; end; else do; count_2021_sum +count_2021; count_2022_sum+count_2022; end; if last.category then do; Name='Total'; count_2021 = count_2021_sum; count_2022=count_2022_sum; output; end; run; Another manual option - note you need to add in other variables. ... View more

Thank you ... View more