topic Re: Adding rows by group in New SAS User

Adding rows by group

mmh — Wed, 01 Dec 2021 10:22:24 GMT

Hello,
I am a new SAS user.
I have the following table:

I want to add the rows by group and get the following output:

Thank you in advance for your kind support!

andreas_lds — Wed, 01 Dec 2021 10:42:07 GMT

Do want to add the rows to the existing dataset or just the summary rows in a new dataset?

mmh — Wed, 01 Dec 2021 10:45:15 GMT

Thank you for asking!
I want a summary rows in a new dataset.

PaigeMiller — Wed, 01 Dec 2021 10:53:18 GMT

proc summary data=have nway;
    class company_id;
    var price;
    output out=want sum=;
run;

mmh — Wed, 01 Dec 2021 11:10:12 GMT

Thank you so much Paige!
It works perfectly 🙂