Summarize by Account Numbers

[Mannie10]

Good day

I have a data set that contains account numbers and payments. The account numbers are not unique.

I would like to sum to payments for each account so the account numbers can be unique.

Is this possible? Can you please help me?

All the data has been imported into SAS

[PeterClemmensen · Accepted solution]

Hi an welcome to the SAS Community 🙂

Yes, it is possible. Tons of examples here on the community or online in general. Post an example of what your data looks like. This makes it much easier to provide a usable code answer.

Something along these lines will probably do 

proc summary data=have nway missing;
    class Account;
    var Payment;
    output out=want sum=;
run;

[Mannie10]

works perfectly, thank you

[PeterClemmensen]

Anytime, glad to help 🙂

[Reeza]

Note that I modified your subject line, generic titles such as 'help' don't provide any context to your question and 'urgent' isn't really appropriate for a volunteer user community forum.

[Mannie10]

appreciated, thank you