I have a table
Group
Revenue
A
100
A
50
B
200
B
100
I want to sum aggregation by proc sql, like:
Group
Total Revenue
A
150
B
300
proc sql;
select
Group, sum(Revenue) as Total_Revenue
from mytable group by Group
;quit;
However, it produces duplicates records:
Group
Total Revenue
A
150
A
150
B
300
B
300
Of course, there are couple of solution like NOMERGE SQL (not always work) or SORT NODUPKEY. But I wonder any efficient and direct way, something like:
proc sql;
select
first(Group), # Take the first name record in the Group
sum(Revenue) as Total_Revenue
from mytable group by Group
;quit;
... View more