topic Re: Urgent, Please help in New SAS User

Summarize by Account Numbers

Mannie10 — Wed, 10 Jul 2019 15:12:20 GMT

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

Re: Urgent, Please help

PeterClemmensen — Wed, 10 Jul 2019 08:22:40 GMT

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;

Re: Summarize by Account Numbers

Reeza — Wed, 10 Jul 2019 15:14:10 GMT

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.

Re: Summarize by Account Numbers

Mannie10 — Thu, 11 Jul 2019 07:58:30 GMT

appreciated, thank you

Re: Urgent, Please help

Mannie10 — Thu, 11 Jul 2019 08:27:11 GMT

works perfectly, thank you

Re: Urgent, Please help

PeterClemmensen — Thu, 11 Jul 2019 08:30:12 GMT

Anytime, glad to help 🙂