How to consolidate multiple day entries into aggregates. (Similar to Excel Pivot Tables)

[heyyou1]

Hello, I have a dataset with 30k observations. I currently do this operation in excel PivotTables every week but I would love to automate this.

The dataset looks something like this: (I can't show the actual dataset for privacy reasons)

date | location | dosages | other_columns_i_want_to_ignore
...
11/17/21 | A | 3
11/17/21 | B | 2
11/17/21 | C | 80
11/18/21 | A | 1
11/18/21 | B | 5
11/18/21 | C | 3
11/19/21 | A | 3
11/19/21 | B | 10
11/19/21 | C | 1
...

I would like to consolidate this into a table like this:

location | dosages |
A | 7
B | 17
C | 84

Thanks again for all your help!

[PaigeMiller · Accepted solution]

proc summary data=have nway;
    class location;
    var dosages;
    output out=want sum=;
run;

[heyyou1]

That works amazing! Thank you @PaigeMiller, you have been a lifesaver these past few days.