How to create a table of values

#1
hi I am looking at summarizing the attached data set (book1) in SAS from my original proc sql statement.

I want to adapt this with a summary of existing actions in the statement below with a some counts and sums to produce the table like attached Book5.

is there something quick and handy to include in the proc sql statement to do this?

thanks !

proc sql;
create table Merge2 as
Select
m.new_status,
a.Last_Touch_Channel,
a.Revenue_Pre_Cart_Discount,
a.Cart_Discount,
a.Product_Discount,
a.Delivery_Charges


From Merge1 as m
Left join Adobe_may as a
on m.Order_number=a.Order_number

;
quit;