topic How to consolidate multiple day entries into aggregates. (Similar to Excel Pivot Tables) in New SAS User

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

heyyou1 — Fri, 19 Nov 2021 16:00:46 GMT

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!

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

PaigeMiller — Fri, 19 Nov 2021 16:02:40 GMT

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

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

heyyou1 — Fri, 19 Nov 2021 16:06:57 GMT

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