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
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;
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;
works perfectly, thank you
Anytime, glad to help 🙂
appreciated, thank you
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.