Adding rows by group

[mmh]

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

Company_ID	Share_ID	Price
1001	01	10
1001	02	20
1001	03	30
1002	01	100
1003	06	20
1003	07	25

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

Company_ID	Price
1001	60
1002	100
1003	45

Thank you in advance for your kind support!

[andreas_lds]

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

[mmh]

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

[PaigeMiller · Accepted solution]

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

[mmh]

Thank you so much Paige!
It works perfectly 🙂